Hi All,
I need some assistance with the OData filter for a scheduled flow.
The purpose of the flow is check the status of overdue/upcoming maintenance tasks, and then send an email to the 'Assigned To' person. As it's a maintenance register (and will have many line items) the filter should be:
For context, when I leave the ODATA filter field blank - the test is successful. However, as soon as I enter the below code into the ODATA filter field, the test fails.
The filter that I am trying to use is: Due Date le' addDays(utcnow(),30,'yyyy-mm-dd') ' and Status ne 'Completed'
Due Date and Status are the column names in the corresponding maintenance register (list).
When the filter is added it looks like this:
I have checked the column settings in the corresponding maintenance list and the Time is not turned on.
Troubleshooting:
The Error Message is (or some variation of):
I dont understand how something so simple is not working. Any help in resolving this issue would be appreciated.
Thanks
Amanda
Hi @v-yueyun-msf,
Thank you for your response. I have checked the steps you outlined, and made the changes, and also identified an error in my expression (I had used lowercase for mm, when it should have been MM).
For reference, the correct expression is: <listinternalcolumnname> le' addDays(utcnow(),30,'yyyy-MM-dd') and <listinternalcolumnname> ne '<listcolumnfield>'
Again, thanks for your assistance.
Amanda
Hi , @TOP4178x
First,You need to use the internal SharePoint column name in the FIlter Query property.
You can find the internal SharePoint column name here:
Second , you have a space after the ':
DueDate[Here you need to use internal name!!!] le 'Yourexpression' and Status ne 'Completed'
Like this:
If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!
Best Regards,
Yueyun Zhang
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2