SharePoint: YEAR function
Returns the year of a date as a number between 1900 and 9999. Empty dates return 1899.
Best Practices
Here I share the best practices I use for the Power Platform tools, drawn from my own experience and plenty of learning from other people's mistakes so I don't repeat them. None of this is set in stone, so adjust it to fit how you work. Consistency matters, especially when several people share a platform. I see it constantly: SharePoint sites with mismatched naming, lists with convoluted names, and flows nobody can follow. When you agree on rules, everyone always knows what something means, and onboarding a new person becomes far easier. Even if you never adopt my conventions, at least write your own down. And even if you work alone, building your own reference makes you think, and you will often spot places where things could be better. That reflection is half the value.
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.
Excel: Sumifs Function
Sums the values that meet several conditions at once. All conditions combine with AND, not OR.
N8N: On a Webhook Call Trigger
Starts a workflow instantly when an HTTP request hits its URL. Test and production URLs behave differently.
Power Automate: Office 365 Outlook - Export email Action
Exports an Outlook email as a binary EML file by Message ID. Attachments are included inside the file.
Power Automate: getFutureTime function
Returns the current timestamp plus a number of time units. Always counts from UTC now.
How to check optional values in a manual trigger?
Read optional manual trigger inputs safely with ?[] and avoid the missing-property error.
How to save emails from an Outlook to a file in Power Automate
Saves an email as an .eml file, automatically as it arrives or manually in bulk from a folder.
You Might Not Need That Provider SDK
Provider SDKs often pull in dozens of dependencies when a simple HTTP request to the API would do.
SharePoint Copy File Action
Copies a file to another library or site. Version history and metadata don't carry over.