Power Automate: getPastTime function
Returns the current timestamp minus a number of time units. Always counts back from now in UTC.
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: 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.
Power Automate: parseDateTime function
Converts a date string into an ISO 8601 timestamp using a locale and optional format. Locale comes second.
How to insert multiple values into a SharePoint Lookup field?
Writes multiple values into a SharePoint lookup column by mapping each tag to its list item ID.
Power Automate: Office 365 Outlook - Get emails Action
Returns an array of emails from a mailbox folder. Filter fields only scan the first 250 emails.
Power Automate: convertTimeZone function
Converts a timestamp between two time zones, daylight saving included. Output drops the zone marker.