PROBLEM TO EXPORT MULTIPLE CHOICE COLUMN IN POWERAUTOMATE

(1) Share

Report

Posted on by SD-19090927-0

I would like to export my SharePoint list to XLSX via a PowerApps application using Power Automate.
The problem I'm encountering is that my SharePoint list has multiple-choice columns, and I can't insert them into my Excel file. When I use the “Apply to each” loop, at the end of the loop all the elements are concatenated into a single string, whereas I should have them line by line.

Capture d’écran 2...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

I have the same question (0)

All responses (1)

Answers (0)

Michael E. Gernaey 50,275 Super User 2025 Season 2 on at

Like (0)

Report

PROBLEM TO EXPORT MULTIPLE CHOICE COLUMN IN POWERAUTOMATE

Hi @SD-19090927-0

Just to clarify, are you personally concatenating the "value" or "text" to comma separate them with a join? or are you referring to the fact that it puts the entire JSON { } of all the choices selected?

And when you say, you want to have separate lines, do you mean you want the entire sharepoint line repeated for each choice in the column? or do you mean you want a carriage return between each "value" or "text" of the choice, where value is the ## and text is the text?

If you paste pictures in it will defintitely come through.

Was this reply helpful? Yes No