Forum Discussion
Issues Moving a SharePoint List with "Person or Group" columns to another site
Hello everyone,
I am facing a problem while trying to move a SharePoint list from one site to another. The list has approximately 45,000 records and contains "Person or Group" columns with users who no longer work at the company. This prevents me from moving the list entirely because:
- I cannot save the template with the included content: It only allows me to save the template without the content.
- Error when transferring information with Power Automate: When I try to transfer the information, it fails because "Person or Group" columns only allow inserting existing users.
I do not have access to tools like Sharega-t-e, and although I know it can be moved with PowerShell, I am unsure of the necessary permissions or how to do it correctly.
Could someone suggest a solution or alternative method to move this list without losing data and without failing due to nonexistent users?
Thanks in advance!
1 Reply
Hi AS400
i prefer the mention tool in this case, but i know, you can't...
But, when we migrate with this tool, we create a rule to set a default user for values, users who no longer work. I think you need to do the same with Power Automate, to change non exist user to a default user, or as prerequisit, change all values to existing users.
Regards, Dave