Max Date Time value

(0) Share

Report

Posted on by sasrsc

678

Why do I get this... it seems accurate to me...

I have a compose titled LastModified and the syntax is...

max(body('Filter_array')?['Modified'])



The error is...
Action 'LastModified' failed: Unable to process template language expressions in action 'LastModified' inputs at line '0' and column '0': 'The template language expression 'max(body('Filter_array')?['Modified'])' cannot be evaluated because property 'Modified' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'.

My array from Filter Array is ...{
    "body": [
        {
            "Date": "16  Dec 24",
            "Role": "TAS; ACD",
            "Modified": "2024-12-11T14:45:29Z",
            "Staff": "9806d058-8f9e-ef11-8a6a-6045bd070466"
        },
        {
            "Date": "17  Dec 24",
            "Role": "TAS; ACD",
            "Modified": "2024-12-11T14:35:20Z",
            "Staff": "9806d058-8f9e-ef11-8a6a-6045bd070466"
        },
        {
            "Date": "18  Dec 24",
            "Role": "TAS; ACD",
            "Modified": "2024-12-11T14:35:21Z",
            "Staff": "9806d058-8f9e-ef11-8a6a-6045bd070466"
        },
        {
            "Date": "19  Dec 24",
            "Role": "TAS; ACD",
            "Modified": "2024-12-11T14:35:21Z",
            "Staff": "9806d058-8f9e-ef11-8a6a-6045bd070466"
        },
        {
            "Date": "20  Dec 24",
            "Role": "TAS; ACD",
            "Modified": "2024-12-11T14:35:22Z",
            "Staff": "9806d058-8f9e-ef11-8a6a-6045bd070466"
        }
    ]
}

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Max function only works on Integers and Decimals. Try this approach.

This will return you the date with maximum ticks. You will need to convert it back to date.

Solved: Convert ticks value back to date string - Power Platform Community

Was this reply helpful? Yes No
Suggested answer

Ellis Karim 12,247 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi

The max function works on a list or array of numbers:

max(1, 2, 3)

And return this result: 3

In your case you have an array (a collection) containing multiple properties, such as date, modified and Role etc, and the max function can't work with that.

You could try the following expression which uses the sort function, which sorts a collection in ascending order. This should work as the date is really a string:

last(sort(body('Filter_array'), 'Modified'))?['Modified']

Ellis Karim

Blog: https://elliskarim.com

Was this reply helpful? Yes No