Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 10

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

  • seanthomasadams Profile Picture
    seanthomasadams 10 on at
    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
  • v-yamao-msft Profile Picture
    v-yamao-msft on at
    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-rest

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard