web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 0O6Ew4HUMRNI4Qjh5DMtvw
Power Automate - Building Flows
Answered

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

Like (0) ShareShare
ReportReport
Posted on 6 Mar 2024 07:10:39 by 4

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.

 

Picture1.png

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:

Capturefilter.PNG


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):

Captureerror.PNG

 

Captureinputs.PNG

 

I dont understand how something so simple is not working.  Any help in resolving this issue would be appreciated.  

 

Thanks

Amanda

  • TOP4178x Profile Picture
    4 on 06 Mar 2024 at 23:55:13
    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

  • Verified answer
    v-yueyun-msft Profile Picture
    on 06 Mar 2024 at 07:18:32
    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:

    vyueyunmsft_0-1709709498156.png

    Second , you have a space after the ':

    vyueyunmsft_1-1709709577824.png

    DueDate[Here you need to use internal name!!!] le 'Yourexpression' and Status ne 'Completed'

    Like this:

    vyueyunmsft_2-1709709699174.png

     

     

     

     

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2