How to Send Automated Past Due Date Emails Using Power Automate | DateDifference() | 2024 Tutorial

Hi Everyone,
Formula: if(equals(outputs('CurrentDate'),outputs('DateRented')),0,int(split(dateDifference(outputs('DateRented'),outputs('CurrentDate')),'.')[0]))
📧 Automate Your Workflow: Learn How to Send Past Due Date Emails Using Power Automate! 📧
In this comprehensive tutorial, you'll discover how to streamline your workflow and enhance productivity by automating past due date emails using Power Automate (formerly known as Microsoft Flow).
💡 What You'll Learn:
Setting Up Your Trigger: First, we'll explore how to set up a trigger in Power Automate to detect when a due date has passed. Whether it's from a SharePoint list, Excel spreadsheet, or another data source, you'll learn how to configure the trigger to suit your needs.
Generating Email Notifications: Next, we'll dive into how to generate automated email notifications for past due dates. You'll discover techniques for customizing the email content, including dynamic fields such as recipient name, due date, and task details.
Configuring Email Delivery: We'll then explore how to configure the delivery of the automated emails. From specifying recipients and setting up email templates to scheduling the email delivery time, you'll ensure that your notifications are sent out promptly and efficiently.
Monitoring and Troubleshooting: Finally, we'll discuss how to monitor and troubleshoot your automated workflow. You'll learn how to track the status of your emails, handle errors, and make adjustments as needed to ensure smooth operation.
🔧 Who Is This Tutorial For? Whether you're a project manager looking to streamline task management or a business owner seeking to improve communication with clients or employees, this tutorial is for you. Join us and unlock the full potential of Power Automate!
🎓 Take Your Automation Skills to the Next Level! Don't miss out on this opportunity to automate your past due date email notifications and streamline your workflow. Watch the tutorial now and discover how Power Automate can revolutionize your productivity!
#powerautomate #sharepoint #microsoft

[@vze1nv918]

Thank you for this! I have a thought for another video like this: how about how to create an automation that weekly (say, every Monday morning) sends an automated email to each person in the Rented By column, detailing which of their Equipments are past due? One email, but with multiple line items, one for each Equipment that's past due?

[@jasonmelchert155]

Thanks for the video. I noticed you didn’t have any items that were Yes in the returned column in your list. Would you filter those out in the get items step?

[@michaelalex2322]

Yes, that would work and save you from using it in your condition later on. Nice catch

[@EllieCarter5225]

hmmm.. I could not get it to work.
Error: Action 'Condition' failed
Error Details: Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'greater' expects two parameter of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match.'.

[@nn_2104]

date difference function can return difference in days ... no need to put such complicate formula... 🙂