Effortlessly Format Dates & Get Specific Days: Power Automate Solution

Are you struggling to format a date or get a particular day of the month in Power Automate? Look no further! In this video, I'll show you how to easily calculate the first day of a month, the last day of the month, the nth day of a month, add a particular time to your date, retrieve the next Friday (or particular day) of the week, all Fridays in that month, the 1st and 3rd Friday of a month or the nth working day of the Month.

I'll take you step-by-step through the process and show you how to avoid common errors such as the ISO8601 error when trying to convert a date string to a datetime or converting from UTC to your local region. Plus, I'll provide examples and a downloadable flow for you to use. This is a great solution for those who want to automate the process of formatting dates and increase productivity.

Don't miss out on this opportunity to learn how to format a date and get a particular day of the month in Power Automate. Hit that like and subscribe button and let's get started!

Also learn how to get the number of working days, minus public holidays in Power Automate or Power Apps - here    • Calculating Working Days in Power Aut...  

00:00 Intro
00:37 ISO 8601 Error Explanation
03:23 Format Current Date Time
05:30 Convert Timezone UTC to Hawaiian
07:11 Start of the Month
08:10 Nth Day of the Month
08:58 Last Day of the Month
10:17 Specific Time on a Particular Day
11:38 Wednesday or particular next occurence of day of week
19:00 An array of Days for the month
23:50 Retrieve all Fridays for the month and then 1st and 3rd
26:50 Remove weekends from the Array and get 10th Working Day
29:00 Outro

Please also see https://www.damobird365.com/formatdat... for further examples.

Download the Flow https://github.com/DamoBird365/PowerA...

Date Time Expressions https://docs.microsoft.com/en-us/azur...

Time Zones https://docs.microsoft.com/en-us/wind...

Community Post expression for next day of week https://powerusers.microsoft.com/t5/P.... Please buy me a coffee https://www.buymeacoffee.com/DamoBird365 ☕