Unanswered

Flow fails in Apply to each with Expresion Evaluation Failed error

(0) Share

Report

Posted on by JR-BejeweledOne

5,836 Moderator

I have a flow that will be comparing a date in a SharePoint list and more than 2 years old a status will be set in the item.

I have tried various solutions for evaluating the date, but I am getting this error:

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each_2')?['ID']' is of type 'Integer'. The result must be a valid array.

The first formula in the conditon:

formatDateTime(outputs('LastComplete'),'yyyy-mm-dd')
 
The second formula in the condition:formatDateTime(addDays(utcNow(),-730),'yyyy-mm-dd')

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

David_MA 13,504 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You need to use the format 'yyyy-MM-dd' with capitalized letter Ms. Lowercase mm returns the minutes value.

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!

I made the change but am still getting the same error.

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

Like (0)

Report
Copy link

Link copied!

I should have noticed this before. Is your LastComplete field a DateTime field? If so, you need to put that field in the first part of the condition without using an expression. It will automatically understand it is a date/time field and use the ISO8601 format and allow you to do a less than or equal to comparison. By using an expression, it treats it as a string, in which case you would only be able to use either is equal to or is not equal to in the condition.

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!

Same problem.

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

Like (0)

Report
Copy link

Link copied!

I am stumped then. Hopefully someone else has an idea for you. Good luck.

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!

I think it has some thing to do with the fact that I am doing this in an Apply to each loop.

Was this reply helpful? Yes No