Is there a way to use max() to grab the maximum value from a column?
I am using the Excel connector and the "List rows present in a table" block.
I am hoping for something like this:
Otherwise, I guess I'll loop through the keys and append them to an array variable and max that, but the above approach would be quicker.
Thank you for your assistance.
Solved! Go to Solution.
Thank you for your help.
Can I impose for a bit more help, please?
I set up the Select block like this:
Then tried to max Key column. This feels like the same issue I had to begin with.
I tried not using a Key column in Select and maxing the outputs, but no luck with that either.
1. Am I using the Select block correctly?
2. What is the syntax in the following Compose block?
Thank you, again, for your help, abm.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!