web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows Moving multi-choice co...

Power Automate - Building Flows

Answered

Moving multi-choice column values from Excel to SP List

(0) Share

Report

Report

Posted on by Community Power Pla...

Hi All,

I have a SP list with 45 columns.

13 of which are multi-select choice columns.

Can anybody please share how do I migrate those values using flow to SP List?

Also, can anyone share link for creating child flow in such cases because I do not want to repeat Array Variable steps for all these 13 columns- Thanks

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

abm abm 32,600 Most Valuable Professional on at

Like (1)

Report

Re: Moving multi-choice column values from Excel to SP List

Hi @Anonymous

Create a child flow where you need to pass the multi-select choice values. Split the values by semi-colon and construct an array using the following format

{

"Value": xxxxx

},

{

"Value": xxxxx

}

Finally return the above format via response action method back to your parent flow. Use the response result for mapping the SP list multi-select choice field.

Thanks

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 614 Super User 2025 Season 2

#2

Tomac 401 Moderator

#3

chiaraalina 282

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans