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
JP
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.
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 ...
}
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.
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 !
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2