Labels are the most common control in almost every Power Apps screen I build. Screen titles, field captions, totals, status messages, a clickable “Need help?” link: they’re all labels. They’re simple, but a few details, like line breaks and making a label clickable, trip people up. In this tutorial, I’ll cover the Label control’s key … Read more >>>
A few years ago, I set up an onboarding list for a client whose team was split between London and Chicago. On the first day, the UK manager asked why a new starter was joining on the 3rd of January when they’d been told March. Nobody had entered anything wrong: the site was using the … Read more >>>
A project manager I worked with kept all active projects in an Excel workbook and wanted a desktop flow to loop through the project names, one by one, to create a folder for each. The rest of the workbook didn’t matter, only the Project Name column. That’s a common need in Power Automate Desktop: take … Read more >>>
An accounts payable team I worked with kept a list of invoices in a Power Automate Desktop flow and wanted to pull out the ones still waiting for payment. The data was already sitting in a data table variable; the question was how to get specific values out of it. If you’re coming from cloud … Read more >>>
A project team I worked with built a flow that sent meeting details from a SharePoint list to a scheduling API. The flow ran, but the API rejected every request with a date format error. The dates looked fine in SharePoint; the API simply wanted them in ISO 8601, the international standard format, and it … Read more >>>
A project manager I worked with wanted their task list to react differently depending on priority. Low-priority tasks only needed a quick Teams message, medium ones needed a reminder as the deadline got close, and high-priority tasks called for a meeting with the person doing the work. My first draft used nested Conditions, and after … Read more >>>
A project management office I worked with tracked 200 projects in a SharePoint list and wanted to see, at a glance, how long each project would run and when it would end. They’d been calculating it in Excel and pasting the results back in. A few calculated columns did the math automatically, and the numbers … Read more >>>
Almost every Power Apps app I build has the same pattern: a gallery of items on the left, and the details of whichever item you tap on the right or on the next screen. A project tracker, a product catalog, a list of help desk tickets. It all comes down to one property, Selected, and … Read more >>>
An HR team I worked with sent a weekly reminder to managers about incomplete employee records: missing job titles, missing phone numbers, missing start dates. The first version of their flow pulled all 1,200 records and checked each one in a loop, which took several minutes and used thousands of actions. A Filter Query that … Read more >>>
An HR coordinator I helped had an onboarding flow that sent new hires a welcome email with their start date. It worked for months, until someone added a new employee before the start date was confirmed. The flow failed with an error about a null value, and nobody noticed for a week. One blank-date check … Read more >>>
122 copy-paste formulas with real examples, sent straight to your inbox.
Your free Power Automate Expressions Cheat Sheet is on its way. Can't find it in a few minutes? Look in your Promotions or Spam folder.
Sent to