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)

Suggested answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

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 11,691 Super User 2025 Season 2 on at

Like (0)

Report
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