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)

Sort by

Verified answer

abm abm 32,985 Most Valuable Professional on at

Like (4)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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