Create string from array (multiple choice sharepoint column)

(0) Share

Report

Posted on by misc

588

I have a flow which populates an excel table from a Sharepoint list.

I have added a new multiple choice column to the SP list which also needs to be transferred to the excel report, but because it is an Array it shows all the code eg.

I just want to convert the Array Value to a Text String for passing to the excel file, but everything I've tried has come back as an error.

I can't just put in the Value because it adds an apply to each and will duplicate lines with more than one choice.

Most of the articles I found suggested initialising a string variable, and appending the Value of the choice column to the variable, but the dynamic content only gives me the option of the overall column and not the Value. I don't know what I'm missing!

Any help is greatly appreciated

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (4)

Report

Hi @misc

I have made a tutorial video about this.

Power Automate - How to extract SharePoint multi-select choice field text values? - YouTube

If you need further help in this please let me know.

Thanks

Was this reply helpful? Yes No
misc 588 on at

Like (1)

Report

Thank you so much - this worked! I searched for hours yesterday and couldn't find anything which mentioned the Select action.

Just one little note if anyone comes along to read this after - initially I thought this didn't work because I couldn't add the output into the 'Add Rows' action, but I just had to move the Add Rows into the apply to all with the Select/Join, instead of outside.

Was this reply helpful? Yes No