How can I Upload an Excel file to Build Apps

[JulB]

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

[Venkat_Vyza]

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]

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]

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

Thank you,

Venkat Vyza