Unanswered

Copy SharePoint List From One Site To Another

(0) Share

Report

Posted on 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

Categories:

Building flows

I have the same question (0)

All responses (17)

Answers (0)

Ellis Karim 11,983 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @ice2921

If this is a is a People Only column and multiple people selections are not allowed, then you can simply use their email address:

To update a People column where multiple selections are allowed we must use an array as you seem to have done.

The array must be formatted as an array of JSON objects as the examples below will illustrate.

To help debug the problem, please add a compose action containing the array variable. Then examine the content of the compose action after the flow has run.

Please share the output of the compose action.

For more info, see:

🚹SharePoint People Column : How to Update and Patch in Power Automate and Power Apps – Ellis Karim's Blog

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

Was this reply helpful? Yes No
ice2921 26 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the response. I think that I have another issue here in that some of the original users are not valid users anymore so Im not sure if that will break things. Ideally in that case i Would just like to copy the text data but I dont know if thats possible on a people or group column type. Secondly, the original column type allows for multiple selections. Finally, I added, the compose statement is I got the following results:

Was this reply helpful? Yes No
Ellis Karim 11,983 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @ice2921 ,

You must use a valid user account that exists in your Azure Ad/Entra ID or any Create/Update actions will fail with an error.

If the claims value is null, the flow will likely run, but no change will be made to the person column when creating or updating an item.

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

Was this reply helpful? Yes No
ice2921 26 on at

Like (0)

Report
Copy link

Link copied!

Thanks. So I guess I have no way to add removed users. Is the reason that the flow is placing nothing in the column because a user does not exist? Does it just stop if one user does not exist?

Was this reply helpful? Yes No
Ellis Karim 11,983 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @ice2921 ,

(1) If the user does not exist in your Azure AD/Entra ID the flow will error: "The specified user ####### could not be found":

(2) If the claims value is null (i.e. the claims has no value set), the flow will run but no change will be made to the person column when creating or updating an item:

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

Was this reply helpful? Yes No
ice2921 26 on at

Like (0)

Report
Copy link

Link copied!

I'm mostly getting the null behavior, but I do know that there are many users that exist. So it must be something else.

Was this reply helpful? Yes No
Ellis Karim 11,983 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @ice2921

Can you share screenshots of the action where you get the Attendee value from (i.e. the source action).

If users exist, then the Attendee value should not be empty or null.

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

Was this reply helpful? Yes No
ice2921 26 on at

Like (0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
Ellis Karim 11,983 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ice2921 26 on at

Like (0)

Report
Copy link

Link copied!

Oddly enough I don't have a claims option for the filter array action:

Was this reply helpful? Yes No