cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

SharePoint - Determining if there is duplicate data in a particular field

Friends,

 

I am stuck and would love your support!  I have not been able to find a solution for this request.

 

I have a SharePoint list with approximately 3000 records.  I have a text field called “FEIN” and a Yes/No field called “Duplicate Entry”

 

Here is what I am looking to do:

 

  1. Run a flow once a day
  2. Determine if more than one record has the same data in field “FEIN”
    1. Only consider records with “Duplicate Entry” as ‘false’
    2. Exclude empty/blank “FEIN”
  3. Send an email to involved parties with specifics (e.g. link to records, creators, etc.)
  4. (Close the loop) Update duplicate SharePoint items field “Duplicate Entry” as ‘true’ – to prevent future emails

 

Thank you in advance,

Sean

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: SharePoint - Determining if there is duplicate data in a particular field

Hi @seanthomasadams,

 

It might be achieved by using SharePoint action Send an HTTP request to SharePoint.

The following doc on working with lists and list items with REST could be your reference:

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-re...

Besides, here is a blog on working with the SharePoint Send HTTP Request flow action, hope it could be helpful:

https://www.chakkaradeep.com/2018/05/16/working-with-the-sharepoint-send-http-request-flow-action/

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: SharePoint - Determining if there is duplicate data in a particular field

Mabel, Thank you for your response. Unfortunately, my knowledge of REST API and JSON is limited. I am hoping someone would be willing to hold my hand through this. If someone could demonstrate the process, that would be incredible. Best, Sean

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (4,840)