I have an array of dates and prices and I want to calculate the maximum date.
To get the max function to work I have added an extra column with the datetime as an integer in the select statement:
How do I get the maximum date of this select component?
Extra information:
The date and price arrays are per product. So the flow is using an apply to each component to run over all products and then trying to find the maximum date.
I have used an approach I found somewhere else where an empty variable is initialized and then the date is appended to that variable. This results in a variable with just the dates and not the column title. This way the maximum can be found.
The problem with this approach is in the concurrency. To get the flow to run at a reasonable pace the concurrency control has been set to 50. This means that the variable is overwritten as all the apply to each components are running.
Any suggestions?

Report
All responses (
Answers (