SharePoint: ISBLANK Function
by Showing errors to the end-user is quite ugly, so we should be careful in protecting our formulas so that no ugly #Value! are displayed on …
Category: SharePoint List Function Reference
This SharePoint List Function Reference has two main objectives. The first is to explore the fundamental concepts and understand them better. The second is to provide some feedback on how to use them efficiently.
I don’t want for this SharePoint List Function Reference to replace the excellent Microsoft reference, but I want to augment it with some information that you only find once you use the tools.
Articles will come out every Thursday, always 1 pm Lisbon Time. Since I have three platforms to explore, you can expect Power Automation, SharePoint, and PowerApps 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.
SharePoint: Choose Function
“Choose function” will return the value for a specific index. For example, if you have a set of values like “banana,” “orange,” and “apple,” the …
SharePoint: IF Function
“IF function” will return something if the first value is “true” and something else if the second is false. The “If function” is the most …
SharePoint: ISERROR Function
Showing errors to the end-user is quite ugly, so we should be careful in protecting our formulas so that you don’t display to the user …
SharePoint: CONCATENATE Function
“CONCATENATE function” will group a series of values into a unique string. I like the concatenate function since you can use more than strings. Usage …
SharePoint: REPT Function
“REPT function” will return a text value that has a specific string repeated X number of times. Usage It follows a simple pattern. String to …
SharePoint: Now Function
The SharePoint Now function will return the token serial number of the current date and time. Dates are stored internally as sequential serial numbers to enable …
SharePoint: Today Function
The SharePoint Today function will return the number of elapsed days since a reference date, in this case, December 31, 1899 (serial number 1). These are …
SharePoint: DateDif Function
“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 …
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 …