Book: 12 Rules for Life
Published on:
Learn moreRelated posts
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.
Excel: Countif Function
Counts the cells in a range that meet one condition. Text matching ignores case.
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.
The site is 7 years today
Seven years of the site. The newsletter is live, new reference areas launched, and old articles updated.
Excel: Averageif Function
Averages the values that meet one condition. Returns #DIV/0! when nothing qualifies.