Into The Weeds

Some articles go a good deal deeper than the rest, and I call those Into the Weeds. This is where I take on complex topics, the behaviors you need to be careful about, and the trickier issues that are a pain to fix. I write them for two reasons. The first is to give advanced users something meatier to sink into and solve real problems with. The second is to give people who are still learning the Power Platform a richer experience by putting harder material within reach. Even if you do not need it today, you will remember that these corners are tricky, and when you hit something similar in a project you will save yourself hours of confusion. Going into the weeds can burn a lot of time, and my aim is to spare you some of those headaches.

Excel: Right Function

Excel: Right Function

Returns characters from the end of a text string. Defaults to one character and always returns text.

Excel: Left Function

Excel: Left Function

Returns characters from the start of a text string. Defaults to one character and always returns text.

Excel: Sumif Function

Excel: Sumif Function

Sums the values that meet one condition. A mismatched sum range is silently reshaped, not flagged.

SharePoint: YEAR function

SharePoint: YEAR function

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