How to Identify duplicates from Multiple columns in SharePoint list?

[Chengappa2488]

Hello Everyone,

I currently have a SharePoint List with multiple columns with Reviewer Names and I am trying to build a flow where its able to identify duplicates that is if a name is repeated more than once in any of the Reviewer columns. Below is an example of the SP list layout:

Title	Reviewer_1	Reviewer_2	Reviewer_3	Reviewer_4	Reviewer_5	Reviewer_6	Reviewer_7
Task ABC	John	Garry	Tom	Sam	John	Tom	Smith

above the names (John and Tom) have been used more than once, Please can somebody give me any ideas on how to capture this in Flow.

Since once the duplicates are identified, I would further use it to update another list stating Duplicates Found.

Thanks

[fchopo]

Hi @Chengappa2488 

You could do something like this:

1) Get items from sharepoint

2) For each item

3) Get the email address value of the reviewer for each column, add it to an array, and use the union operator. Union operator removes duplicate values.

4) If the number of items of the union operator is equal to 7 (in this example, 3) it means that all values are different, if not, it means there are duplicate values.

The expression use to detect duplicate among 3 columns is the follwing:

union(union(array(items('apply_to_each')?['Reviewer1/Email']),array(items('apply_to_each')?['Reviewer2/Email'])),array(items('apply_to_each')?['Reviewer3/Email']))

Hope it helps!

Ferran