web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Send email notificatio...

Power Automate

Unanswered

Send email notification 30 days prior to Current Termination Date

(0) Share

Report

Report

Posted on by Tashia1908

2

I need to send an email to someone 30 days prior to the Current Termination Date on y SharePoint list.

I've read several articles and cannot get it to run successfully.

Please help!

The sharepoint list column is Current Termination Date and I want to send an email 30 days before the date.

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Ethan_009 4,838 Moderator on at

Like (0)

Report

Hi @Tashia1908 ,

Run a scheduled flow everyday and use expression to filter based on equals (eq) rather than less than equals (le).
Format the date as today + 30 days
So everyday it will run with offset of 30 days and only check items related to that day.

Hope this helps

Was this reply helpful? Yes No
v-peijunz-msft Microsoft Employee on at

Like (0)

Report
Hi @Tashia1908

Please also make sure to add single quotes in your filter query:
The whole formula should be like:

CurrentTerminationDate le 'addDays(utcNow(),30,'yyyy-MM-dd')'

Best regards,
Sylvia

Was this reply helpful? Yes No
Tashia1908 2 on at

Like (0)

Report

Hello,

That is not working.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report

Hi @Tashia1908 ,

Please input the ' outside the expression bar.

Best Regards,

Bof

Was this reply helpful? Yes No

Join the conversation