Dynamic Scheduled Email Flow

(2) Share

Report

Posted on by MB-26071356-0

Hello everyone, I am new to power automate and I think I'm close to part of my issue but we'll see. I am trying to create a flow that sends an email out every week. The first week an email is sent out to users. The next week a reminder email is sent out but the email message is different and so on. I think that the issue I'm having is related to my variable being reset every time the flow is triggered. Any Ideas? While we're at it is there a way to change/add attachments into these emails?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

creativeopinion 10,508 Moderator on at

Like (1)

Report
Copy link

Link copied!

Could you provide more insight on the logic to your workflow? How are you tracking which email is sent to which user? Also, toggle off the New Designer and click each action to expand it. Upload a screenshot of your flow in edit mode.

In the meantime, you might be interested in these YT Tutorials:

How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks

Are you easily stumped when working with Dates in Power Automate? In this Power Automate tutorial, I’ll show you how to compose an expression that will return a future date, a past date, how to count the number of days between two dates, how to check for a birthdate and anniversary date as well as tips and tricks when working with dates in Power Automate.

I’ll cover some common use cases and concepts that can help you to build better Power Automate flows. Feel free to skip ahead using the timestamps listed below. I’ve also linked a few other tutorials that you might be interested in as well.

IN THIS VIDEO:

✅ 4 Date Functions You Need to Know

✅ How to use the Convert Time Zone Action

✅ How to Get a Future Date

✅ How to Get a Past Date

✅ How to Return SharePoint Items Due in a Number of Days

✅ How to Return SharePoint Items Due within a Date Range

✅ How to write a Filter Query for SharePoint Items Due in 30, 60 and 90 Days

✅ How to Calculate the Number of Days between Two Dates

✅ How to Check for a Birthdate and Anniversary Date

✅ How to work with Dates and Times in Excel

✅ How to use a Manual Trigger with Date Input

✅ How to Output Dynamic Text with an Expression

✅ How to Check if a Date Falls on a Weekend

----

Power Automate Beginner Tips and Tricks | 5 Things You Need to Know – Part 1

I cover the following in this video tutorial:

✅ Power Automate Beginner Tips and Tricks

✅ Why use the Manual Trigger instead of an Automated Trigger

✅ 3 Ways a Compose Action can help you build better flows

✅ How to Manually Trigger a flow with a specific Date and Time

✅ How to return a count of items

✅ How to use the top count

✅ How to send test emails

Hope this helps!

Consider giving me a ❤️ if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
Suggested answer

AnthonyAmador 2,557 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

Yes, the problem is that the variable is reset every time you run the flow. Think of the flow as a process that does not save data in it, and every time it runs, it starts from its initial configuration.

If you want this to be automated, you need to create a database. Save the initial email information and the reminder email information, for example. Also, create a counter that, when the flow is triggered, checks which week it is, extracts the email information based on that, and then sends out the email. You can use SharePoint as your database for this.

To add an attachment, you can use the advanced option from the “Send an Email V2” action and select the content. Depending on where the attachment is, you can also add attachments to SharePoint lists and extract the attachments from there.

Hope this helps.
Anthony

Was this reply helpful? Yes No
MB-26071356-0 6 on at

Like (2)

Report
Copy link

Link copied!

The way that the flow works is by creating a variable, incrementing it by 1 and then going to the condition. If the variable is = 1 then it will follow the yes logic to send the week 1 email. I had thought that the next time it would trigger it would increment to 2 and move to the false the condition is the same, but it is not.

Was this reply helpful? Yes No
Suggested answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi

If your requirement is sending email based on weekly basis monthwise, then i can suggest another approach where for every flow run- compute the weeknumber and based on that send email accordingly. For this small change can be made where we initialize the Minute Interval Variable with expression as shown below

See whether this helps :)

Thanks & Regards,
Nived N

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!

Was this reply helpful? Yes No