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:
@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.
@Anonymous
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).
@Anonymous
What do you want to do with the ID values?
Tomac
986
Moderator
stampcoin
699
Super User 2025 Season 2
Riyaz_riz11
577
Super User 2025 Season 2