cancel
Showing results for 
Search instead for 
Did you mean: 

How can I Upload an Excel file to Build Apps

JulB
Explorer
0 Kudos

Hello friends,

I am wondering what is the best method for uploading an excel file into Build Apps. I have heard you can, in theory, use select file and then use read file. However, in practice I have come across a few obstacles with this solution:

1. I can't read the output of the select directly because it is a "list of objects with 6 properties."

2. I can try to convert it into a base64 but in that it is not useful for my app.(I need plain text)

Any suggestions or workarounds would be greatly appreciated

Thanks in advance,

Julien

Accepted Solutions (0)

Answers (1)

Answers (1)

Venkat_Vyza
Active Participant

Hi @julienbrouss,

First create a Page Variable with the List Type and create 6 properties / objects within it.

Capture the Output in the above created Page Variable.

Thanks,

Venkat Vyza

JulB
Explorer
0 Kudos

Hello Venkat,

Thank you for your kind reply. How can I tell what the 6 properties / objects are that the system is expecting?

Thanks again,

Julien

Venkat_Vyza
Active Participant
0 Kudos

By looking at the fields that are in your excel file.

Thank you,

Venkat Vyza