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: Reference
Reference articles will contain information about specific functions and concepts for Microsoft Power Automate, Power Apps, and SharePoint for functions, Actions, and Triggers. It will teach you how to use them and show you pitfalls, limitations, and best practices on how to use them efficiently.
Power Apps: Round Function
The Round function performs the mathematical round of a number to a specific number of decimal places. It uses the rules defined “Half Round-Up” where it rounds …
Power Automate: addDays Function
The addDays Function works just like the addSeconds Function and other similar functions. It adds the number of days to a specific date, based on a …
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 …
Power Apps: RoundUp Function
The RoundUp function rounds a number to a specific number of decimal places, always to the nearest higher number. The round is still up regardless of …
Power Automate: addHours Function
The addHours Function works just like the addSeconds Function and other similar functions. It adds the number of hours to a specific date, based on a …
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 …
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 …