Power Automate: addHours Function
by 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 …
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.
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 …
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. …
Power Apps: Delegable Functions Reference
By default, PowerApps tries to deal with the information in the client. For a small number of records, the client can quickly deal with operations …
Power Automate: Template Archive
Welcome to our Microsoft Power Automate template archive created by Manuel Gomes and with contributions from other people. This list contains some of the templates …