October 2026
Every post published in October 2026, newest first. Pick a day to jump straight to it.
- Posts
- 219
- Topics
- 42
- Reading time
- 29 h
- Active days
- 17
Posts 151–180 of 219 · October 27, 2026
Page 6 of 8
Tuesday, October 27, 2026
30 of 107 posts
How to Use Not in Power Apps (Not and !)
Turn true into false and false into true in Power Apps with Not or the ! operator: the syntax, a real 'is this person a manager?' check, and a tip for seeing the result in Studio.
3 min readHow to Replace Blank Values in Power Apps with Coalesce
Use Coalesce in Power Apps to fall back to another value when the first one is blank or an empty string: syntax, a first-name-or-full-name example from Microsoft 365, and how it compares with If and IsBlank.
3 min readHow to Join Text in Power Apps with & and String Interpolation
Join pieces of text in Power Apps two ways: the & operator and $"...{formula}..." string interpolation. Same result, side by side in Studio, plus spacing, braces and when to use which.
4 min readHow to Join Table Values into Text in Power Apps with Concat
Turn a column of a table into one line of text in Power Apps with Concat: syntax, a separator, real examples from a SharePoint list and Office 365 Users, and how Concat differs from Concatenate and &.
3 min readHow to Sort a Table in Power Apps with Sort
Put the rows of a table in order with Sort in Power Apps: by a column, ascending or descending with SortOrder, by a formula, and together with Filter, with real results from Office 365 Users.
4 min readHow to Filter a Table in Power Apps with Filter
Keep only the rows you want from a SharePoint list, a connector or any table with Filter: the syntax, a filter on a SharePoint list, a true-or-false column filter, combining conditions, and delegation.
4 min readHow to Use the If Function in Power Apps
Show one thing or another in a canvas app with If: the syntax, an else value, several conditions in one If, what happens without an else, and real examples that pick a message based on missing data.
4 min readIsBlank vs IsEmpty in Power Apps (and the Blank Function)
When to use IsBlank and when to use IsEmpty in Power Apps: IsBlank checks a value or record, IsEmpty checks whether a table has rows. Plus Blank() to make an empty value on purpose, with real results from Studio.
4 min readHow to Handle Errors in Power Apps with IfError
Replace an error with a sensible value in Power Apps with IfError: at the point of use or inside a named formula, how type matching works, FirstError, and why the error banner disappears.
5 min readHow to Count Characters in Power Apps with Len
Count the characters in a piece of text in Power Apps with Len: see the result in Studio, spot hidden spaces, check a maximum length before saving, and tell an empty string from text.
3 min readHow to Remove Extra Spaces in Power Apps with Trim and TrimEnds
Remove stray spaces from text in Power Apps: Trim removes them everywhere except single spaces between words, TrimEnds only at the start and end. See the difference with Len, and why it matters when matching text.
4 min readHow to Get a User's Direct Reports in Power Apps (DirectReportsV2)
List the people who report to someone with Office365Users.DirectReportsV2: why you need .value, how to select fields, keep only enabled accounts, sort by name, and check whether someone is a manager.
5 min readHow to Get a User's Manager in Power Apps (ManagerV2)
Get anyone's manager from Microsoft 365 in a canvas app with Office365Users.ManagerV2: by email or Entra ID, with $select, for the signed-in user, and safely for people who have no manager.
4 min readHow to Get the Current User's Profile and Job Title in Power Apps (MyProfileV2)
Read the signed-in person's job title, first name, email and Entra ID from Microsoft 365 with Office365Users.MyProfileV2, ask only for the fields you need with $select, and keep it in a named formula.
5 min readHow to Get the Current User in Power Apps with the User Function
Get the signed-in person's name, email, Entra object ID and photo in a canvas app with User(), see each value in Studio, and know when you need Office 365 Users instead.
5 min readHow to Test a Power Apps Canvas App on Phone and Tablet Sizes
Check a responsive canvas app at phone, tablet and desktop sizes without a device: the preview's Phones and Tablets lists, and the Default, Large, Medium and Small canvas sizes in Power Apps Studio.
6 min readHow to Preview a Canvas App in Power Apps Studio
Run your canvas app inside Power Apps Studio with Preview (F5), close it with Esc, and test single controls on the canvas with the Alt key, without publishing anything.
4 min readHow to Show or Hide a Control in Power Apps with Visible
Show a control only when a condition is true with the Visible property: write a true-or-false formula, see the result in Studio, how containers close the gap, and why hiding isn't security.
4 min readHow to Add an Icon to a Button in Power Apps
Put a Fluent icon on a modern Power Apps button: pick one from the Icon box or type its name, place it before or after the text, switch between outline and filled, and make icon-only buttons accessible.
4 min readHow to Add a Button in Power Apps
Add the modern Button control to a canvas app, change its text, size and appearance, know what OnSelect does, test it with the Alt key, and give it an accessible label.
5 min readHow to Add an Avatar Control in Power Apps
Show the signed-in person's picture or initials with the modern Avatar control: its defaults, why to remove the Available presence badge, how to size it, and how to label it for screen readers.
4 min readHow to Add a Text Control in Power Apps
Add the modern Text control to a canvas app, show a formula's result in it, make it bold or larger, let it grow with Auto height, and avoid the App checker's missing accessible label error.
5 min readHow to Add a Heading for Screen Readers in Power Apps
Give each canvas app screen a real heading with the classic Text label's Role property set to TextRole.Heading1, so screen reader users can find their way, and style it to match a modern theme.
4 min readHow to Add a Horizontal Container in Power Apps
Add a horizontal container to a canvas app to line controls up side by side, give it a fixed height with the Flexible height switch, and use it to build a responsive header bar.
5 min readHow to Add a Vertical Container in Power Apps
Add a vertical container to a canvas app, make it fill the screen with Parent.Width and Parent.Height, and use Direction, Justify, Align, Gap, Padding and Overflow to stack controls that resize with the window.
5 min readPower Apps Naming Conventions for Screens, Controls and Formulas
Microsoft's naming conventions for canvas apps in one place: screen names, control prefixes like btn and lbl, screen suffixes, data sources, variables, collections and named formulas, with a real app as the example.
4 min readHow to Rename a Screen or Control in Power Apps
Rename screens and controls in a Power Apps canvas app from the tree view, so names like Screen1 and Button1 become names that explain themselves in formulas and to screen readers.
4 min readHow to Set the Start Screen in Power Apps with App.StartScreen
Choose the first screen of a canvas app with App.StartScreen instead of Navigate in App.OnStart: the formula, why screen names need quotes, how to test it, and how to pick a screen with a condition.
4 min readHow to Use Named Formulas in Power Apps (App.Formulas)
Define named formulas in App.Formulas instead of setting global variables in App.OnStart: where to type them, the syntax, how to use them in controls, where to see their values, and the rules they follow.
6 min readWhat the Enable App.OnStart Property Setting Does in Power Apps
Power Apps has an Enable App.OnStart property switch. Here's what it really changed when tested: a Save and refresh, Run OnStart disappearing, and an OnStart formula that still ran in Studio.
7 min read