Power Automate: addToTime Function
Adds seconds, minutes, hours, or days to a date in one call.
Welcome to my Microsoft hub, the starting point for everything I write about the Microsoft ecosystem. Here you'll find tutorials, references, and practical tips across the Microsoft 365 and Power Platform family, grouped into focused areas so you can jump straight to what you need. If you build automations, start with Power Platform, where I cover Power Automate, Power Apps, and Power BI. For everyday productivity, browse Excel for formulas and data tricks, Microsoft Teams for collaboration, and Microsoft Planner and Microsoft To Do for keeping tasks organized. Working with data and files? OneDrive, Microsoft Lists, and Microsoft Forms each have their own space with hands-on guides. Developers and admins can dig into Microsoft Graph and PowerShell for scripting across SharePoint, Azure, and Microsoft 365. I also cover Microsoft 365 Copilot, Microsoft Outlook, OneNote, and Shifts, showing how these products fit together in real workflows.
Adds seconds, minutes, hours, or days to a date in one call.
Converts a date into any format using specifiers or custom patterns like 'ddd MM yyyy'.
Returns the remainder of a division.
Adds or removes seconds from a date with a custom format.
Repeats a string N times. Result capped at 2000 characters.
Access an Excel file from a dynamically built path, working around the connector's no-dynamic-path limit.
Returns the current date and time. Volatile.
Adds or removes minutes from a date with a custom format. No date range limits.