Power Automate: base64 function
Encodes a string for safe system-to-system transfer. Adds 33% size overhead.
TAG
Fundamentals
If you want to master something, you have to understand its fundamentals deeply. They are the building blocks you stand on to reach the more complex ideas. Knowledge is like a house: you lay strong foundations first, then build upward. It sounds like a cliche, but it holds true, and solid fundamentals are what make good professionals. Under this tag I work on bringing you the fundamentals of each technology, from the small details that quietly make all the difference to the bigger concepts. My focus is mostly the Power Platform, but I will happily write about other things I find interesting along the way. Expect a mix drawn from technology and productivity. What matters most to me is that you walk away having learned something new you can build on.
Quick Automations: Automatic “do not disturb” on a place
Power Automate: dayOfYear function
Returns 1-366 for any date.
Power Automate: coalesce function
Returns the first non-null value from a list. Null if all are null.
Power Automate: max function
Returns the highest value from numbers or arrays. Type mismatches break it silently.
When a new email arrives in a shared mailbox trigger
Fires when a new email arrives in a shared Outlook mailbox.
Power Automate: Convert Time Zone Action
Converts a timestamp from one timezone to another.
Power Automate: Are Conditions Case Sensitive?
Power Automate: SharePoint Get file content using path action
Returns a SharePoint file by path as base64.
Power Automate: rand function
Returns a random integer within a range. Negative numbers supported; no floats.
Power Automate: SharePoint Get File content action
Returns a SharePoint file by ID as base64.
Power Automate: Power Apps (V2) Trigger
Runs a Flow from a Power App with typed inputs: text, numbers, files, booleans.