Power Automate

Get Items value is empty when it wants to be

(1) Share

Report

Posted on by ZackS

112

My Flow usually works just fine if the sharepoint Title ID is already there, Get items works great.

The condition is if the title is equal to the dynamic content from the form it will be true, as you can see it works if it's inside the sharepoint.
But if it's not in the sharepoint I get this error

ActionConditionFailed

The execution of template action 'Condition' is skipped: there are no items to repeat.

But we see it's getting the Title eq '88222' just fine but the body value is coming out as [], Any idea why??

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Expiscornovus 33,874 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

[] means that it returned an empty array/collection. In other words, it has returned 0 results.

That means it hasn't been able to find an item with the title 82222. Have you checked if that item exists?

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,978 Moderator on at

Like (2)

Report
Copy link

Link copied!

I want to add, because you are the second person saying this.

IT Is NOT an Error, not even close. It is an informational, telling you that you passed in something that was Blank and therefor it couldn't do its job.

This is the oppositive of an error, although if you EXPECT there to be data, then you need to look at the flow, look at what it was supposed to do, look at the inputs and outputs of everything, if you are calling data from a list or database or flat file, make sure that it is actually there

The number of times someone thought it was "for absolutely positive surety" and were wrong... i'd be rich if I had a nickle each time

Spaces, people messing up the data, changing it bla bla...

Check why the data you thought you have, does not have the details you are calling an error on the action.

Was this reply helpful? Yes No
Suggested answer

ZackS 112 on at

Like (1)

Report
Copy link

Link copied!

It is reading the information, If you can see the screenshot the value of the body should be 82222, since it's not appearing like that it's not working correctly. I've never had this problem until recently.

I have no idea what else to do, I'm asking for help to get it to show the value not for someone saying "this isn't an error"

Was this reply helpful? Yes No
Suggested answer

David_MA 14,497 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

The error indicates that no items were returned from the Get items action that you use in the Apply to each. Before the Apply to each, you should add a condition to check if the number of items returned is greater than 0. You can accomplish this with the length expression, which you can read about at in this blog post How to count number of items returned by SharePoint GetItems action in Flow – Tahoe Ninjas.

Then if returns more than 0 items, move your actions to the yes side. The no side will do nothing and the workflow will end.

Was this reply helpful? Yes No
Suggested answer

ZackS 112 on at

Like (2)

Report
Copy link

Link copied!

Thank you david, You're a huge help.

Was this reply helpful? Yes No