Answered

How do i get the max date from Select output?

(0) Share

Report

Posted on by cheekyv

Hi all, i need to get the max date from an array. I'm trying to not use a variable as i want to run the apply to each this is within as max concurrency.

{

"body": [

"2022-06-01",

"2022-06-30",

"2022-06-01",

"2022-06-10",

"2022-07-13"

]

}

Tried 'Max(body('Select'))' and get an error

'The template language function 'Max' expects all of its parameters to be either integer or decimal numbers. Found invalid parameter types: 'String'.'.

Any ideas?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

David_MA 14,078 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
You will need to get rid of the hyphens in the dates and format them as an integer. You can then use a compose action with an expression to return the max value. Your flow will look like this:
The expression in the select statement to format the Created date is, which you will need to switch to map mode to enter:

int(formatDateTime(item()?['Created'],'yyyyMMdd'))

And the formula in Compose is:

max(body('Select'))

Was this reply helpful? Yes No
cheekyv 28 on at

Like (0)

Report
Copy link

Link copied!

Ah, ok... so i end up with 20220713 as the result. How do i convert that back to a date?

Was this reply helpful? Yes No
David_MA 14,078 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I suppose you could just add another action to generate what you were originally doing for your date format and use the above just to get your max date value.

Was this reply helpful? Yes No
cheekyv 28 on at

Like (0)

Report
Copy link

Link copied!
Hi, i ended up adding a second compose 🙂

concat(substring(outputs('Pick_MaxDate'),0,4),'-',substring(outputs('Pick_MaxDate'),4,2),'-',substring(outputs('Pick_MaxDate'),6,2))

Was this reply helpful? Yes No
Matthy79 4,188 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello,

I know it is been solved and the last post has been a while but I would suggest to do it like this:

last(sort(outputs('Compose_sample_output')['body']))

Of course instead of "outputs('Compose_sample_output')" you have to put in the action you are getting this object from the first post.

Was this reply helpful? Yes No
CU06081659-0 134 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I have to create a Flow based on the below 2 conditions. The file names are always in 'XYZ_ddMMyy.xlsx' format.

Condition 1: If the file is not more than 14 days from today then it should be kept as it is
Condition 2: If the file belongs to the last day of every month or it is the last file of that month whether it is on last day or not then it should be kept as it is

I have been able to identify the 1st condition fully and also the 2nd condition partially i.e. whether the file belongs to the last day of the month or not. The portion which I am not been able to create is if the file doesn't belong to the last day of the month but it was the last file that we had received for that month. E.g. if we may have received a file on 24th and it was the last file that we had received for that month then this too should be considered. I mean I need the file with the MAX date for a month. This should be done for each of the months.

I am attaching the screenshots of the Flow and would appreciate if anyone can help me.

1st Compose Action: FilenameWithExtension
2nd Compose Action: substring(outputs('Compose_-_File_Name_with_Extension'), 25, 6)
3rd Compose Action: formatDateTime(concat('20', substring(outputs('Compose_-_Extracted_Date'), 4, 2), '-', substring(outputs('Compose_-_Extracted_Date'), 2, 2), '-', substring(outputs('Compose_-_Extracted_Date'), 0, 2)), 'yyyy-MM-dd')
4th Compose Action: formatDateTime(addDays(startOfMonth(addDays(outputs('Compose_-_Formatted_Date'), 1)), -1), 'yyyy-MM-dd')

Thank you.

Was this reply helpful? Yes No