I have a number of reasons to retrieve a single record from Excel tables based on filters and sort (like getting the latest record with certain filters), so this will be a design pattern for me. The simple Get Record does not have sort and filters, and I am having problems getting the specific data elements from the excel record any other way.
My plan is to encapsulate the "List Rows Present in a Table" action in a flow with an HTTP trigger, to save some of the steps from having to be done in multiple contexts. With this design, I can see the HTTP body and the data in it in the calling flow, but I have not found a way to access one field in that record. Even if I store it in an object variable, I haven't found a way to access the fields in the object afterwards.
Solved! Go to Solution.
Could you share the run result of the HTTP call?
If you want to get the Last record, you can consider use the variable to hold the Last record, set it's default value as the first record.
Then use the Apply to each to compare current item from "List Rows Present in a Table" with the value of last variable, if it is greater than last variable, set the last variable as current item, if it is less than or equal to , find the next item.
After the loop, the last variable will be the last record.
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I just realized I posted twice on this subject. The other post is https://powerusers.microsoft.com/t5/Building-Flows/Excel-Get-Latest/m-p/394499#M44942
Here are details on my example:
My called flow does the following:
My calling flow does the following:
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!