How to create dynamic dropdown based on Excel Column?
Options
Best Answer
-
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:
Row template:
columns['Your Column Name']Row delimiter:
\nExample Output field name:
to-text- Reference the output from Step 2. in your Single Choice Choices form field using brackets.
{{to-text}}
1
Answers
-
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