cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
studart
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

0 REPLIES 0

Helpful resources

Announcements
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)