Recurring flow

[Adam_Lpl]

Hi 

I'm getting stuck on a recurring flow and hoping somebody can help.  The flow was built to cycle through the data on a sharepoint list 3 times a week and send an email provided that the reminder date was exceeded and the completion date was blank.

The first thing i'm getting stuck on is the OData filter.  I tried Completiondate eq 'null' with 'null' being an expression but it didn't like that and returned a date format error.

The second thing is that the reminder email is being sent for every item in the list not for the specific items required where reminder date was exceeded and completion date is blank.

I've copied my flow so far below.  I'd really appreciate any help.

Thanks

Adam 

[Pstork1 · Accepted solution]

The key here is that its an ODATA query so you aren't actually looking for the function Null.  Just use the keyword null without single quotes.  Like this

Completiondate eq null

[Adam_Lpl]

Thanks that worked perfectly.  Can I just check on the other part about receiving emails for all items not complete on the list even if the reminder date hasn't passed?

[Pstork1 · Accepted solution]

You can add additional queries to the Odata filter.  Like this

(CompletionDate eq null) and (ReminderDate le '@{utcNow('yyyy-MM-dd')}')