Answered

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

(0) Share

Report

Posted on by Kehong

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:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yetonggu-msft on at

Like (0)

Report
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 (0)

Report

@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