SharePoint: Now Function
by 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 …
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: 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 …
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 …