Populating Drop-Down List with Excel data

Unknown

Populating Drop-Down List with Excel data

Unknown

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.

[img]https://lh6.googleusercontent.com/q3chIrJyO8sAeuYoINWJtR9w85w_rjPo2Z2lNrytFaHRl5V_aRo8Q7MX5lCCMjeOO0pRBdRrrFX4FjhqTLScO4YNTac5wnp7s3_k3taQCPFEbqfhEGn4qf5HXO6U4QxjuzdXfg3l[/img]

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.

[img]https://lh6.googleusercontent.com/kUFGRaeX86dtpbTEJ733BFn6J2ekicQT-SfysaL1d8sHSDf2C3kYYDiUvahENxfzxyA2isq5JnMId8ESYbrVEV_PZe0dFOCp62DPcjVJJ20rThF5M1QKNwPCXP3jFIk5vhBBaZLk[/img]

In order to map a particular column of excel file into the string list output, well need to use ‘Item Mapping Editor’.

[img]https://lh3.googleusercontent.com/RIj3D6nDQhztqMB_8Bc4-SWNAsG39Wa5BdVUhs0PiyuQuOtl-G4_bQqvKBle_78-BHP8f-CVGiAKUG-Jsfkhsb8l_cjKk399imVa_u5hilKLeNkzibWRpuQfmmCbXHijtKBMOyRi[/img]

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.

[img]https://lh6.googleusercontent.com/ubgxf66hwGj2mB_OkdFy0QbtkhhFJbBI_KhQST_R7HuHGsqDDykxT_RAjve6aiyIWNNFcEWBK8Fqtg2shjRqOu1yoJYgzo9OCZfl7Zwl2bSl_pvyDzI5lRv4as9vg8xAlzMSmnyL[/img]

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