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:
- Run a flow once a day
- Determine if more than one record has the same data in field “FEIN”
- Only consider records with “Duplicate Entry” as ‘false’
- Exclude empty/blank “FEIN”
- Send an email to involved parties with specifics (e.g. link to records, creators, etc.)
- (Close the loop) Update duplicate SharePoint items field “Duplicate Entry” as ‘true’ – to prevent future emails
Thank you in advance,
Sean
