DropDown with excel

DropDown with excel

Hello Community,

I found examples populating one drop down but asking user which file to upload.
How can i populate one dropdown with an excel file that is always the same?

I will appreciate your help.
Hi Sérgio,

First of all welcome to the OutSystems community.

I'm assuming that you can reach this excel file in your filesystem, so the way to do what you want is to use the FileSystem extension (search for it) ans use the ReadBinary action to retrieve the excel's binary content. Next all you have to do is feed this binary data to the ExcelToRecordList widget so that you can have a record list to assign to the drop down widget.

I hope this was clear enough and that it helps you do what you want.

Keep coming back to community forums to solve your issues and to help others solve theirs.
André Vieira