cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AdamPV
New Member

Trigger Reminder Email When Email Received

Hello there,

 

New to Power Automate and I'll be honest I'm not too sure where to start.

I'm looking to create and send an email based on the following steps:

 

  1. A user creates holiday request on our internal system which kicks out an email to say 'Request submitted'. This comes with specific working from a particular mailbox and would be used as the trigger.
  2. When that email arrives on the mail server I want Power Automate to send another email to the same person/recipient with a specific message and title (reminding them its their responsibility to organize cover).
  3. This would happen for all members of staff in the business, so it can't be client side.

How would I go about doing this please?

 

Regards,

Adam

 

 

14 REPLIES 14
Sundeep_Malik
Multi Super User
Multi Super User

Hey @AdamPV, what you can do with these emails is, keep the subject similar for all the mails related with the above case. So, when you trigger the 2nd flow, which will run after a mail is received, then only it will trigger.

So, what I mean is the person who is sending the mail with the Holiday request, you can keep the subject same for these type of emails, lets say: Holiday Request, would be the Subject for your case. Then the 2nd flow will only trigger when a mail with the subject Holiday Request is received. I am suggesting this method because you will be receiving many mails daily, so with the common subject value, power automate will differentiate that the mail received is of holiday request category or its of any other category. 

Hi @Sundeep_Malik,

 

Many thanks for reading and responding.

So the holiday emails that arrive will always be from the same address (its automated) and will always have the same title as you've suggested. The only time we'd want to avoid sending the second email is if there's a discussion over email between manager and user, and I'd suggest the 'RE: Holiday Request' (re:) would differentiate it from the original email.

 

So this being covered, how would I go about creating the flow? Is there a specific template I can use as a starting point? If so what would I need to add to that to make this work?

 

Many thanks once again,

 

Adam

Sundeep_Malik
Multi Super User
Multi Super User

Templates are a good way to take help, but I will suggest never to use templates for your flows. For your flow you can take the trigger when an email is received. Plus there is one more functionality you can use. Its of Approval action. You can use Approval action to send an approval notification to the respective manager when request is started. The manager from the mail itself can approve or reject it. 

Rest these were the things I can suggest you for the moment. 

Hi @Sundeep_Malik,

We don't need to go as far as adding approvals, that is already accounted for within our internal system. We just want a second email to be sent to the recipient with fixed content when the first automated email arrives on the server from a specific mail address with a specific title.

 

So;

email arrives on the mail server with specific sender and title

flow is triggered by this

flow sends second email to the recipient saying 'please make sure you organised cover'.

 

Nothing else is required. I just need to know where to start. Can you/anyone suggest a starting point?

 

Regards,

Adam

AdamPV
New Member

So I've tried to create a simple flow but this just fails to work with no obvious reason why (I'm sending the dummy holiday to myself to the same mail box, I'm guessing it doesn't really matter where it comes from if its defined in such a way).

 

Can anyone tell me why this just doesn't work?

fail.png

 

Thanks,

Adam

Hi Adam, I don't understand the reason its not working as checking up all your explanation from above everything makes sense. What error message are you getting

 

Kind regards 

Hi @LebogangMaubane,

It's now working for me; great! It just doesn't work for anyone else, yet the recipient is left as blank and so I assumed it would apply across the business. Am I wrong?

 

Regards,

Adam

Hi @AdamPV   the solution works I build the flow. I guess its universal, since the fields are not mandatory. Its great as it can handle dynamic email address. Just remember one needs to keep the header consistence (Only the first words of your header, there can be other things in the header that differentiate the email from others the flow will pick up the email even if it has other things after it. For example  "Holiday Cover - 2022/10/08 Lebogang" the flow filter will still pick it up even it has other reference within the header. Just make sure the atleast the first two words or variables used as headers are consistent.

AdamPV
New Member

It will work only for the owner with a specific connection (a single email address). So if I wanted this to work for all users across the business I'd have to share a template for the flow, they'd have to be owners, and they'd have to add their own email as a connection. I can see the same issue discussed here from years ago and it seems its never been considered or implemented. 

 

https://powerusers.microsoft.com/t5/General-Power-Automate/Outlook-When-New-Email-Arrives-V3-does-no...

 

Kinda makes the whole thing useless for this application unfortunately.

VictorIvanidze
Community Champion
Community Champion

Hi @AdamPV,

the company-wide solution  can be created if you are ready to wait several minutes between flagging and sending.

Hi @VictorIvanidze, could you elaborate please?

Create a scheduled cloud flow that runs every 5 minutes. Scan your inbox for the flagged emails. 

Unfortunately the email goes directly to the user and not to a shared mail box. The challenge is that the way the 365 outlook connection works is for a single email address. Unless you know something I don't?

 

Our workflow would go like this:

 

  • User logs into our cloud based holiday planner.
  • User submits a holiday.
  • The holiday planner sends an email to the manager to be approved.
  • The manager approves/rejects the holiday.
  • The holiday planner submits and email to the requester telling them their holiday has been approved/booked.
  • Here we want a flow to notice there's an email to the requesters mail box, and then send a second email telling them to arrange cover.

Now I can make this work for myself as I've show above without the need to populate an email address for the recipient, assuming this will work for just anyone. But because I have to use my own personal email address as a connection for the 365 outlook trigger, the flow is only available and working for me.

 

I need to be able to have a single flow and it work for the entire business without having to share/create/link it to absolutely everyone's email in that connection. I hope that makes sense?

If you have a suggestion as to exactly how we could work around this I would be very interested to hear it.

 

Thanks,

 

Adam

 

 

Hi Adam,

you can do the following.

1. Create an application account that has access rights to all user mailboxes

2. Create a scheduled flow that runs as the application account. The flow runs every several  minutes. It scans all user's Inboxes and does what you want.

Is this acceptable? 

Helpful resources

Announcements

Power Platform Connections - Episode 7 | March 30, 2023

Episode Seven of Power Platform Connections sees David Warner and Hugo Bernier talk to Microsoft MVP Dian Taylor, alongside the latest news, product reviews, and community blogs.     Use the hashtag #PowerPlatformConnects on social media for a chance to have your work featured on the show!      Show schedule in this episode:    0:00 Cold Open 00:30 Show Intro 01:02 Dian Taylor Interview 18:03 Blogs & Articles 26:55 Outro & Bloopers    Check out the blogs and articles featured in this week’s episode:    https://francomusso.com/create-a-drag-and-drop-experience-to-upload-case-attachments @crmbizcoach https://www.youtube.com/watch?v=G3522H834Ro​/  @pranavkhuranauk https://github.com/pnp/powerapps-designtoolkit/tree/main/materialdesign%20components @MMe2K​ https://2die4it.com/2023/03/27/populate-a-dynamic-microsoft-word-template-in-power-automate-flow/ @StefanS365 https://d365goddess.com/viva-sales-administrator-settings/ @D365Goddess https://marketplace.visualstudio.com/items?itemName=megel.mme2k-powerapps-helper#Visualize_Dataverse_Environments @MMe2K    Action requested:  Feel free to provide feedback on how we can make our community more inclusive and diverse.    This episode premiered live on our YouTube at 12pm PST on Thursday 30th March 2023.    Video series available at Power Platform Community YouTube channel.    Upcoming events:  Business Applications Launch – April 4th – Free and Virtual! M365 Conference - May 1-5th - Las Vegas Power Apps Developers Summit – May 19-20th - London European Power Platform conference – Jun. 20-22nd - Dublin Microsoft Power Platform Conference – Oct. 3-5th - Las Vegas    Join our Communities:  Power Apps Community Power Automate Community Power Virtual Agents Community Power Pages Community    If you’d like to hear from a specific community member in an upcoming recording and/or have specific questions for the Power Platform Connections team, please let us know. We will do our best to address all your requests or questions.       

Announcing | Super Users - 2023 Season 1

Super Users – 2023 Season 1    We are excited to kick off the Power Users Super User Program for 2023 - Season 1.  The Power Platform Super Users have done an amazing job in keeping the Power Platform communities helpful, accurate and responsive. We would like to send these amazing folks a big THANK YOU for their efforts.      Super User Season 1 | Contributions July 1, 2022 – December 31, 2022  Super User Season 2 | Contributions January 1, 2023 – June 30, 2023    Curious what a Super User is? Super Users are especially active community members who are eager to help others with their community questions. There are 2 Super User seasons in a year, and we monitor the community for new potential Super Users at the end of each season. Super Users are recognized in the community with both a rank name and icon next to their username, and a seasonal badge on their profile.  Power Apps  Power Automate  Power Virtual Agents  Power Pages  Pstork1*  Pstork1*  Pstork1*  OliverRodrigues  BCBuizer  Expiscornovus*  Expiscornovus*  ragavanrajan  AhmedSalih  grantjenkins  renatoromao    Mira_Ghaly*  Mira_Ghaly*      Sundeep_Malik*  Sundeep_Malik*      SudeepGhatakNZ*  SudeepGhatakNZ*      StretchFredrik*  StretchFredrik*      365-Assist*  365-Assist*      cha_cha  ekarim2020      timl  Hardesh15      iAm_ManCat  annajhaveri      SebS  Rhiassuring      LaurensM  abm      TheRobRush  Ankesh_49      WiZey  lbendlin      Nogueira1306  Kaif_Siddique      victorcp  RobElliott      dpoggemann  srduval      SBax  CFernandes      Roverandom  schwibach      Akser  CraigStewart      PowerRanger  MichaelAnnis      subsguts  David_MA      EricRegnier  edgonzales      zmansuri  GeorgiosG      ChrisPiasecki  ryule      AmDev  fchopo      phipps0218  tom_riha      theapurva  takolota     Akash17  momlo     BCLS776  Shuvam-rpa     rampprakash  ScottShearer     Rusk  ChristianAbata     cchannon  Koen5     a33ik  Heartholme     AaronKnox  okeks      Matren   David_MA     Alex_10        Jeff_Thorpe        poweractivate        Ramole        DianaBirkelbach        DavidZoon        AJ_Z        PriyankaGeethik        BrianS        StalinPonnusamy        HamidBee        CNT        Anonymous_Hippo        Anchov        KeithAtherton        alaabitar        Tolu_Victor        KRider        sperry1625        IPC_ahaas      zuurg    rubin_boer   cwebb365   Dorrinda   G1124   Gabibalaban   Manan-Malhotra   jcfDaniel   WarrenBelz   Waegemma   drrickryp   GuidoPreite    If an * is at the end of a user's name this means they are a Multi Super User, in more than one community. Please note this is not the final list, as we are pending a few acceptances.  Once they are received the list will be updated. 

Register now for the Business Applications Launch Event | Tuesday, April 4, 2023

Join us for an in-depth look into the latest updates across Microsoft Dynamics 365 and Microsoft Power Platform that are helping businesses overcome their biggest challenges today.   Find out about new features, capabilities, and best practices for connecting data to deliver exceptional customer experiences, collaborating, and creating using AI-powered capabilities, driving productivity with automation—and building towards future growth with today’s leading technology.   Microsoft leaders and experts will guide you through the full 2023 release wave 1 and how these advancements will help you: Expand visibility, reduce time, and enhance creativity in your departments and teams with unified, AI-powered capabilities.Empower your employees to focus on revenue-generating tasks while automating repetitive tasks.Connect people, data, and processes across your organization with modern collaboration tools.Innovate without limits using the latest in low-code development, including new GPT-powered capabilities.    Click Here to Register Today!    

Check out the new Power Platform Communities Front Door Experience!

We are excited to share the ‘Power Platform Communities Front Door’ experience with you!   Front Door brings together content from all the Power Platform communities into a single place for our community members, customers and low-code, no-code enthusiasts to learn, share and engage with peers, advocates, community program managers and our product team members. There are a host of features and new capabilities now available on Power Platform Communities Front Door to make content more discoverable for all power product community users which includes ForumsUser GroupsEventsCommunity highlightsCommunity by numbersLinks to all communities Users can see top discussions from across all the Power Platform communities and easily navigate to the latest or trending posts for further interaction. Additionally, they can filter to individual products as well.   Users can filter and browse the user group events from all power platform products with feature parity to existing community user group experience and added filtering capabilities.     Users can now explore user groups on the Power Platform Front Door landing page with capability to view all products in Power Platform.      Explore Power Platform Communities Front Door today. Visit Power Platform Community Front door to easily navigate to the different product communities, view a roll up of user groups, events and forums.

Microsoft Power Platform Conference | Registration Open | Oct. 3-5 2023

We are so excited to see you for the Microsoft Power Platform Conference in Las Vegas October 3-5 2023! But first, let's take a look back at some fun moments and the best community in tech from MPPC 2022 in Orlando, Florida.   Featuring guest speakers such as Charles Lamanna, Heather Cook, Julie Strauss, Nirav Shah, Ryan Cunningham, Sangya Singh, Stephen Siciliano, Hugo Bernier and many more.   Register today: https://www.powerplatformconf.com/   

Users online (2,654)