Skip to main content
Manuel T Gomes

Automation Expert and Software Engineer

Home
Microsoft ▾
  • Power Automate
  • Power Apps
  • SharePoint
  • More ▸
    • Planner
    • Teams
    • Forms
    • Lists
    • Excel
    • Outlook
    • OneDrive for Business
    • Shifts
    • OneNote
    • To Do
    • PowerShell
Apple ▾
  • Xcode
  • Shortcuts
Python
Reference ▾
  • Power Automate Functions
  • Power Automate Actions
  • Power Automate Triggers
  • Power Apps Functions
  • SharePoint List Functions
  • OData Reference
  • N8N Triggers
  • Excel Functions
  • Power Automate Cookbook
  • Expressions Cookbook
Tools Newsletter Need Help?

Reading comfort

Set it once. We'll remember it for every visit.

Text size
Theme
Reduce motion
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: AVERAGE function

SharePoint: AVERAGE function

4 min read · 4 years ago

Returns the arithmetic mean of number columns. Up to 30 parameters.

Power Automate: trim function

Power Automate: trim function

2 min read · 4 years ago

Removes leading and trailing spaces. Inner spaces stay intact.

Power Apps: ISOWeekNum function

Power Apps: ISOWeekNum function

2 min read · 4 years ago

Returns the ISO week number for a date. Monday is the first day; week 1 contains the first Thursday.

Power Automate: createArray Function

Power Automate: createArray Function

4 min read · 5 years ago

Builds an array from mixed types: strings, booleans, integers, and nested arrays.

Power Automate: concat Function

Power Automate: concat Function

4 min read · 5 years ago

Combines strings, booleans, integers, and arrays into a single string.

Power Automate: array Function

Power Automate: array Function

2 min read · 5 years ago

Wraps a single value into an array. Accepts strings, booleans, integers, and floats.

SharePoint: Hour Function

SharePoint: Hour Function

4 min read · 5 years ago

Returns the hour component (0-23) of a date or time value.

Power Automate: div Function

Power Automate: div Function

2 min read · 5 years ago

Divides two numbers. Has a 19-digit precision limit that silently corrupts large results.

Power Apps: Color Function

Power Apps: Color Function

2 min read · 5 years ago

Returns a named color value like Color.Burlywood instead of an RGBA code.

SharePoint: WEEKDAY Function

SharePoint: WEEKDAY Function

5 min read · 5 years ago

Returns the day-of-week number from a date. Three return-type options.

Power Automate: mul Function

Power Automate: mul Function

2 min read · 5 years ago

Multiplies two numbers. Has a 19-digit precision limit that silently corrupts large results.

Power Apps: Choices Function

Power Apps: Choices Function

3 min read · 5 years ago

Returns the selectable values for a SharePoint or Dataverse choice column.

← Previous Page 5 of 10 Next →
Manuel T Gomes

Helping teams and developers plan, build, and automate, and sharing what I learn along the way.

No ads. No third-party trackers. Written by a human.

Topics

  • Power Automate
  • Reference
  • Python
  • SharePoint
  • Apple & Shortcuts

Site

  • Blog
  • Recommendations
  • Newsletter
  • About
  • Contact

Legal

  • Privacy Policy
  • Cookie Policy
  • Livro de Reclamações
© 2026 Skillful Sardine, Unipessoal Lda. All rights reserved. From Portugal to the World.