How to copy lookup field from one list to another ?

(0) Share

Report

Posted on by jpr23

Hi,

i have 2 lists ( list 1 and List 2 ) with the same lookup field "ColorCode" based on a color-code-list .

The lookup field could have multi values ( not single) . For example : ColorCode = "red", "white", "black"...

The List 2 is a backup from the List 1 .

So i want to copy all the values from the list 1 to list 2 and then to copy of the lookup field "ColorCode" from list1 to List2 .

At the beginning the list 2 is empty .

I don't know if i have to use an array or not .

Please help ...

Thanks

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @jpr23

Refer the below sample flow

consider i am having 2 lists

Data List and DataList2

Here EventID is multichoice column

i need to copy values from DataList to DataList2

I will use below flow

Hope it helps !

Mark it as solution if it resolves your query !

Was this reply helpful? Yes No
jpr23 45 on at

Like (0)

Report

hi ,
thanks for your answer.

In the flow you give me , the Select is ok and catch all the values of the source field , but when i ' am trying to write in an another lookup field i have an error : "The API operation does not allow writing a value for parameter 'item/cp_listappli[0]/value'. This parameter is read only."

In fact, to be more precise , i'm reading a choice field with multi values and i want to write in a lookup field where there are the same choice in a parameter list.
So It is not really a copy from a lookup field to another but an insert of the choice values to a lookup field.

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @jpr23

So you are trying to update a list item based on another list using lookup field right ?

Was this reply helpful? Yes No
jpr23 45 on at

Like (0)

Report

In facts it is ok . I wanted to read a multi choice choice field and to fill a multi values lookup field. So i had sevrals apply to each to read all the values by the select function , to get items in the code list , to catch the ID and then to add to an array variable the ID's read with the syntax "id": ['ID-value']... 😥
So it is working now ...

The new problem is .....the choice field is composed by different values separated by semi column ";" , like a string. It is recognized by sharepoint ( in grid mode to add or remove items ) but not by power automate , which see a unique ID = -1 !! All the choice are seen like an only one value !! tiring !! So i am think how i can translate all the choice field in an real array ...

}

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @jpr23

Sorry for late response !

Can i see the input and output screenshot of what you are trying to achieve, may be that would helps me to understand the actual issue.

Was this reply helpful? Yes No