Power Automate: Reminder Emails By Date [Power Platform Series - Ep. 16]

Pragmatic Works
Pragmatic Works
67,256
0
Published 2022-09-29
In the 16th episode of Matt’s Power Platform series, he takes a look at Power Automate. Matt showcases how you can pull records in from a data source and filter them based on a column value. For this example, he will use two parallel branches in Power Automate to return records that are 3 days from today’s date and others that are 7 days from today’s date. After the two separate arrays are returned, he will then showcase how to set up two separate emails one for each set of records returned.

In the emails, Matt showcases how to use dynamic content, expressions, variables, and apply to each loops for the full execution. He also throws in how to return a user’s manager information if that is something you would like to access in your flows.

If you would like to see the past videos of Matt’s YouTube series you can access them here tinyurl.com/yuuwb38b

👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Matt30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks.com/pricing/

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5

🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-training/hackathons/
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-mentoring/
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-training/customized-ent…
🔗Pragmatic Works Blog: blog.pragmaticworks.com/

Let's connect:

✔️Twitter: twitter.com/PragmaticWorks
✔️Facebook: www.facebook.com/pragmaticworks/
✔️Instagram: www.instagram.com/pragmatic.works
✔️LinkedIn: www.linkedin.com/company/pragmaticworks
✔️YouTube: youtube.com/pragmaticworks


Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: [email protected]
#PragmaticWorks #MattPeterson

~-~~-~~~-~~-~
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
   • Free Power Apps Component Library - B...  
~-~~-
All Comments (21)
  • @user-yt6jl2qk4v
    FINALLY! Someone that makes sense! THANK YOU for making this so easy!
  • @peterjukoski3311
    You are the first person to explain where the column name is located to use in the Get Items Filter Query! Also, great job explaining the rest of the process. Thank you!
  • @danyell12345
    after a whole day of driving myself crazy trying to do this, your walkthrough worked perfectly! thanks!
  • @samanthaswaney5732
    What a life saver!!! Thank you so much for the guide and perfect pacing! You are awesome 🙂
  • @arjunrawat1123
    I really appreciate the your approach to sort this problem in a simple and effective way. I have gone through many videos but all of them provided complex solution. Keep doing good work! your method is easy and precise.
  • @mattconlon6792
    Great video, took me ages to find a video like this and fixed my workflow plus gained great knoweldge going forward.
  • @isaabdulghani2034
    Very straightforward and logical approach. I am going to apply the technique that you have taught, to my SharePoint list reminder. Thank you and God bless your effort!
  • @carlrose4877
    This is possibly the clearest introduction to creating reminder emails I have seen and earns a subscription. One request, could you do a guide on how you would use a SharePoint Calculated date column in the Filter Query please? Its easy to do in SP designer but Im really struggling on implementing it Power Automate.
  • @ivanbork4175
    Thank you, very instructive and easy to follow your pace
  • @SamiNord
    Love your work!!! thank you so much 🤗 very clear easy to follow
  • @emn727
    This is awesome! I have a question. How can we do this in minutes? I need a reminder to be sent to the Assigned To person 15 and 30 minutes before the upcoming event in the Date and Time column.
  • @Nebarus
    Just what I needed! Thank you :)
  • @nunyabeezwax1
    Great video. Used this for my software tracker that I host on Sharepoint. Works wonderfully! Thanks for this Matt :)
  • @semhar4000
    A great and very easy-to-understand! If my list is customized on the PowerApps form can I still use this method?
  • @hharteman
    Awesome content! Thanks for sharing!
  • @SaravananM-do7gq
    Millions of thanks to you brother! Watched the whole playlist in one go. Complete videos were made in very exciting way to learn. Really very much appreciating your effort and the technical stuffs shared in a very simpler way to understand. is it possible to send the emails to role instead of name, like HR, Manager, Candidate, Reviewer, Approver. Feels it will be easy to update the contact list. Even if you have a better alternative, that will be highly valued and appreciated. Thanks Again
  • @violita8807
    Thank you so much for this! Amazing explanation. It all works for me except the last step. I can send emails to myself but as soon as I want to send them to someone from the assign to or if I want to refer in my email to something in my list, it does not work anymore. Do you have an idea how I can trouble shoot this?
  • @befasb
    Thank you for this - it's super! Two minor comments, in case it helps somebody else: 1) I had to put single quotation marks around the ODATA filter date to make it work and 2) Having two people columns in my Sharepoint list, I had some issues with only one of them showing in the list of dynamic fields after Get Items, which led to some loops of Apply to each to make it work. But - it works. So again, thank you.