Power Automate: Create HTML Table Action
Converts an array of objects into an HTML table for emails and messages. No styling built in.
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: base64ToString function
Converts a base64-encoded string back into readable text. Takes a string, not a file object; UTF-8 only.
Power Automate: SharePoint - Get file properties Action
Returns a SharePoint file's library column values. Needs the integer item ID, not the file identifier.
Power Automate: triggerOutputs function
Returns the trigger's entire output object, headers included. The body sits one level down.
Power Automate: subtractFromTime function
Subtracts an interval from a timestamp you supply. Returns a string; months clamp to month end.
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.