cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Marky_
Frequent Visitor

Newbie: Need Help!

Hi everyone, I'm a beginner in Power Automate and still trying to learn.

 

I currently have 10 scheduled flows with monthly recurrence for each respective due date which would send an email to specific user for her to action. However, I recently learned that these emails should not arrive on the due date itself but instead a couple of business days before the due date. I won't pretend that I'm up to something because I have no idea how to update the current flows I have.

 

Here's an example of what I was able to configure:

 

Credit Card Reconciliation.jpg

This sends a simple email reminder every 18th of the month. I need to change it to send the email reminder 14 business day before the 18th of every month.

 

Please help and thank you in advance!

7 REPLIES 7
annajhaveri
Most Valuable Professional
Most Valuable Professional

@Marky_  you can update the recurrence trigger start time to trigger on 14th of every month

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.
Marky_
Frequent Visitor

Thanks @annajhaveri! However, the goal I'm trying to achieve is to send the email reminder 14 business days before the 18 of every month.

 

For example, the due date next month is June 18th and so the email reminder needs to be sent out 14 business days before that in which is June 1st. Now, I can update the recurrence's trigger start time to the 1st of every month but that wouldn't necessarily meet the condition of "14 business days before the 18 of every month" given that if we apply the same logic for July, as an example, the email reminder needs to be sent out on June 29th since July 18th falls on a Sunday.

 

I hope that make sense and thank you for taking time in help me out.

annajhaveri
Most Valuable Professional
Most Valuable Professional

@Marky_  so it is based on your data if I understand it correctly you will need to get the data and compare the date in your data. Where is your data stored, SharePoint or somewhere else? what you can do here, configure the flow to run daily, then in flow you can calculate today + 14 days date, which will give you the date after 14 days, then using that date, query data from your data source which have due date equals to that date, which will give you records for which you need to send the notification.  

 

Here is reference on how to calculate business days to add to a date https://powerofpowerplatform.com/calculating-working-days-in-power-automate-flow/

 

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.
Marky_
Frequent Visitor

Hi @annajhaveri I'm not storing any data anywhere. The due date is constant, every 18 of every month. Also, I need to configure the flow to calculate 18 minus 14 business days (excluding weekends) not + 14 days

annajhaveri
Most Valuable Professional
Most Valuable Professional

@Marky_  sorry for misunderstand your requirements, i think the requirement will be achievable by making the flow to run daily using recurrence trigger, then calculating difference in days between today and 18th of the month, and if that difference is 14 days, check that in condition and send the email, you can add actions as described below to get the difference between today and 18th of the month.

 

1. Add compose action and configure below expression in the action using Dynamic Content ->  Expression and rename the action to "Get 18th of the Month"

concat(formatDateTime(utcNow(),'MM'),'/18/',formatDateTime(utcNow(),'yyyy'),' 00:00:00')

This expression will give you 18th date of the current month

 

2. Again add Compose action and configure below expression in the action using Dynamic Content ->  Expression. Rename the action to "Compose - Get Difference in days"

div(sub(ticks(outputs('Get_18th_of_the_Month')),ticks(formatDateTime(utcNow(),'yyy-MM-dd'))),864000000000)

This expression will calculate difference between 18th of the month and today's date in days.

Then you can add condition action and use output of "Compose - Get Difference in days" on left of condition, select "Equal to" in the dropdown and specify 14 in the right side of condition as shown in below screenshot. Then in yes branch of action add sent email action.

 

Screenshot of the flow with action

annajhaveri_0-1620990981779.png

 

 

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.
Marky_
Frequent Visitor

No worries @annajhaveri . Thank you for this!

 

Just want to confirm though, is the calculation excluding weekend?

annajhaveri
Most Valuable Professional
Most Valuable Professional

@Marky_  no this is calculating all days, if you just need working days, then thats a little more work to be done, i would suggest you refer to this post https://ryanmaclean365.com/2019/12/12/calculate-working-days-in-a-time-period-using-power-automate/ on how to do it, as the blog has detailed instructions step by step to calculate the difference in terms of working days.

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Summer of Solutions | Week 3 Results | Win free tickets to the Power Platform Conference

We are excited to announce the Summer of Solutions Challenge!    This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Community MembersNumber SolutionsSuper UsersNumber Solutions Deenuji 9 @NathanAlvares24  17 @Anil_g  7 @ManishSolanki  13 @eetuRobo  5 @David_MA  10 @VishnuReddy1997  5 @SpongYe  9JhonatanOB19932 (tie) @Nived_Nambiar  8 @maltie  2 (tie)   @PA-Noob  2 (tie)   @LukeMcG  2 (tie)   @tgut03  2 (tie)       Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 2: Community MembersSolutionsSuper UsersSolutionsPower Automate  @Deenuji  12@ManishSolanki 19 @Anil_g  10 @NathanAlvares24  17 @VishnuReddy1997  6 @Expiscornovus  10 @Tjan  5 @Nived_Nambiar  10 @eetuRobo  3 @SudeepGhatakNZ 8     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 3:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji32ManishSolanki55VishnuReddy199724NathanAlvares2444Anil_g22SudeepGhatakNZ40eetuRobo18Nived_Nambiar28Tjan8David_MA22  

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Users online (3,392)