Issue 002: Say farewell to Project Online and Publisher
Project Online and Publisher are retiring. Plus wave 2 dates, a Power Pages permissions check, and security news.
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.
Project Online and Publisher are retiring. Plus wave 2 dates, a Power Pages permissions check, and security news.
Prompting rules built by trial and error. Pick the right model, curate context, and iterate on your own process.
Joins an array into a single string with the delimiter you choose. An empty array returns an empty string.
Returns the current timestamp minus a number of time units. Always counts back from now in UTC.
Extracts characters from the middle of a text string, starting at a position you choose. Always returns text.
Installs Python, isolates each project, and manages dependencies with two commands.
Returns the full message behind a message ID: body, sender, mentions, and reactions. The body arrives as HTML.
Splits a string or array into pieces of a fixed size. The last chunk is often shorter.
Sums the values that meet one condition. A mismatched sum range is silently reshaped, not flagged.
Fires when a message is posted in any chat the connected user is in. Returns IDs only, not content.
A connection stores credentials; a connection reference is a named pointer to one, living inside a solution.
Counts the cells in a range that meet one condition. Text matching ignores case.