Unanswered

Remove Duplicates from JSON

(0) Share

Report

Posted on by spsolutionsgrp

297

I am pulling data in with a custom connector and Parsing the data with JSON. There are a number of fields that I need to keep like "Name", "ID", "Start Date" and "End Date". I need to remove any duplicate ID's only leaving one record for each ID. I know how to remove duplicates for a string of emails but not sure how to remove records when just comparing one of the fields.

Any Help would be great,

Thank you

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@spsolutionsgrp see if this helps

https://thatapiguy.tech/2020/04/04/get-distinct-records-using-the-union-expression-in-power-automate/

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
spsolutionsgrp 297 on at

Like (0)

Report
Copy link

Link copied!

I have used that method in the past to remove duplicate emails. The difference is that I have a record (multiple fields) and even though I can use one field to determine the duplication I need to keep the entire record. Can you show an example similar to my example?

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@spsolutionsgrp not sure how that can be done 😞

Was this reply helpful? Yes No
spsolutionsgrp 297 on at

Like (1)

Report
Copy link

Link copied!

Okay, thanks for trying.

Was this reply helpful? Yes No
takolota1 4,980 Moderator on at

Like (0)

Report
Copy link

Link copied!

@spsolutionsgrp @jinivthakkar

New template that takes in a JSON array & selection of columns and outputs a JSON array where any records with duplicates in the selected columns are removed:

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Find-and-Remove-Duplicates/m-p/2191403#M1611

Was this reply helpful? Yes No