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.

SharePoint: YEAR function

SharePoint: YEAR function

Returns the year of a date as a number between 1900 and 9999. Empty dates return 1899.

Excel: Sumifs Function

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

N8N: On a Webhook Call Trigger

Starts a workflow instantly when an HTTP request hits its URL. Test and production URLs behave differently.