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
---
SKIP AHEAD:
0:00 Intro
0:32 Date Functions
1:41 Convert Time Zone Action
3:59 How Do I Get a Future Date?
7:15 Flowspiration: Send an Email Notification for Invoices Due in 15 Days
8:03 Flowspiration: Return Items Due Within the Next 7 Days
9:29 Flowspiration: Filter Items Due in 30, 60 and 90 Days
10:31 How Do I Get a Past Date?
10:57 How Can I Calculate the Number of Days Between Two Dates?
19:55 Tips and Tricks: Working with Dates in Excel
20:51 | Tips and Tricks: Use a Manual Trigger with a Date Input
22:26 Tips and Tricks: Output Dynamic Text
24:52 Tips and Tricks: Check if a Date Falls on a Weekend
----
💗 SUPPORT ME:
If you found this video helpful, please consider giving this video a like and leave a comment. You can also show additional gratitude by giving me a 💖 Super Thanks or ☕️ Buying me a Coffee: www.buymeacoffee.com/acreativ...
---
LEVEL UP YOUR POWER AUTOMATE SKILLS:
▶️ How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow: • How to Send a SINGLE E...
▶️ Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate: [ • Are you using the Micr... ]( • Send Emails Based on a... )
▶️ Are you using the Microsoft Power Automate Filter Array Action wrong?: • Are you using the Micr...
▶️ 3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow: • 3 Mistakes YOU 🫵 are M...
#microsoft365 #powerautomate #powerplatform #productivityhacks #productivitytips #techtips #techtipsandtricks #microsoftpowerautomate #sharepoint #sharepointonline #microsoftoutlook #workflows #workflowautomation
SUBSCRIBE FOR NEW VIDEOS EVERY WEEK-ISH
👉 bit.ly/SubACreativeOpinion 👈
---
Teaching you how to make your workflows SUCK LESS.
Subscribe if you want to learn how to streamline your workflow, boost your productivity, and build innovative processes for yourself and your business! I wanna help you get more time in back your day.
Join me on my journey on learning new tools, levelling up my skills and creating more time to do the things that matter. I hope that I can inspire you to do the same and share all the things you learn from me with others.
Get curious. Be creative. Do better.
---
FOLLOW ME:
/ acreativeopinion
/ acreativeopinion
/ acreativeop

[@MichaelDeBlasis1369]

Very Useful! Ty!

[@ryanj1262]

Your timing is impeccable. 🎉

[@acreativeopinion]

Thanks for watching. Hope it helped!

[@arunv1909]

hello , great video , i am learning a lot ,thansks. does compose action or variable action send API calls ? Also , date differnce can be calculate using the function datedifference , and using split function the number of days can be taken out . Split(output,'.')[0]

[@vamshisiddigari2374]

Thank you