Unanswered

Schedule Email on Specific Dates Through Power Automate

(0) Share

Report

Posted on by iabbate

I have a spreadsheet with 200+ rows of different payment due dates for various clients. I have set up Power Automate to send an email with their payment reminders, but cannot figure out how to trigger the task to send an email 30 days prior to each person's specific due date.

Screenshot 2023-05-03 at 4.03.26 PM 1.png

Categories:

General topics

All responses (5)

Answers (0)

Sort by

annetoal 1,934 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Put a -1 in the Get future time interval.
Or, if you have a specific date you want to calculate, use this expression
subtractFromTime(utcNow(),1,'month')
This example subtracts 1 month from utcNow(). If you have a different date value, say, something you took from a SharePoint list or an Excel table, then use that value in place of where utcNow() appears in the expression.

If this helped, please mark it as a Solution.
Anne
iabbate 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. How do I test it to assure it is 1 month prior. If I do it manually versus automatic wouldn't it just send them all? Or should I set up one to test one month from today and test it automatically?
annetoal 1,934 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Run it, and examine the datetime string in the output. If it is correct, then it's good.

If this helped, please mark it as a Solution.
Anne
iabbate 4 on at

Like
a
(0)

Report
Copy link

Link copied!

I am very new to power automate. How exactly would that be done?
annetoal 1,934 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Click on Test in the upper right corner of your Power Automate edit screen. Follow the prompts.
After running the test, an output screen will follow that will include things like this:
Clicking the boxes opens the output. Here's an example of what the output of the Compose
subtractFromTime(utcNow(),1,'month')
action shows:
As you see, the timestring is one month previous.

If this helped, please mark it as a Solution.
Anne