Unanswered

Getting multiple choice/lookup columns values when creating csv table from PowerApps

(0) Share

Report

Posted on by jeanleelm12

i have created a flow based on Reza's video on Export Power Apps data to Excel in CSV format. I am able to successfully to create the CSV file with the flow and have no issues getting values from text columns or single choice values. However, i am not able to get the values for 4 columns which are Choice/lookup fields which allow multiple selections. Can anyone advise how do i get the values for multiple choice/lookup field in flow.

The 4 columns which are choice/lookup are
Role, Mode of Support, T&M Support Location, MSP Support Service Required. Formula i used for single choice column like item()?['Column Name']['Value'] does not work for multiple choice/lookup columns.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

fchopo 8,003 Moderator on at

Like (0)

Report

Hi @jeanleelm12

For each of the multi-value choice columns you mentioned, you need to:

1) Declare a variable

2) Get the value of the column

3) For each value (apply_to_each)

4) Append the value to a string variable plus a ";"

5) Show the variable value in the create CSV Table.

Hope that helps!
Ferran

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report

Are you after the ID or the value? in your CSV?

Was this reply helpful? Yes No
jeanleelm12 5 on at

Like (0)

Report

I am after the value for the 4 mentioned columns. As these 4 columns are choice or lookup columns with multiple selection, they now appear as i.e. [{"Value":"Review & Approval"}] in my CSV report. I read from some other sites they mentioned can use concat function but I am not familiar with concat in Power Automate.

Was this reply helpful? Yes No
Verified answer

Paulie78 8,422 Moderator on at

Like (1)

Report

This was an interesting question, I made you a video response to explain the solution:

How to work with multiple choice/lookup columns values when creating CSV table in Power Automate

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘

Was this reply helpful? Yes No