Power Automate: Join Action
Joins an array into a single string with the delimiter you choose. An empty array returns an empty string.
CATEGORY
Power Automate
Welcome to my Power Automate hub, where I share what I have learned building real cloud flows for work and for fun. If you have ever stared at a flow that almost works, this is where you fix it. You will find practical, hands-on guides that go beyond the basics and tackle the messy parts of automation. I cover advanced error handling patterns so your flows fail gracefully, and I dig into API rate limits and throttling, including batch operations and throttling mitigation, so your flows keep running when you scale up. I walk through building a website monitor from scratch, handling CSV files without losing your mind, and troubleshooting dynamic content when the values you expect simply are not there. My best practices for SharePoint across multiple environments save painful mistakes, and my approval workflow guide makes one of the most requested features easy to understand.
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.
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.
SharePoint Permissions in Power Automate
Which account really runs each action, and why a flow that works for you returns 403 for everyone else.