web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : wnWoCBqT5dW3TVqVL1I9nQ
Power Automate - General Discussion
Unanswered

How to copy lookup field from one list to another ?

Like (0) ShareShare
ReportReport
Posted on 22 May 2023 09:37:17 by 45

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

  • Nived_Nambiar Profile Picture
    17,961 Super User 2025 Season 2 on 27 May 2023 at 13:13:22
    Re: How to copy lookup field from one list to another ?

    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.

     

     

  • jpr23 Profile Picture
    45 on 24 May 2023 at 09:55:54
    Re: How to copy lookup field from one list to another ?

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


    }

  • Nived_Nambiar Profile Picture
    17,961 Super User 2025 Season 2 on 24 May 2023 at 01:47:20
    Re: How to copy lookup field from one list to another ?

    Hi @jpr23 

     

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

     

  • jpr23 Profile Picture
    45 on 23 May 2023 at 08:31:26
    Re: How to copy lookup field from one list to another ?

    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.

     

    jpr23_0-1684830118315.png

     

  • Nived_Nambiar Profile Picture
    17,961 Super User 2025 Season 2 on 22 May 2023 at 16:57:51
    Re: How to copy lookup field from one list to another ?

    Hi @jpr23 

     

    Refer the below sample flow 

     

    consider i am having 2 lists 

     

    Data List and DataList2

     

    Here EventID is multichoice column 

     

    Nived_Nambiar_0-1684774530122.png

     

    i need to copy values from DataList to DataList2

     

    I will use below flow

     

    Nived_Nambiar_1-1684774596333.png

     

    Nived_Nambiar_2-1684774621412.png

     

    Nived_Nambiar_3-1684774651517.png

     

     

     

    Hope it helps !

     

    Mark it as solution if it resolves your query !

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2