Announcements
Hello.
I dont know how ill do this task:
I want to remove the duplicates based on the field "campo", i need to get only unique values on "campo" column but i also need the ID values for those unique "campos", anybody can help me?
This may help you: Power Automate Expression Union – Return Unique Values – Flow Alt Delete – Josh Cook [Microsoft MVP]
@Anonymous
What do you want to do with the ID values?
See my example below. If you want to save of the ID values anywhere, do it right before the Delete item action. The key is to sort by the column with the duplicate values - RefNo in my case. Also, if you have more than 100 items in your list, before to go to the Get items settings and turn on pagination and set the threshold to a number larger than the number of items (5000 max for standard license).
Please check this post also. This may help.
https://powerusers.microsoft.com/t5/Building-Flows/Delete-duplicates-in-a-SharePoint-List/m-p/796999#M110889
Thank you so much, Scott.
That's exactly what i needed, i'm forever in debt with you, if you come to Brazil give me a call!
Scott, got another one for you, is it possible to do this procedure without the sharepoint list just using variables? For example:
Those values I shared are extracted from their source using select on my flow, is it possible to select those values store in a array and do the trick to remove the dupes?
This thread may help you remove duplicates from CSV-like data within a flow without calling on other datasets.
It will also avoid the more inefficient Apply to each looping.
https://powerusers.microsoft.com/t5/Building-Flows/Filter-duplicates-from-CSV-file/m-p/1670607
This template will help find & remove duplicates in any JSON array, based on whichever columns you select:
https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Find-and-Remove-Duplicates/m-p/2191403#M1611
need help for remove duplicate row from sharepoint list.remove record based on the within 2 minutes inserted record we want to delete keep only unique record
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 592
Valantis 340
11manish 284
