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: Round Function

Power Apps: Round Function

2 min read · 6 years ago

Rounds a number to a given decimal place using half-round-up.

Power Apps: RoundUp Function

Power Apps: RoundUp Function

2 min read · 6 years ago

Rounds a number up to the next higher decimal place.

Power Apps: RoundDown Function

Power Apps: RoundDown Function

2 min read · 6 years ago

Rounds a number down to the next lower decimal place.

Power Apps: Text Function

Power Apps: Text Function

2 min read · 6 years ago

Converts a value to formatted text. Numbers, dates, and currencies supported.

Power Apps: Switch Function

Power Apps: Switch Function

2 min read · 7 years ago

Evaluates a value against multiple matches and returns the matching result.

Power Apps: If Function

Power Apps: If Function

3 min read · 7 years ago

Tests a condition and returns one of two values.

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