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.
Jordan Ellis, a marketing lead in our Chicago office, pinged me on a Monday morning. She needed the holiday campaign brief in front of the sales team and a whole folder of banner drafts in front of a freelance designer by noon. Her first instinct was to attach everything to an email. That works once, … Read more >>>
If you need to open a SharePoint site or file and keep getting Access Denied or You need permission to access this site, you’re usually signed in with the wrong account, or the owner hasn’t given you access to that exact item. The message looks the same whatever the cause, which is why people get … Read more >>>
Maria Torres in HR pinged me on a Monday morning: the benefits enrollment deadline had moved to December 4, and the intranet page still said November 20. She also wanted a big Enroll now button so nobody had to hunt for the portal link. In this tutorial, I’ll show you how to edit a SharePoint … Read more >>>
An email says Megan Bowen shared “Q4 Vendor Contract Review” with you. Is it really from SharePoint, or a phishing email dressed up to look like one? In this tutorial, I’ll explain who do legitimate SharePoint document share requests come from, which sender addresses are normal, and the five checks I use before I open … Read more >>>
A flow at Contoso copied new orders into a finance list every morning. One Monday, a bad value stopped it halfway, and nobody noticed until Megan Bowen asked why the numbers looked short. Good flows don’t only work when everything goes right. They tell you when something goes wrong. In this tutorial, I’ll walk you … Read more >>>
Megan Bowen’s order system at Contoso sends status lines like “Order [ORD-1007] shipped to Contoso (Seattle) [Priority]”. Her flow only needs the order number inside the square brackets. There’s no built-in “extract text between values” action from Microsoft, but one line of expression does it. In this tutorial, I’ll show you how to split a … Read more >>>
Alex Wilber handles supplier invoices at Contoso. Every message arrives with a subject like “Invoice 4521 for PO #7788 – Contoso (Due 12/15/2026)”, and Alex needs the invoice number in a tracking list without copying it by hand. Power Automate has no “get numbers” function, but a few small actions do the job. In this … Read more >>>
If you need a second list that works exactly like one you already have, don’t rebuild it column by column. SharePoint’s Existing list option copies the columns, views and formatting into a new list in about a minute. Where people get stuck is the data. That option copies the structure only, so the new list … Read more >>>
Alex Wilber from our sales team stopped me in the hallway last week. He already had OneDrive on his laptop full of family photos, so he didn’t see why IT wanted him to save client proposals in “OneDrive for Business” instead. It’s a fair question. Both use the same app and nearly the same website. … Read more >>>
If you need a SharePoint list that flags problems on its own, you don’t need Power Apps or custom code. A few lines of JSON pasted into a column change how it looks, and the data stays the same. In this tutorial, I’ll show you sharepoint column formatting from the no-code option up to seven … 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