Power Automate: formatDateTime Function
Converts a date into any format using specifiers or custom patterns like 'ddd MM yyyy'.
The Microsoft Power Platform is a family of low-code tools for building apps, automating work, and creating websites without writing everything from scratch, and this hub ties my coverage together. My biggest section by far is Power Automate, where I share hundreds of tutorials, reference pages, and answers about building cloud flows, wiring up connectors, and automating the repetitive tasks that eat your day. I also cover Power Pages, the tool for building secure, data-driven websites on top of Dataverse, so you can turn your business data into a real web experience. Across both areas my goal stays the same, to give you practical, hands-on guidance that gets you to a working result instead of leaving you lost in the documentation. Each sub-area goes deep on its own part of the platform.
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.
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.
Rounds a number to a given decimal place using half-round-up.