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
Shortcuts IFTTT 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 Sign in Need Help?

Reading comfort

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

Text size
Theme
Reduce motion
CATEGORY

Power Apps Function Reference

Here you'll find my working reference for Power Apps functions, the building blocks you reach for every time you shape data or logic in a canvas app. My goal isn't to replace Microsoft's documentation. It's to add the practical detail you pick up after using these functions on real screens, galleries, and forms. Each entry walks through one function in depth. I cover the counting family, so you'll see how the "Count" function differs from "CountA", "CountRows", and "CountIf". I dig into date math with the "DateAdd" and "DateDiff" functions, and show how "DateTimeValue" turns text into a value you can calculate with. For text work, I explain the "Concatenate" and "Concat" functions side by side, and I walk through "EndsWith" for pattern checks. For every function I lay out the syntax, a worked example, and the delegation warnings that show up at scale.

Power Apps: Count Function

Power Apps: Count Function

2 min read · 5 years ago

Returns the number of rows in a single-column table.

Power Apps: SortByColumns Function

Power Apps: SortByColumns Function

3 min read · 5 years ago

Sorts a table by one or more columns.

Power Apps: Concat Function

Power Apps: Concat Function

2 min read · 5 years ago

Combines values from a table into a single string using a formula.

Power Apps: Concatenate Function

Power Apps: Concatenate Function

2 min read · 6 years ago

Joins text strings and single-column tables into one string.

Power Apps: StartsWith Function

Power Apps: StartsWith Function

4 min read · 6 years ago

Checks if a text string begins with another.

Power Apps: Trim Function

Power Apps: Trim Function

4 min read · 6 years ago

Removes leading, trailing, and extra internal spaces from text.

Power Apps: TrimEnds Function

Power Apps: TrimEnds Function

4 min read · 6 years ago

Removes leading and trailing spaces. Inner spaces stay intact.

Power Apps: Filter Function

Power Apps: Filter Function

2 min read · 6 years ago

Returns rows from a collection that match a condition. Supports AND/OR.

Power Apps: DateDiff Function

Power Apps: DateDiff Function

2 min read · 6 years ago

Returns the difference between two dates in days, hours, months, or other units.

Power Apps: Today Function

Power Apps: Today Function

2 min read · 6 years ago

Returns today's date with time set to midnight. Volatile.

Power Apps: Mod Function

Power Apps: Mod Function

2 min read · 6 years ago

Returns the remainder of a division.

Power Apps: Now Function

Power Apps: Now Function

2 min read · 6 years ago

Returns the current date and time. Volatile.

← Previous Page 2 of 3 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

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