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

Like (0) Share

Report

Posted on 1 Jun 2022 03:57:03 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

I have the same question (0)

All responses (13)

Answers (1)

oxtail 27 on 18 Oct 2023 at 09:03:43

Like (1)

Report

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

Just a note for anyone wondering how I got this to work with great guidance from @creativeopinion One is a multi-select choice field (Fruit) and the other is a multi-select person field (Assigned To)

Was this reply helpful? Yes No
oxtail 27 on 18 Oct 2023 at 07:47:32

Like (0)

Report

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

@creativeopinion that did the trick. Thanks so much. What I didn't realize earlier is that you can have multiple selects and the output would automatically map to the right field in the Create Item. This is what I was asking earlier. An example of my current flow:

This has been a big help. Thanks so much.

Was this reply helpful? Yes No
creativeopinion 10,480 Super User 2025 Season 2 on 18 Oct 2023 at 04:12:55

Like (1)

Report

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

@oxtail you need to change the input mode by clicking on the "T" icon to the right of the drop-down field, then insert the output from the Select action.

Was this reply helpful? Yes No
oxtail 27 on 17 Oct 2023 at 11:10:19

Like (0)

Report

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

@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
oxtail 27 on 17 Oct 2023 at 10:26:31

Like (0)

Report

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

@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
creativeopinion 10,480 Super User 2025 Season 2 on 14 Oct 2023 at 19:49:00

Like (0)

Report

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

@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 11 Oct 2023 at 14:08:06

Like (0)

Report

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

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

Was this reply helpful? Yes No
creativeopinion 10,480 Super User 2025 Season 2 on 16 Aug 2023 at 15:20:46

Like (0)

Report

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

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
nehar 6 on 16 Aug 2023 at 14:56:45

Like (0)

Report

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

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,480 Super User 2025 Season 2 on 16 Aug 2023 at 00:04:13

Like (0)

Report

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

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

Was this reply helpful? Yes No