Unanswered

Copy multi choice and person column from one list to another list using power automate

(0) Share

Report

Posted on by om3r

I am trying to copy list items from list A to list B which has many columns including multi-select choice and person.

I am have created a flow that copies the data from list A however in the Create Item part of the flow, selected values of all the rows is getting copied in each row. I have tried adding Set Variables [] in the final step, what it does it, it pastes all the selected values of each row into first row of that column.

How can I get this sorted?

Destination List

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (2)

Report

Hi @om3r ,

I did a sample for you.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Fresh 😎

Was this reply helpful? Yes No
nehar 6 on at

Like (0)

Report

This is not working. Output comes as

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

What does your flow look like? Can you upload a screenshot?

Was this reply helpful? Yes No
nehar 6 on at

Like (0)

Report

It's exact copy of what you said in the conversation. But for my list it's showing data as= above screenshot with all [[ and quotes

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

You need to use a key value in your Select action. With the key being Value.
Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No
oxtail 27 on at

Like (0)

Report

@creativeopinion does this approach also work for a multi-select person column?

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@oxtail Yes. However, you will need to use a Claims key instead of a Value key—and the dynamic content must be an email address.
In the From field, you want to insert the dynamic content for the multi-person column. In the key field, enter Claims.

Important: When you select the email address dynamic content to insert into the value field. Power Automate will automatically nest the select action inside another Apply to Each action. I don't know why this happens—but it happens automatically.

You need to PULL your Select action outside of that automatically added Apply to Each action. Then delete that automatically added Apply to Each action (it's not needed).

Your Select action should be nested inside your Apply To Each action that is looping through each SP list item.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No
oxtail 27 on at

Like (0)

Report

@creativeopinion This worked perfectly. Thanks so much. I only tested with one of my columns. I have about 3 columns that are multi-selects. Do I put an initialize variable before each Select? I've attempted to do this but get an error The operation 'Initialize variable' can only be used at top level.

Was this reply helpful? Yes No
oxtail 27 on at

Like (0)

Report

@creativeopinion I stand corrected. It was working. Now I'm not sure why I'm encountering the same issue user @nehar was seeing.

Was this reply helpful? Yes No