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.
Your flow works perfectly in testing: it creates the item, sends the approval, posts to Teams. Then you realize the email goes to the wrong person, or to no one, because the flow doesn’t have the right email address. I’ve run into this on HR leave requests, onboarding and help desk flows. The fix depends … Read more >>>
Sooner or later, every Power Automate flow I build gets a chunk of JSON back from somewhere: an HTTP call, the SharePoint REST API, Microsoft Graph or a Power Apps form. Most of the time, I only need a few fields from it, as a clean array I can pass to the next step. In … Read more >>>
The combo box is the control I reach for whenever users pick from a list: a work mode, a person, a related item. Saving that selection with Patch is where most people get stuck, because SharePoint Choice, Person and Lookup columns each expect a record in a slightly different shape. In this tutorial, I’ll walk … Read more >>>
Almost every Power Apps screen I build needs a way to tell the user what just happened: the form was saved, a required field is missing, or something went wrong. The Notify() function does that with one line, by showing a colored banner at the top of the screen. In this tutorial, I’ll show you … Read more >>>
A client once built a flow that read his Outlook calendar with Get calendar view of events (V3) and wrote the events to an Excel file. It worked every time he ran it. Then he shared the flow with a colleague, and her runs failed with “The specified object was not found in the store”. … Read more >>>
An HR team I worked with kept an Employee Records list in SharePoint. Whenever someone changed an employee’s End of Contract date, the Employee Status had to switch to Inactive, and nothing else in the record could change. It sounds simple, but there are two traps: the flow can run again on its own update, … Read more >>>
On one of my client’s sites, events kept disappearing from a shared SharePoint list, and nobody knew who had removed them. The fix was a small Power Automate flow that sends an email the moment an item is deleted, with the name of the person who deleted it and the time. In this tutorial, I’ll … Read more >>>
A client’s IT Support team asked me for a SharePoint site that felt like a real help desk portal, not the default team site with a list of documents. They wanted top navigation, a clean hero area, a big “Raise a ticket” button, training links, upcoming events and the faces of the team. I built … Read more >>>
Dates are usually the most important columns in a SharePoint list. When a leave has started, a contract is about to expire, or a project is overdue, you want people to see it without reading every row. In this tutorial, I’ll show you three real examples: coloring whole rows by a start date, coloring a … Read more >>>
A team lead asked me for something simpler than daily reminders: on the first day of each month, every person on her team should get one email listing all of their tasks due that month. No flood of emails, just one tidy summary per person they could plan the month around. In this tutorial, I’ll … 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