Announcements
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?
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
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?
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 304
David_MA 245 Super User 2026 Season 1
Expiscornovus 243 Most Valuable Professional