cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joef
Continued Contributor
Continued Contributor

Empty() not working on all items that meet criteria

Hi All,

I have a FLOW that I created 2 years ago.  last week the function "empty(items('Apply_to_each')?['CompleteDate'])"  stopped working.  I have 125 rows in the list that meet that very simple criteria, I am getting 2 rows returned.  The list only has 300 rows.

 

1)  I have the FLOW set to run every Monday at 9AM

2)  I pull all rows from "openItem" view, this view criteria is CompleteDate = (I left the criteria blank and I only get rows with Empty completeDate in the view).  No difference if I use another view, like "All Items"

     a)  I couldn't figure out the Odata query in the get items.  I don't believe date columns in SPO are truly NULL, and I didn't find an example of ISEmpty() for the "For All" loop.  

3)  This morning, I only get 2 rows returned out of the 125. 

I tried running it a few times and I only get the same 2 rows.  I checked the versions and the date completed was never entered.

Any idea what would stop the FLOW from working? Did something change in SPO lately?  Are there better functions for checking for blank date columns?

 

TIA,

Joe

1 ACCEPTED SOLUTION

Accepted Solutions
joef
Continued Contributor
Continued Contributor

HI @Ian3 ,

I was able to get this FLOW to work correctly now.  

I added "CompleteDate eq null" to the Query Filter in the getItems and removed my condition before sending the alert.  

Thanks for your help,

Joe

View solution in original post

6 REPLIES 6
joef
Continued Contributor
Continued Contributor

I also noticed my for all loop is only getting 100 rows!!!!  

There are 145 in my OpenItems view... 

WTF FLOW?!?!?!?!?

Ian3
Resolver I
Resolver I

You could do @not(empty(trigger body()?[complete date], true))

joef
Continued Contributor
Continued Contributor

Thanks @Ian3 ,

That wont go thru the loop and I am trying to get the empty complete date...

thanks,

Joe

Ian3
Resolver I
Resolver I

Joef 

 
Condition length (trigger body()?['complete date'],0))
 
As 0 is blank and upto 2 is empty could you use this.
 
Condition is greater or equal to 2 
This would be empty until entry made =3 or more.
joef
Continued Contributor
Continued Contributor

HI @Ian3 ,

I was able to get this FLOW to work correctly now.  

I added "CompleteDate eq null" to the Query Filter in the getItems and removed my condition before sending the alert.  

Thanks for your help,

Joe

I used it in condition but forgot to say one curve bracket.

Glad you got it sorted. 

I have tried using @equals(trigger Body()?['...'], null) in the created or modified trigger condition through ... settings of created or modified trigger.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Kudoed Authors
Users online (2,847)