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?
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
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
@Anonymous
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
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?
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!
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
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).
What do you want to do with the ID values?
This may help you: Power Automate Expression Union – Return Unique Values – Flow Alt Delete – Josh Cook [Microsoft MVP]
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Telen Wang as our August 2025 Community…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tomac 986 Moderator
stampcoin 699 Super User 2025 Season 2
Riyaz_riz11 577 Super User 2025 Season 2