Compare 2 Sharepoint Lists and add missing Person

[andyJDL]

I have two Sharepoint Lists, each with a Person column (an O365 user).  I need to compare the two lists, and if a Person is missing from List 2, I need to add them as a new item.

I've tried multiple options but all seem to come back with an error saying it can't create a duplicate item, when the name is already there.

The flow looks like this roughly:

• Get Items from list 1
• Get Items from list 2
• Condition, if Person from list 2=Person from list 1, do nothing.  If not, Create Item in list 2

Suggestion?

[v-bofeng-msft · Accepted solution]

Hi @andyJDL :

Could you tell me:

Do the person columns allow multiple selections?I assume they do not allow multiple selections. I've made a test for your reference:

1\My data source:

2\

The Result

Best Regards,

Bof

[andyJDL]

Thanks.  However I'm getting the same result (duplicate).  Just to simplify things, I am using a Person column that does not allow multiple choices.

In your example, do I need to be using a particular aspect of the Person field (Person, Claims, DisplayName, Email, etc)?

[andyJDL]

In case it's helpful to check my work:

[v-bofeng-msft · Accepted solution]

Hi @andyJDL :

   According to the screenshot you provided, I can roughly determine that the person column allows multiple selections when you create this flow.(Because there is an "apply to each 3")

   Considering that you have set the person column to not allow multiple selections. I advice you to recreate a flow and then use Claims to update the person column.

  Best Regards,

  Bof

[andyJDL]

Thanks.  That did it.  Any way to make it work on a Person field that does allow multiple selections?

[andyJDL]

Never mind.  Thanks again!

[mb_cm]

Hi, 

Anyone knows how to do this but without duplicating the value in the second list. I mean how to copy a person name from one sharepoint list to another and it the name have been already registered in the second list don't add it again. 

I have my query better explained here: COMPARE 2 SHAREPOINT LISTS AND ADD MISSING PERSON WITHOUT DUPLICATE IT 

Thank you, 

Kind Regards