Power Automate: addHours Function
Adds or removes hours from a date with a custom format.
TAG
Function Day
Function Day is where I explore the basics of a function and share recommendations on how to actually use it. I focus on Power Automate, SharePoint, and Power Apps, because there is so much to dig into there, though other references show up from time to time. Do not expect an exhaustive list of every function, since Microsoft's own reference already covers that. Instead I pick the common ones and build from there, one function at a time. Articles land on a regular schedule, and with three platforms to rotate through you can count on Power Automate, SharePoint, and Power Apps entries coming around in turn. When time allows I speed things up, but a steady rhythm is what keeps Function Day delivering useful, in-depth breakdowns you can rely on.
SharePoint: DateDif Function
Returns the difference between two dates in years, months, or days. Six unit options.
Power Apps: RoundDown Function
Rounds a number down to the next lower decimal place.
Power Automate: dayOfWeek Function
Returns an integer for the day of the week from a date. Sunday is 0, Saturday is 6.
SharePoint: OR Function
Returns Yes when any condition is true.
Power Apps: Text Function
Converts a value to formatted text. Numbers, dates, and currencies supported.
Power Automate: utcNow Function
Returns the current UTC date and time.
SharePoint: Len Function
Returns the number of characters in a text string, including spaces.
SharePoint: AND Function
Returns Yes only when all conditions are true. Up to 30 conditions.
SharePoint: List Function Reference
Power Apps: Switch Function
Evaluates a value against multiple matches and returns the matching result.
Power Apps: If Function
Tests a condition and returns one of two values.