SharePoint: Lower Function
by One of the trickiest things is to keep data consistent, especially if it’s inserted by the users. Each person has their way of providing data, …
Tag: Function Day
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.
Power Automate: item Function
The item function is oftentimes misunderstood since it’s not common to be used, but it’s beneficial. For example, when you’re inside a repeating action, like …
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 …
Power Automate: trim function
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 …
Power App: ISOWeekNum function
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 …
Power Automate: createArray Function
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 …
Power Automate: concat 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 …
Power Automate: array Function
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 …
SharePoint: Hour Function
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 …
Power Automate: div Function
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 …