Excel: Sumif Function
Sums the values that meet one condition. A mismatched sum range is silently reshaped, not flagged.
ALL POSTS
All Articles
Browse all posts across all categories
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.
SharePoint: YEAR function
Returns the year of a date as a number between 1900 and 9999. Empty dates return 1899.
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.
Issue 001: Welcome! Power Platform changes and some bonus recommendations
The first issue: what's coming to the Power Platform, what's leaving Power Automate, and a few things worth reading.