Why Your Automations Fail: Date & Time Handling in Power Automate Desktop with Power Fx

Master automation date variables to streamline your workflows. This guide explains how to handle date time variables effectively within your automation workflow. Whether you need to set specific dates for reporting or manipulate time intervals for task scheduling, you will see exactly how to implement these changes. It is designed for anyone building automation sequences who needs precise control over temporal data. Learn how to extract dates from Outlook emails and use Power Fx to master every important Date & Time function inside Power Automate Desktop. In this real‑world tutorial, we read an appointment email, extract the date from BodyText, convert it using DateTimeValue(), and then break it down using all major Power Fx date functions. This video is perfect for anyone building automations that depend on dates: reminders, SLAs, approvals, scheduling, escalations, and time‑based workflows. ⭐ 𝗪𝗛𝗔𝗧 𝗬𝗢𝗨 𝗪𝗜𝗟𝗟 𝗟𝗘𝗔𝗥𝗡 • Read Outlook emails in Power Automate Desktop • Extract Date Entities from email BodyText • Convert text → DateTime using Power Fx DateTimeValue() • Use core Power Fx Date & Time functions: ▸ Day()   ▸ Month()   ▸ Year()   ▸ Hour()   ▸ Minute()   ▸ Second()   ▸ DateAdd()   ▸ DateDiff()   ▸ Text()   ▸ EOMonth()   ▸ WeekDay()   ▸ WeekNum() 📌 𝗦𝗖𝗘𝗡𝗔𝗥𝗜𝗢 𝗖𝗢𝗩𝗘𝗥𝗘𝗗 You receive an email: “Your appointment with the Procurement Director is scheduled for 15 July 2026 at 3:30 PM.” Using Power Fx inside PAD, you will: 🔹 Extract the date from the email 🔸 Convert it using DateTimeValue() 🟢 Calculate reminders and time left 🔵 Format the date for logs, Excel, and notification 🧠 𝗪𝗵𝘆 𝗣𝗼𝘄𝗲𝗿 𝗙𝘅 𝗗𝗮𝘁𝗲 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀 𝗠𝗮𝘁𝘁𝗲𝗿 • Approvals • Meetings • SLAs • Reminders • Escalations • Reports • Dashboards If your automation misreads a date, the workflow breaks. This tutorial helps your automations never miss a deadline again. ⏱️ 𝗖𝗛𝗔𝗣𝗧𝗘𝗥𝗦 00:00 Introduction 01:41 Read Email And Extract Date 04:12 Loop Through Emails 04:50 Extract DateTime from Email Body 06:38 Extract DateTime from Text Variable 07:34 Extract DateTime Value from DataTable 09:06 Trick to use Date Functions in Extracted Value 11:54 Extract Date and Time Parts 13:52 DateAdd() Function 15:09 Find Date Difference 16:23 Find the Week Day of a Date 17:26 Find the Week Number of a Date 18:34 Format Date 20:38 Find End of Month 22:30 Closure ❓ 𝗛𝗢𝗪 𝗧𝗢 🟦 01:41 How can I read an Outlook Email in Power Automate Desktop 🟦 04:12 How to Loop through All the emails read in Power Automate Desktop 🟦 04:50 How to Extract an Entity from a Text in Power Automate Desktop 🟦 07:34 How to Use the Date Extracted as a DataTable in Power Automate Desktop 🟦 08:10 How to use Index() in a DataTable 🟦 08:42 How to use First() in DataTable 🟦 08:53 How to use Last() in a DataTable 🟦 09:56 Major problem with using values Extracted using Index() in Power Automate Desktop with Power Fx — Resolved 🟦 11:54 How to Extract Day, Month, Year, Hour, Minute, Second from a DateTime Variable 🟦 13:52 How to add Days, Months, Years, Hours, Quarters to a Date in Power Automate Desktop 🟦 15:09 How to find the Days between two dates 🟦 15:10 How to find the hours between two Time Values 🟦 16:23 How do you find the Week Day from a Date 🟦 17:26 How to find the Week Number of a Specific Date 🟦 18:34 How to Format a date to a custom format 🟦 29:38 How to Find the End of Current Month in Power Automate Desktop 🟦 29:45 How to find the End of Month after two months from a specific date