Unanswered

SharePoint List Duplicate Values

(1) Share

Report

Posted on by enomi

Hi all, I need help with identifying when duplicate values are entered into a SharePoint List. Ideally, I'd like the flow to check for duplicate emails, phone # or full names and if it finds the same value already on the list, to notify me. The trigger can be when an item is entered or modified.

Thanks in advance! 😀

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @enomi

Are you looking to compare all in one record (email + phone + fullname)? Or are you looking for email matching in all records or phone matching all records or full name matching any records? Please let me know.

Thanks

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @enomi

Also watch my video tutorial about filtering records in SharePoint.

https://www.youtube.com/watch?v=bSkWdDnhCmQ&t=147s

If you want to compare with more parameters the extend it by using the and operator.

eg of ODATA filter

name eq 'test' and phone eq '34322-3444-2222' and fullname eq 'David Smith'

Thanks

Thanks

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @enomi

https://www.youtube.com/watch?v=mmlHXiD6G98

This video will show you how to find total number of records? So after filtering the records need to check whether any record found or not for duplicate. Add an IF condition and compare against the total number of records.

Thanks

Was this reply helpful? Yes No
enomi 13 on at

Like (0)

Report

Hi @abm I'd like for the flow to compare if the new list item values (email, full name, phone #) already exist somewhere on the list on all other items. My best guess is that an array has to be part of it. Hopes this clarifies it for you.

For example, let say I enter John Smith, jon@smith.com and 800-800-8001 for his phone number, the flow would need to check if any of these column values already exist on the list.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @enomi

Thanks for your reply. So you need to do the 'or' operator. Suppose your field name is called name, phone and email then it should be something like this

name eq 'John Smith' or phone eq '800-800-8001' or email eq 'jon@smith.com'

Then check the record count like I described in my video.

Was this reply helpful? Yes No