SharePoint List - Person and Group column - Old users

Contributor

I've a SharePoint list which I'm migrating to a new production Site.

I'm transferring the old information via Power Automate.

Some Person and Group fields are failing and reporting an error when I do this

 

I've looked into this and there may be an issue with people who have left the business being available to the SharePoint List - I've tried this manually and one of the users who is failing in the PA Flow will not add if I do it manually.

 

Is there away around this as we do need to move this data to a new Production site?

 

Thanks

 

 

7 Replies

Hello @Lee-Martin 

 

that is correct, not existing persons can't add to an people or group person field. I know this issue from migrations with sharegate: https://migration-tool.sharegate.com/hc/en-us/articles/115000643168-User-Group-cannot-be-found-creat...

 

The solution is to map "older" user with a "new" (existing) user during migration, maybe you can do same in your Power Automate Flow during copy....or using sharegate ;)

 

Regards, Dave

@David Mehr

Unfortunately I need to maintain the information as is

Is there any way to do it?

Hello @Lee-Martin

 

i am not sure of this for the existing field, but i'm not an developer...

 

You can write the existing user information in a text field, before you copy the item.

 

Regards, Dave 

If the user does not exist in the destination tenant as an active user, you cannot select them as a value in a column.
@Bharath Arja

They are available in the SharePoint list when I try and add them manually - the list just does not allow me to add them
Can you get a screen shot of where they are available in list when you add manually? Do they show up as an option in people picker search?
The show up as an option.
I select the user
The user doesn't appear in the list column.

The above method works with a user who is still with the business