Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Getting the latest Version of a record in flow

I have a list of Data that I am pulling into flow it has two important fields


Account and Step


the data looks like this


Account 1 Step 1

Account 1 Step 2

Account 1 Step 3


Account 2 Step 1

Account 2 Step 2

Account 2 Step 3

Account 2 Step 4


I only want to pull one record from each account that has the highest step number.


As a Example for the data set above I just want to retrieve these two records


Account 1 Step 3

Account 2 Step 4


How would I query the data in order to get this result


Thanks In advance


Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,793)