SharePoint: DateDif Function
by “DateDif function” will return the difference between two dates based on the unit supplied. The units can be: Y(ear) M(onth) D(day) M(onth)D(day) Y(ear)M(onth) Y(ear)D(ay) Please note …
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 Apps: RoundDown Function
The RoundDown function rounds a number to a specific number of decimal places, always to the nearest lower number. The round is still down regardless of …
Power Automate: dayOfWeek Function
The dayOfWeek Function will return an integer number that represents the day of the week for a date, where 0 is Sunday, 1 is Monday …
SharePoint: OR Function
Welcome to Function Friday. This week we’ll explore Microsoft’s SharePoint List Function “OR” function. This function will return Yes if any of the arguments are True. If any of …
Power Apps: Text Function
The Text function is widely used in PowerApps and for a good reason. It converts any value to a text field to display. For numbers …
Power Automate: utcNow Function
The utcNow Function is equivalent to Now function in SharePoint and PowerApps, but it always returns the current date in UTC. SharePoint and PowerApps consider …
SharePoint: Len Function
“Len function” will count the number of provided characters in the parameter. It will count them all, including spaces. Usage To use it, it’s quite simple. …
SharePoint: AND Function
Welcome to Function Friday. This week we’ll explore Microsoft’s SharePoint List Function “AND” function. This function will return “Yes” if all arguments are “true”. If any of them are …
SharePoint: List Function Reference
Welcome to the SharePoint list function reference (not exhaustive). I want to explore further some of the functions and provide insights into how you can …
Power Apps: Switch Function
The Switch function evaluates a formula and tries to find it in the list of matches defined. It stops in the first match that validates …