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
Solved! Go to 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
You can add additional queries to the Odata filter. Like this
(CompletionDate eq null) and (ReminderDate le '@{utcNow('yyyy-MM-dd')}')
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
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?
You can add additional queries to the Odata filter. Like this
(CompletionDate eq null) and (ReminderDate le '@{utcNow('yyyy-MM-dd')}')
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
71 | |
27 | |
22 | |
15 | |
14 |
User | Count |
---|---|
141 | |
43 | |
42 | |
34 | |
30 |