web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Error - send email rem...

Power Automate

Answered

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

(0) Share

Report

Report

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.png PA ask maintenance.png

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

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

Thanks for your help.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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.

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

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Kehong 43 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-yetonggu-msft
Thanks for this. That makes sense! I have used Filter Array and it's working now!

Was this reply helpful? Yes No

Join the conversation