Answered

how to update the column values from one list to another list using flow

(0) Share

Report

Posted on by ThaarA-1424

Hello,

I have two list . list1 have 3 person type column( per1,per2,per3) which not allows multiple selection . list 2 have one person type column (per1) which allows multiple selection . list 1 is patched from list 2 so both has same item , when an item is created in list1 , I want to update the column values from list1 (i.e. Per1,per2,per3) columns to list2 (per1) columns .

Help me to figure out this,

Thanks.

All responses (6)

Answers (2)

ThaarA-1424 on at

Like (2)

Report

Re: how to update the column values from one list to another list using flow

Thanks you both @developerAJ , @Caspar_Rubin .
Now it is working as expected, Thank you for your time and solution 😊.
Verified answer

developerAJ 2,855 on at

Like (2)

Report

Re: how to update the column values from one list to another list using flow

you need to store email in person3 column or create another column to store email

than append to arrayvariable3:

{
"Claims":concat('i:0#.f|membership|',urperson3emailcolumn)
}

concat use as formula not text

Please click Accept as solution and give it Thumbs Up if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
You can connect with me on LinkedIn
ThaarA-1424 on at

Like (0)

Report

Re: how to update the column values from one list to another list using flow

Hello @Caspar_Rubin ,
Per3 contains the display name of the user or person.
Single line of text is the type of Per3 column in list .
Caspar_Rubin 830 on at

Like (1)

Report

Re: how to update the column values from one list to another list using flow

Hey

what value is in your per3 column? what do you mean by single line of text? Is it an email address of a person or just text like for example "test test"?

It must be a valid identifier of a person (ID, E-Mail or Claims) to be able to be added to the ListB in a multi-person field...

cheers
ThaarA-1424 on at

Like (0)

Report

Re: how to update the column values from one list to another list using flow

Hi @Caspar_Rubin ,
Thank you for the response, this is what I'm looking for, instead of creating item, I need to use update item .
Having one more doubt ,In list A the per1 and per2 is person type and per3 is a single line of text, in this case how I get the values in per3 in people column in list B . I have tried to Initialize a string variable and append to string variable, but in update item ,I cant able to add the string variable to the people column , which allows array variable only , If I switch to string variable then I can't able to add array variable . I need all the values in people column (per1,per2,per3).

Thank you.
Verified answer

Caspar_Rubin 830 on at

Like (2)

Report
Re: how to update the column values from one list to another list using flow

Hey

I hope I understood correctly...

List A:

List B:

Flow:

Basically Initialize a new Array variable called people.
Add the Person1, Person2 and Person3 using Append to array variable actions with this Value:

{ "Claims": @{triggerOutputs()?['body/Person1/Claims']} }

Make sure you use the Claims value from the Dynamic Content Dropdown, not the Display Name or something like that...

Result: List B after i created a new item in List A:

cheers