Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Error - send email rem...
Power Automate - Building Flows
Answered

Error - send email reminder 30 days before Next Service Date (Due Date)

(0) ShareShare
ReportReport
Posted on by Kehong 43

I have a sharepoint list that has a list of lab equipment that shows the "Next Service Date" that is due. This is a calculated column. 

I want to develop a PowerAutomate Flow that sends a reminder every week on Monday, that reminds my team that when an equipment is due to to service 30 days before the "Next Service Date".

 

I believe my Field name for "Next Service Date" is "Next_x0020_Service_x0020_Date" (see image below), so I have included this in the Filter Query function (see image below) and my formula for that is 

 

 

 

Next_x0020_Service_x0020_Date le '@{formatDateTime(addDays(utcNow(),30),'yyyy-mm-dd')}'

 

 

 

PA sharepoint list ask maintenance.pngPA ask maintenance.png

 

However, when I ran my flow it came up with the following error: 

Kehong_1-1714357202797.png

 

Would anyone be able to advice what's the cause of this error and how to fix it? 

Thanks for your help. 

  • Kehong Profile Picture
    Kehong 43 on at
    Re: Error - send email reminder 30 days before Next Service Date (Due Date)

    @v-yetonggu-msft 

    Thanks for this. That makes sense! I have used Filter Array and it's working now!

  • Verified answer
    v-yetonggu-msft Profile Picture
    v-yetonggu-msft on at
    Re: Error - send email reminder 30 days before Next Service Date (Due Date)

    Hi @Kehong ,

    The flow error message has been shown to you, the calculated column cannot be filtered by OData, you can use the 'Filter array' action to filter.

    Then use the records output in the 'Filter array' action in the next steps.

    vyetonggumsft_2-1714360484943.png

     

    addDays(utcNow(),30,'yyyy-MM-dd')
item()?['Email']
item()?['Title']

     

    Best Regards,

    Sunshine Gu

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

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans