Skip to main content
Community site session details

Community site session details

Session Id : t0iV8GvKXPSkCVt7tc0yr5
Power Automate - General Discussion
Unanswered

How to copy the items from a SP-list to another, while having a multiselect person/group column

Like (0) ShareShare
ReportReport
Posted on 18 Jul 2019 09:01:47 by

Hi,

I have a similar problem as he

I would like to copy the content of  a multiselect column type into another SharePoint list using flow. 

I tried to use the "select"- and after that the "join" operation. On every pass of the "apply to each" operation it ads only one and everytime the same user. I'm not sure what the select operation does when i enter this expression:

first(body('Get_items')?['Value'])?['personColumnName']

this expression takes the "claims" inforrmation from the current item:

item()?['Claims']

Maybe someone can help me. @Anonymous @faustocapellanj @v-yuazh-msft 

Thanks in advance.

 

 

  • Tom_Slosse Profile Picture
    1,430 on 18 Jul 2019 at 13:39:50
    Re: How to copy the items from a SP-list to another, while having a multiselect person/group column

    Hey @Anonymous 

     

     

    It is kinda explainable, a lookup (or multi select) are actually IDs so if you want to copy these IDs you would need to compare the IDs of the item that you want to copy with the ID of your lookup list to be able to copy it in a lookup in a new list I think.

    I achieved this with nintex but I would need to have a look if this is achievable with Flow.

     

    But I think if you want to copy anyway there is no need to be a link between the original lookup list and lets say the archive list, you just want to know what has been selected back then. Well I would do it like that, maybe you want the specific lookup values in it I don't know.

     

    Kind regards

     

    Tom

  • Community Power Platform Member Profile Picture
    on 18 Jul 2019 at 12:29:33
    Re: How to copy the items from a SP-list to another, while having a multiselect person/group column

    i now wrote it in a multiline textfield too.

    Too bad there is no solution.. Thanks anyway

  • Tom_Slosse Profile Picture
    1,430 on 18 Jul 2019 at 12:05:04
    Re: How to copy the items from a SP-list to another, while having a multiselect person/group column

    Hey @Anonymous 

     

     

    The list where the copied content will be saved, does it have the same content type and fields in it?

    It is possible to copy multi values to another list because I already did that once if I remember correctly.

    But I copied the content to a multi line of text because copying values from a multi select to another multi select will not work.

     

    Hope this helps a bit.

     

    Kind regards

     

    Tom

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

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!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Loading started
Loading complete