web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

If empty?

(0) ShareShare
ReportReport
Posted on by 32

Hi! This is my current flow expression which finds the items in the list that are todays date & manager approved and sends the individual an approval asking for feedback. My flow is working but is sending multiple emails as it is stuck In a loop. 

(Date_x003a_ ge '@{addDays(utcNow(),-1,'yyyy-MM-ddT00:00:00.0000000Z')}') and (Date_x003a_ le '@{addDays(utcNow(),-1,'yyyy-MM-ddT23:59:00.0000000Z')}') and (Managerapproved_x003f_ eq 1)

 

 is there a way I can add in another filter to the above which says If a certain column is empty? So it only picks up thw people who haven't already completed the approval? 

 

the column name is: Postactivityreflection_x003a_

 

thankyou! 

Categories:
I have the same question (0)
  • lbendlin Profile Picture
    8,479 Super User 2025 Season 2 on at

    use 

     

    and Postactivityreflection_x003a_ eq null

  • Atennantsp Profile Picture
    32 on at

    Thanks for your help @lbendlin! Unfortunately I am receiving the below error message if you know what this means? 

     

    The field 'Postactivityreflection_x003a_' of type 'Note' cannot be used in the query filter expression.
    clientRequestId: 53eb8902-95f4-4efb-ad88-69daf1379c9f
    serviceRequestId: 53eb8902-95f4-4efb-ad88-69daf1379c9f

     

    Atennantsp_0-1694423629064.png

     

  • lbendlin Profile Picture
    8,479 Super User 2025 Season 2 on at

    As it says in the error message - the ODATA filters only work with very simple column types. Yours isn't.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard