SharePoint: AVERAGE function
Returns the arithmetic mean of number columns. Up to 30 parameters.
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.
Returns the arithmetic mean of number columns. Up to 30 parameters.
Removes leading and trailing spaces. Inner spaces stay intact.
Returns the ISO week number for a date. Monday is the first day; week 1 contains the first Thursday.
Builds an array from mixed types: strings, booleans, integers, and nested arrays.
Combines strings, booleans, integers, and arrays into a single string.
Wraps a single value into an array. Accepts strings, booleans, integers, and floats.
Returns the hour component (0-23) of a date or time value.
Divides two numbers. Has a 19-digit precision limit that silently corrupts large results.
Returns a named color value like Color.Burlywood instead of an RGBA code.
Returns the day-of-week number from a date. Three return-type options.
Multiplies two numbers. Has a 19-digit precision limit that silently corrupts large results.
Returns the selectable values for a SharePoint or Dataverse choice column.