Populating Drop-Down List with Excel data
Comments
-
This can be achieved by getting the excel file to go through a ‘CSV To List Mapping’ step to create a string list. The list will be used to populate the drop-down list.
We’ll map the column ‘firstName’ of the following sample spreadsheet into the drop-down in this example.
In your flow, connect your start step to a ‘CSV To List Mapping’ step. The ‘CSV To List Mapping’ allows us to convert excel data into a list of string values.
[img]https://lh4.googleusercontent.com/UtaSeqXPXUhniAS3zuMjjmVuEFi3AKhEg5cZiGurDZ2c6hDKDpOBIynaCpUt1oyHZrjEBUlV7vU5VK2wrvFlwt6yTNo3_PTSHOndhaehr1vvylpG0o7Q8bFKpGceZvNsYTiW3V9b[/img]
We select our sample spreadsheet.In order to map a particular column of excel file into the string list output, well need to use ‘Item Mapping Editor’.
Using the Item Mapping Editor, we are able to specify that we want the string value from Field02" (column 2) to be passed into the ITEM.
Add a form to the flow with a drop-down list and button. The output for ‘CSV To List Mapping’ step is called ‘Output’ and is used as the input for our drop-down list.
[img]https://lh4.googleusercontent.com/96wRymbS47-QIGBOCnpd1ol9HeBMtU7zunpDiHLaduWtAUkWrC0Kqo1Ju_EPen10Fy7QoshOp-6785qq00MMLU-LLlKvR3NceKtc_Bi_pI0vnUPa1aDvUKm6JqNLuGlIadt4yl4O[/img]Now when we run this flow
Howdy, Stranger!
Categories
- 2.1K All Categories
- 18 General
- 155 Installation / Setup
- 991 Flows
- 86 Rules
- 203 Administration
- 204 Portal
- 433 General Q & A
- 600 Forms
- 282 Reports
- 3 Designer Extensions
- 38 Example Flows
- 32 CSS Examples
- 1 Diagram Tile
- 5 Javascript Controls
- 139 Pages
- 1 Process Mining
- New Features
- 150 Datastructures
- 50 Repository
- 169 Integrations
- 25 Multi-Tenant
- 21 SDK
- 40 Modules
- 38 Settings
- 20 Active Directory
- 12 Version 7
- 34 Version 8