Flow Builder - Maintenance Reminder - Overdue/Due in 30 Days reminder

(0) Share

Report

Posted on by TOP4178x

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:

Checking items less than or due within 30 days (from the current date)
Checking items in the Status column that are 'Scheduled'

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:

I have changed to the date format to multiple variations
I have tried the filter with and without the space for the column: DueDate, Due Date etc
I have tried without and Status ne 'Completed'

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

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yueyun-msft on at

Like (0)

Report

Re: Flow Builder - Maintenance Reminder - Overdue/Due in 30 Days reminder

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

Was this reply helpful? Yes No
TOP4178x 4 on at

Like (0)

Report

Re: Flow Builder - Maintenance Reminder - Overdue/Due in 30 Days reminder

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

Was this reply helpful? Yes No