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
How would I query the data in order to get this result
Thanks In advance
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.