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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.
The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.