SharePoint List - Person and Group column - Old users

[Lee-Martin]

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

[#2]

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

[#3]

@David Mehr

Unfortunately I need to maintain the information as is

Is there any way to do it?

[#4]

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 

[#5]

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

[#6]

@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

[#7]

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?

[#8]

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