SharePoint Copy File Action
Copies a file to another library or site. Version history and metadata don't carry over.
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.
Power Automate: convertFromUtc function
Converts a UTC timestamp into a target time zone. Returns a string with no offset or Z marker.
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.
Excel: If Function
Returns one of two values based on whether a condition is true or false.
N8N: On a Schedule Trigger
Starts a workflow at fixed times or intervals, like Unix cron. Missed runs are skipped, not backfilled.
Batch Operations and Throttling Mitigation in Power Automate
Bundle hundreds of SharePoint writes into a single $batch request to stop hitting throttling limits.
Excel: Sum Function
Adds numbers, cells, or ranges into a single total. A single error in the range takes over the result.
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.
Add properties to SharePoint files
Add columns to library files so you can filter, sort, group, and find them by metadata instead of folders.
Excel: Count Function
Counts the cells in a range that contain numbers. Ignores text, blanks, and errors.
N8N: Gmail Trigger
Starts a workflow when a new email arrives in Gmail. Polls on a schedule; filter by label, sender, or search.