Power Automate: subtractFromTime function
Subtracts an interval from a timestamp you supply. Returns a string; months clamp to month end.
CATEGORY
Microsoft
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.
Power Automate: body function
Returns the body output of a named action. Names use underscores for spaces and are case-sensitive.
How to trigger a Flow on a SharePoint change and show the before and after?
Detects which column changed on a list item and reads the old value from version history. Requires versioning.
Power Automate: Join Action
Joins an array into a single string with the delimiter you choose. An empty array returns an empty string.
Power Automate: getPastTime function
Returns the current timestamp minus a number of time units. Always counts back from now in UTC.
Power Automate: Teams - Get message details Action
Returns the full message behind a message ID: body, sender, mentions, and reactions. The body arrives as HTML.
Power Automate: chunk Function
Splits a string or array into pieces of a fixed size. The last chunk is often shorter.
Excel: Sumif Function
Sums the values that meet one condition. A mismatched sum range is silently reshaped, not flagged.
Power Automate: Teams - When a new chat message is added Trigger
Fires when a message is posted in any chat the connected user is in. Returns IDs only, not content.
base64ToBinary function
Converts a base64-encoded string into binary file content. The content type changes; the base64 does not.
What is a connection reference in Power Automate?
A connection stores credentials; a connection reference is a named pointer to one, living inside a solution.
New Power Automate now requires connection references
Convert a solution flow from a direct connection to a connection reference and unlock the new designer.