SharePoint: Now Function
Returns the current date and time as a serial number.
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.
Power Apps: Round Function
Rounds a number to a given decimal place using half-round-up.
Power Automate: addDays Function
Adds or removes days from a date with a custom format.
SharePoint: Today Function
Returns today's date as a serial number.
Power Apps: RoundUp Function
Rounds a number up to the next higher decimal place.
Power Automate: addHours Function
Adds or removes hours from a date with a custom format.
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 0-6 for the day of the week from a date.
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.