SharePoint: YEAR function
Returns the year of a date as a number between 1900 and 9999. Empty dates return 1899.
Blog
Tutorials, tips, and guides to level up your workflows
500+
Articles
2-5x
Per Week
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.
Why it's not a good idea to update the dependencies right away?
Delaying dependency updates by a few days blocks most supply chain attacks. Cooldowns in uv and pip.
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.
Power Automate mobile apps, the Excel add-in and personal accounts are going away
Power Automate is dropping the mobile app, the Excel add-in and personal accounts. What changes and when.
SharePoint Permissions in Power Automate
Which account really runs each action, and why a flow that works for you returns 403 for everyone else.
Tim Cook: The Genius Who Took Apple to the Next Level
Leander Kahney traces Cook's path from small-town Alabama to the top of Apple after Steve Jobs.