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 Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Kudoed Authors
Users online (1,735)