Power Apps: Count Function
Returns the number of rows in a single-column table.
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.
Returns the number of rows in a single-column table.
Sorts a table by one or more columns.
Combines values from a table into a single string using a formula.
Joins text strings and single-column tables into one string.
Checks if a text string begins with another.
Removes leading, trailing, and extra internal spaces from text.
Removes leading and trailing spaces. Inner spaces stay intact.
Returns rows from a collection that match a condition. Supports AND/OR.
Returns the difference between two dates in days, hours, months, or other units.
Returns today's date with time set to midnight. Volatile.
Returns the remainder of a division.
Returns the current date and time. Volatile.