web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Power Automate Send Em...

Power Automate

Unanswered

Power Automate Send Email reminder at Start of Month

(0) Share

Report

Report

Posted on by harydd_17

4

I am Trying to Send email reminders to all Due items for that particular month on Month Start Date.

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

v-yetonggu-msft on at

Like (0)

Report
Hi @harydd_17 ，

Could you explain what the specific months mean? Was it last month?
Do you want to send an email reminder at the beginning of every month for every item due from the previous month?

If so, I did a test for your reference.

In my scenario:

My SharePoint List:

@And(less(item()?['DueDate'], utcNow('yyyy-MM-dd')),equals(formatDateTime(item()?['DueDate'], 'MM'), addDays(utcNow('yyyy-MM-dd'), -1, 'MM'))) length(body('Filter_array'))

items('Apply_to_each')['Emailaddress']

If possible, I ask you to test this flow again tomorrow, March 1st. If you want to test it today, it is recommended that you use this condition in the 'Filter_array' control.

@And(less(item()?['DueDate'], '2024-03-01'),equals(formatDateTime(item()?['DueDate'], 'MM'), addDays('2024-03-01', -1, 'MM')))

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
harydd_17 4 on at

Like (0)

Report

want to send an email reminder at the beginning of every month for every item due this month?

Was this reply helpful? Yes No
harydd_17 4 on at

Like (0)

Report

@v-yetonggu-msft tried running same as your screenshot still not working.
want to send an email reminder at the beginning of every month for every item due this month?

Was this reply helpful? Yes No

Join the conversation