Answered

Copying a Multi-Select Person Picker from One List to Another

(0) Share

Report

Posted on by Jacozin

Hello,

I am trying to copy over a multi-select person field from one SharePoint list to another. I am also copying over various other columns, including multiple choice columns. I'm really struggling to copy over the multi person field. I've tried many things and the closest I've got is copying over one person's name for all of the entries or duplicating entries with different people's names attached to them.

This is the flow I have:

And then in the create item action:

However, nothing seems to happen when I do this. I have another version which is slightly different which caused names to be copied over, but either one name was attached to each entry or entries were duplicated with different employees's names. Here is the flow for that:

expression: union(variables('varAllocUser'),variables('varAllocUser'))

Expression in filter array: string(item()?['Compliance_x0020_check_x0020_com'])

In the create item action, referencing the apply to each 4

Can anyone help with this?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Jacozin ,

This is my raw sharePoint list with a Multi-Select Person :

And this is my target sharePoint list with a Multi-Select Person :

This is my flow:

(1)Get items step :

(2)Initialize variable step :

(3) "Apply to each 2" step :

The result is as follows:

Best Regards,

Wearsky

Was this reply helpful? Yes No
Jacozin 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, thanks for responding!

I tried this but it repeats the same employee's name for every entry rather than copying over the right employee for each case. Here's the flow:

And then in the create item action:

I have no idea what else to try at this point. I'm wondering if it's something to do with the apply for each actions being nested inside each other. The 'apply for each 5' and 'apply for each 3' (see flow above) are both nested inside the first 'apply for each' action.

Any help on this would be greatly appreciated as it's become a huge source of frustration for me.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jacozin ,

Thanks for your quick response !

According to your description and screenshot , you said that you repeats the same employee's name for every entry.

For your "create item" , it seems above it has the "Apply to each3" and you said that the "Apply to each 3" is nested inside the first 'apply for each' action.

I think that's what causes the duplication.My flow is like this , we do not need to use the "Apply to each" above the "create item" :

The create item need to be existed in each row and not need to repeat the iteration. And the variable is used to store the each Persons we selected each row!

Best Regards,

Wearsky

Was this reply helpful? Yes No
Neily53 3 on at

Like
a
(0)

Report
Copy link

Link copied!

Exactly the hint I needed, tysm!

Was this reply helpful? Yes No
RobA1 18 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xiaochen-msft
I followed your flow and it's partially working for me. How do I accomodate for persons that no longer exists? In the 1st list the persons listed may no longer be with the company. When I run the flow it fails in the Create Item, cause the individual no longer exists. So it doesn't copy the entry. This is the error i recieve.

{
"status": 400,
"message": "The specified user i:0#.f|membership|xxxxxx@xxx.com could not be found.\r\nclientRequestId: a8c28ed9-c9ad-4542-becc-d5714c80ecb1\r\nserviceRequestId: b7c13aa1-a082-5000-f18f-3a9b448fca39"
}
Thanks,
Rob

Was this reply helpful? Yes No