web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Get max date from Exce...

Power Automate

Answered

Get max date from Excel file with group by

(0) Share

Report

Report

Posted on by PAuser_1-2-3

52

I have an excel spreadsheet containing this dataset:

I want to get the max date of each unique ID in Pending status only. The output should look like this:

How can I achieve this in power automate?

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @PAuser_1-2-3 ，
I have a test for your reference.
In my scenario:
union(body('Select_2'),body('Select_2'))
items('Apply_to_each')['ID'] items('Apply_to_each')['Status'] last(sort(body('Filter_array'),'Modified'))['Modified']
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
PAuser_1-2-3 52 on at

Like (0)

Report
Copy link

Link copied!

Thank you @v-yetonggu-msft . This works perfectly. I just did some minor tweaks like applying the filter in "List rows in present table" action. I also moved the first "Compose" action with Union expression into "Apply to each" action. This helps the flow run faster.

Next, I want to update these two output items into a SharePoint list that contains other 400 items. I want to use ID to link the items in the list. How can I do this?

Was this reply helpful? Yes No

Join the conversation