How to create dynamic dropdown based on Excel Column?
Andrew_106600 Posts: 16 admin
Hi @G_157249 - You can create a dynamic dropdown from Excel by following the steps below:
- Create a Catalytic Data Table from an Excel workbook using the 'Excel: Save spreadsheet to table' action.
- Convert the newly created Catalytic Data Table (from step 1) to text using the 'Tables: Convert data table to text' action and parameters:
columns['Your Column Name']
Example Output field name:
- Reference the output from Step 2. in your Single Choice Choices form field using brackets.
What are the row limits for a long text field versus how many options we can put into a single choice or multiple choice field? Also, wouldn't it be ideal to have a dynamic list right when starting an instance?0