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: Manually Trigger a Flow Trigger
Runs a Flow on demand with typed input parameters. Empty optional inputs aren't returned.
Power Apps: WeekNum function
Returns the week number for a date. Start day is configurable.
Power Automate: Planner - List Tasks Action
Returns all tasks from a Planner plan as an array.
Power Automate: Office 365 Outlook - When a new email arrives Trigger
Fires when a new email arrives in any Outlook folder.
SharePoint: AVERAGE function
Returns the arithmetic mean of number columns. Up to 30 parameters.
Power Automate: Planner - Get a task Action
Returns a Planner task: title, dates, assignments, tags, and completion percentage.
Power Automate: Forms - When a new response is submitted Trigger
Fires when a Forms response is submitted. Returns the response ID only.
Power Automate: trim function
Removes leading and trailing spaces. Inner spaces stay intact.
Power Automate: Planner - Update a task Action
Modifies a Planner task: title, dates, progress, and assignments.
Power Apps: ISOWeekNum function
Returns the ISO week number for a date. Monday is the first day; week 1 contains the first Thursday.