Announcements
119
I would like to build a flow that checks for duplicate ID’s each day. If any duplicate ID’s are located I would then like to send an e-mail with the ID and the entry name. How could I achieve this with a recurring flow? Thanks!
@creativeopinion Hi - ideally I would like to run a recurring flow everyday to check for duplicate ID/reference numbers in a SharePoint list. I would then like to send an e-mail that contains the ID/reference numbers. No deletion required via the flow. Thanks!
@Jon2787 No worries. Can you provide more details? There isn't much to go on in your original post. What is the flow checking? A SP List? An Excel Table? Something else? How do you determine which item to delete?
The more details and insights you can provide—the easier it is to provide recommendations.
@Jon2787 Are you checking for duplicate ID's in a SharePoint list? If so, have you considered toggling on Enforce unique values for your column? This way duplicate ID's wont be entered at all.
If you are looking for a way to send multiple SharePoint List items that have been assigned to a user in an email—check out this YT Tutorial: How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow
IN THIS VIDEO:
✅ How to send multiple list items in a single email with a Power Automate Flow
✅ How to create a dynamic date range
✅ How to use the Convert Time Zone action
✅ How to use a Filter Query in the Get Items action
✅ How to count number of items in an array
✅ How to use the Select action to extract a users display name and email address
✅ How to create a unique list of email addresses
✅ How to use the Create HTML Table action
✅ How to customize the HTML Table with CSS styles
✅ How to use the Send an email (V2) action
✅ How to use the Append to String Variable action
✅ How to create a custom list of items for an email
✅ How to use the Send an email (V2) action
✅ How to display singular or plural text based on the number of items returned
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
