I am trying to pass a list of options to an Apps Dropdown list from a CSV file in a Storage Bucket, but I can’t make it work. So far I have uploaded the file into the bucket in Orchestrator, added the Bucket in Apps, created the variable and pass it into the Dropdown “List source”, but I don’t know how to convert the read file into a list of strings so the Dropdown list can read it and display it properly.
The csv file would be something like this one attached: one column, many rows.
The idea is to have that csv file updated, so I need Apps to be able to read the file and display the options in the dropdown list. The file is currently stored in a Storage Bucket in Orchestrator.
I have a one-column csv file with a lot of options that might be updated somewhat frequently (so I cannot afford to manually input the options to the dropdown). I am currently storing the csv file in a Storage Bucket in Orchestrator, and trying to pass it to Apps, but I cannot make it work.
Am I right to say that the process will have to run everytime somebody clicks on the dropdownlist? Isn’t that affecting the response time for the Apps user?