The most recently updated SharePoint, Power Apps, Power Automate and Power BI tutorials from EnjoySharePoint. Every tutorial is tested in a real Microsoft 365 tenant.
A project tracker I inherited showed “last week’s tasks” in a gallery, and it looked right for months. Then the list passed 2,000 items and tasks started disappearing. Nobody had changed anything. The yellow triangle on the gallery had been warning about exactly this from day one: Power Apps was only looking at the first … Read more >>>
A project team I support tracks start and delivery dates in a SharePoint list, and their Power Apps screen saves those dates with a Save button instead of a form. It worked perfectly in the office in Chicago. Then a contractor in another time zone started using it, and some dates landed a day early. … Read more >>>
The first time I patched a Dataverse choice column, I did what I’d always done with SharePoint and wrote {Value: “Married”}. Power Apps rejected it with a type error. Dataverse choices work differently: you pick them from a list of named values, called an enum, and once you know the syntax, it’s actually simpler than … Read more >>>
A purchasing team I worked with had a request form where urgent requests skipped the manager approval step. People kept forgetting to change the Approval Required field to No, and the requests sat waiting for approvals nobody needed. Setting that choice automatically from the Request Type field took one formula and removed the problem. In … Read more >>>
A help desk app I built had a Submit button that people kept pressing before choosing a category, which saved tickets with no category at all. The fix was a one-line check on the combo box: if nothing is selected, the button stays gray. It sounds simple, but the obvious formula, IsBlank(), doesn’t work the … Read more >>>
An HR coordinator I worked with entered leave requests for a whole department one after another. Every time she submitted one, the Approver box still showed the last person she’d picked, and twice a request went to the wrong manager. The app needed one thing: reset the combo box after each submit. Resetting sounds simple, … Read more >>>
A regional sales manager I work with emails the same two Excel reports to her leadership team every Monday morning. The files are generated on her PC by another desktop flow, so the natural next step was to have Power Automate Desktop send them too, through her own Outlook, from her own address. In this … Read more >>>
Almost every desktop flow I build ends up cleaning text: an order number buried in an email subject, a customer name with extra spaces from a web form, a CSV line that needs splitting. Power Automate Desktop has a group of Text actions for this, and once you know a handful of them, you rarely … Read more >>>
A sales team I worked with had an approval email that said “Total: 12500.5”. It was right, but it didn’t look like money, and one manager replied asking whether it was twelve thousand or a hundred and twenty-five thousand. Changing one expression to show “$12,500.50” ended the questions. In this tutorial, I’ll show you how … Read more >>>
A sign-up app I built for a company event kept collecting the same email address two or three times, because people tapped Submit more than once. The fix was a single check before adding the address: does the collection already contain it? Power Apps has no Contains() function, which is what most people search for, … 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