Answered

Power Automate add an existing person or group field from one sharepoint list to another sharepoint list of type person or group

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have 2 sharepoint list that are basically the same list. List A and List B. Once List A item is "Approved" I need to remove it from that List A and added to List B. Both list contain a column called Attendees that is of type Person or Group. I can't figure out the correct way to accomplish this. I have tried Claims and such but then it adds a record for each person listed in the Column of type Group or Person.

If I add any of those options it changes that Create Item to an Apply to Each and adds a record for each person. I have tried multiple different way trying to get that data into a variable or a compose and have that added just once but I haven't been able to figure it out. Any help with this is greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Anonymous

I have not done this before, but I might have a solution for you.
Instead of using append to array variable, Initialize a string variable.
After this, use append to string action and add person's email field in it. At then end add a semi colon, to separate each email address with a semi-colon.
Something like this:
And then use this string variable in the create item. Hopefully it will work. 🙂

Was this reply helpful? Yes No
Verified answer

v-liwei-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @Anonymous

Your second method is already very close to the correct method.
I made a test for your reference (Person column named AssigneeNames)

Best Regards,

Levi

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

Like
a
(0)

Report
Copy link

Link copied!

Thanks man!! That worked liked a charm.

Was this reply helpful? Yes No