You’re offline. This is a read only version of the page.
2
Hello,
I am new with Power Automate.
I am searching how to get the duplicates from a sharepoint list.
There is a function "union" but that is not the function what i am searching for.
The business case is:
I want to inform the customer when there is an duplicate in the list and i want to send an email what the duplicated entry is.
Thanks in advance!
This template may be easier: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Find-and-Remove-Duplicates/m-p/2191403#M1611
You would just need to remove the last delete step & use the last Filter outputs
So if you import or copy the template from that link, then you can replace the Excel list rows with a SharePoint Get items, add the SharePoint Get items values to the From field of the 1st Select action, input the SharePoint columns you want to use to check for duplicates, then replace the Excel Delete a row action with an action to email the given customer the SharePoint item information.
You can use some of the stuff from this Get duplicates template:
https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Get-and-Remove-Duplicates/m-p/1662426
#1
WarrenBelz
146,618
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,957
Most Valuable Professional
Share
Report
All responses (
Answers (
