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.
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 >>>
An HR team I worked with exported an employee report to Excel every week and then uploaded it to a SharePoint document library by hand, adding the department, an expiry date and an approver to each file. It was exactly the kind of repetitive job Power Automate Desktop is good at, because the files start … 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 training coordinator I worked with managed course enrollments in a SharePoint list. Every time someone signed up, they emailed the course manager by hand with the student’s name, the date and whether the course was online or in person. A simple flow with one action, Send an email (V2), now does that the moment … 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 >>>
A property management company I work with runs a flow every morning that texts on-call maintenance staff. On weekends, it should text a different crew. The first version checked whether dayOfWeek() was greater than 5, and for three weeks, nobody on the weekend crew got a message on Sundays. In Power Automate, Sunday is 0, … 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