SharePoint: AVERAGE function
The average function draws a lot from Excel, where we can have one or more columns (or cells in Excel) and return the average of …
Making your life easier with automation
Function Day is where I’ll explore the basics of some functions and provide some recommendations on how to use them. I’ll focus on Microsoft Flow, SharePoint, and PowerApps since there’s a lot to explore there, but there may be other references showing up in the future.
Please don’t expect an exhaustive list of all functions. You can find that on Microsoft’s excellent reference. I’ll focus on the most common ones and build from there, but I want to make Function Day a thing on this site.
Articles will come out every Thursday, always 1 pm Lisbon Time. Since I have three platforms to explore, you can expect Power Automate, SharePoint, and Power Apps articles, every three weeks. Time permitting I’ll increase the frequency, but I think this is the right balance so that I can keep on delivering valuable information in a defined schedule.
The average function draws a lot from Excel, where we can have one or more columns (or cells in Excel) and return the average of …
When it comes to parsing strings, there’s a lot of difficult things to take into consideration. For example, spaces in the beginning and the end …
Week numbers are useful but not for everyone, I reckon. They represent the number of the week of the year starting at the beginning of …
I see many questions around this function; one of those is, “why should I use a createArray function?” It may seem strange, but this function …
Building strings is one of the most common actions in any tool or framework, and Power Automate is not the exception. The Concat function helps …
The array function will convert any value into an array. By any value, I mean one value only! The point of this function is not …
The “hour function” is part of a suite of functions that deal with dates. It returns the part of the time; for example, 12:30 will …
I have to admit that the div function and all the other analogous functions (sub, add, and mul) is quite strange. This function will divide …
Color makes everything better, and it’s an amazing way to help highlight elements, make the UI easier to use and read, and much more. The …
Knowing the day of the week can be incredibly useful when it comes to formatting data. For example, you can have a column representing a …