Answered

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

Like (0) Share

Report

Posted on 23 Jun 2023 14:59:52 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.

I have the same question (0)

All responses (6)

Answers (2)

ThaarA-1424 on 26 Jun 2023 at 17:48:24

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 😊.

Was this reply helpful? Yes No
Verified answer

developerAJ 2,855 on 26 Jun 2023 at 16:24:43

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

Was this reply helpful? Yes No
ThaarA-1424 on 25 Jun 2023 at 07:06:01

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 .

Was this reply helpful? Yes No
Caspar_Rubin 830 on 24 Jun 2023 at 19:00:53

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

Was this reply helpful? Yes No
ThaarA-1424 on 24 Jun 2023 at 16:51:24

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.

Was this reply helpful? Yes No
Verified answer

Caspar_Rubin 830 on 24 Jun 2023 at 08:16:22

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

Was this reply helpful? Yes No