Answered

Flow Failing at Step 16

(0) Share

Report

Posted on by DM-24021454-0

I attached the steps in my flow. Im getting this on the 16th step of my flow before the 17th step which is supposed to send the email. The flow is comparing two sharepoint sites and getting items to send an email to my supervisor of those who have not logged an entry into a weekly workload tracker and then its comparing against a master list. InvalidTemplate. Unable to process template language expressions for action 'Condition_AnyMissing' at line '0' and column '0': 'The template language function 'length' expects its parameter to be an array or a string. The provided value is of type 'Object'. Please see https://aka.ms/logicexpressions#length for usage details.'.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

eetuRobo 4,565 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

As it says in the error the "Condition AnyMissing" is trying to use length() -expression on an object (and length can be only used on an array or string).
So in this example if that compose returns an object it will give same error. So make sure its not an object but an array.

If you can show the output of the object so we can figure out what you need to reference to check the length.

Was this reply helpful? Yes No
DM-24021454-0 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much for your help for the output I am trying to get name and email of those that have not logged a response to my tracker in the last 7 days. I am new to this and trying to figure this out so I appreciate your patience. Hope I grabbed what you needed.

Was this reply helpful? Yes No
DM-24021454-0 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Here is the expression I have there.....

length(outputs('Filter_MissingEmails'))

Was this reply helpful? Yes No
Suggested answer

eetuRobo 4,565 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

So your expression: length(outputs('Filter_MissingEmails'))
And your error is saying that you are trying to use length() -expression on an object.

Your screenshots are not showing the "Filter_MissingEmails" -action which I assume is a compose action. So your "Filter_MissingEmails" most likely returns an object and not empty arrays like your screenshot shows your other actions returning.

For example of an error:

or empty object like this:

Maybe your condition should actually check the length of the HTML_MissingEmployeesTable?

So change the length expression to be: length(body('HTML_MissingEmployeesTable'))

Was this reply helpful? Yes No
DM-24021454-0 14 on at

Like
a
(0)

Report
Copy link

Link copied!

I did change the expression to length(body('HTML_MissingEmployeesTable')) but still failed. I attached some more raw data and the steps in order I have so maybe that can help a bit. In the filter missing emails I am getting email addresses returned, so its not blank. The red is returned email addresses that I blocked out for privacy. Thanks for the help!

Was this reply helpful? Yes No
Verified answer

eetuRobo 4,565 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I did change the expression to length(body('HTML_MissingEmployeesTable')) but still failed.

But it failed further down in the next action

Now the "Condition" actually succeeded to go forward. So the length() -expression did not give error like before. Now the "Send an email" -action is giving the same error. So you are using length expression in that action on an object value which will error since length() can only check the length of an array or string.

So I assume that your "Email MissingEmployees" has the same length(outputs('Filter_MissingEmails')) which gave you an error on the condition.

Was this reply helpful? Yes No