Unanswered

If empty?

(0) Share

Report

Posted on by Atennantsp

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!

All responses (3)

Answers (0)

lbendlin 7,799 Super User 2025 Season 1 on at

Like (0)

Report

Re: If empty?

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

Like (0)

Report

Re: If empty?

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
lbendlin 7,799 Super User 2025 Season 1 on at

Like (0)

Report

Re: If empty?

use

and Postactivityreflection_x003a_ eq null