Power Automate: convertTimeZone function
Converts a timestamp between two time zones, daylight saving included. Output drops the zone marker.
TAG
Into The Weeds
Some articles go a good deal deeper than the rest, and I call those Into the Weeds. This is where I take on complex topics, the behaviors you need to be careful about, and the trickier issues that are a pain to fix. I write them for two reasons. The first is to give advanced users something meatier to sink into and solve real problems with. The second is to give people who are still learning the Power Platform a richer experience by putting harder material within reach. Even if you do not need it today, you will remember that these corners are tricky, and when you hit something similar in a project you will save yourself hours of confusion. Going into the weeds can burn a lot of time, and my aim is to spare you some of those headaches.
SharePoint Permissions in Power Automate
Which account really runs each action, and why a flow that works for you returns 403 for everyone else.
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.
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.
SharePoint Copy File Action
Copies a file to another library or site. Version history and metadata don't carry over.
Handle Large Files in Power Automate with Chunking
Move files past the 100 MB limit by splitting them into chunks, and know when to switch to Graph.
Power Automate: convertToUtc function
Converts a timestamp from a source time zone to UTC using Windows time zone names.
Batch Operations and Throttling Mitigation in Power Automate
Bundle hundreds of SharePoint writes into a single $batch request to stop hitting throttling limits.
Book: Revenge of the Tipping Point
Malcolm Gladwell examines the 'rule of thirds' through cheetahs, sports, and crises in this page-turner.
SharePoint: UPPER function
Converts text to uppercase, leaving numbers and punctuation untouched. The result is always text.
Power Automate: isInt function
Checks if a string is an integer.
Excel: Count Function
Counts the cells in a range that contain numbers. Ignores text, blanks, and errors.