Answered

How to filter duplicated IDs and take first record in Power Automate?

(0) Share

Report

Posted on by marycarmenvv

Hi, I have a dataverse in Power Automate. The dataverse file has two important columns, the ID column and the date column.

The ID column has duplicates for each ID with different dates. I need the most recent record of each ID based on the date added. I need to sort by descending, "filter by duplicates", and take the first record. I am not sure how to approach this, since I am new learning power automate. I have already applied the sort by descending, but the rest I'm stuck on how to apply the logic.

I will appreciate very much any help. Thank you!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

AhmedSalih 6,680 Moderator on at

Like (1)

Report
Copy link

Link copied!

hi @marycarmenvv, there is another community forum for Power Automate you might also check for your issue:
https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider Accepting it as the Solution to help other members of the community find it more.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @marycarmenvv ,

I've made a test for your reference:

1\My table

2\My flow

1)body('Filter_array')[0]

The deduplication result will be saved in the variable TheResult.

Best Regards,

Bof

Was this reply helpful? Yes No
marycarmenvv 15 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much!

Was this reply helpful? Yes No