Copy SharePoint List From One Site To Another

Like (0) Share

Report

Posted on 5 Apr 2024 12:30:13 by ice2921

Hello,

I am trying to copy a SharePoint list from one SharePoint site to another. I have it almost working it copies everything but a column with "Person or Group" type. I researched this a little and it was suggested that I use the Initialize variable followed by an append to array variable. The flow works but nothing populates for that particular column. Flow looks like this:

So I don't think it's actually capturing the array/ contents of the column. Any thoughts? Thanks

All responses (17)

Answers (0)

Ellis Karim 10,955 Super User 2025 Season 1 on 12 Apr 2024 at 15:31:38

Like (0)

Report

Re: Copy SharePoint List From One Site To Another

Hi @ice2921 ,

Unfortunately, the answer is no.

When you set the value of a Person column, that person (i.e. user account) must already exist within MS 365 tenant (Azure AD/Entra ID).

A workaround for you could be to create a new Text column, then populate that column with the display name of the account that don't exists in your MS 365 tenant. This way, you wont loose this user account information.

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site
ice2921 26 on 12 Apr 2024 at 12:12:15

Like (0)

Report

Re: Copy SharePoint List From One Site To Another

how do i copy a user even if they dont exist?
ice2921 26 on 11 Apr 2024 at 22:07:25

Like (0)

Report

Re: Copy SharePoint List From One Site To Another

new error message:
The specified user [{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|user@domain","DisplayName":"user, user","Email":"user@domain.com","Picture":"https://","Department":"","JobTitle":""}] could not be found.
clientRequestId: e4331639-b9d2-48ad-82be-7e05018e1053
serviceRequestId: ac151ea1-b0f0-0000-2c71-a72a71026cf4
Ellis Karim 10,955 Super User 2025 Season 1 on 11 Apr 2024 at 19:04:13

Like (0)

Report

Re: Copy SharePoint List From One Site To Another

Hi @ice2921 ,

Based on what I can see from the output of the Compose action, please try:

Remember to switch map to text mode for the Select action by clicking the icon as shown below:

Here is the output from my demo flow:

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site
ice2921 26 on 11 Apr 2024 at 17:36:30

Like (0)

Report

Re: Copy SharePoint List From One Site To Another

dont know what im missing here
ice2921 26 on 09 Apr 2024 at 16:00:34

Like (0)

Report

Re: Copy SharePoint List From One Site To Another

interestingly I can add the compose action and I get a green check mark:
however, it fails if I add the create item action:
Ellis Karim 10,955 Super User 2025 Season 1 on 08 Apr 2024 at 20:38:44

Like (0)

Report

Re: Copy SharePoint List From One Site To Another

Hi @ice2921 ,

Try searching for the Dynamic content using the search box:

If that doesn't work, add a compose action as shown below, then please share the runtime output of the Compose action:

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site
ice2921 26 on 07 Apr 2024 at 21:24:42

Like (0)

Report

Re: Copy SharePoint List From One Site To Another

Oddly enough I don't have a claims option for the filter array action:
Ellis Karim 10,955 Super User 2025 Season 1 on 07 Apr 2024 at 15:44:40

Like (0)

Report

Re: Copy SharePoint List From One Site To Another

Hi @ice2921 ,

You could try the following flow:

Here are the actions within the Apply to each loop:

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site
ice2921 26 on 07 Apr 2024 at 14:12:53

Like (0)

Report

Re: Copy SharePoint List From One Site To Another

My flow looks like this from a high level:

There is a create item step after this but I removed it until i figure this issue out. If I run the flow as is right now i get the following error: