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.
Every Monday, Contoso’s sales director opens the same report and asks one question: is revenue going up or down? A table of 24 monthly numbers doesn’t answer that quickly. A line does. One look at the slope, the peaks in the fall, and the dip every January tells the story. In this guide, I’ll show … Read more >>>
Our help desk manager asked for one page that answers the usual questions without making people scroll through a wall of text. She wanted an accordion: click a topic, see the answers, click again to hide them. Modern SharePoint doesn’t ship a web part called “Accordion,” but you don’t need one. Collapsible sections give you … Read more >>>
A sales manager at Contoso asked me for one chart that starts with revenue by region and lets her click down to each state and city. Building three separate charts would have cluttered the page. The answer was to create a hierarchy in Power BI, so one visual can move from Region to State to … Read more >>>
Contoso’s PMO tracked two 2026 projects, a website redesign and a CRM rollout, in a spreadsheet that nobody outside the team opened. They already used Power BI for sales, so I built a Gantt chart in Power BI next to those reports. Now leadership sees every task, owner and percent complete on one timeline. Power … Read more >>>
Last month, a Contoso finance lead wanted revenue and profit on the same trend chart, and then a second view that compared 2026 with 2025 month by month. Both are a Power BI line chart with multiple lines, but they’re built in different ways, and mixing them up gives you a grayed-out Legend well. In … Read more >>>
Contoso’s sales director wanted the monthly revenue trend to turn orange whenever a month fell below the $250K target, so nobody had to read the axis to spot a weak month. For years, area chart conditional formatting in Power BI simply didn’t exist, and people used a column chart trick to fake it. That changed … Read more >>>
Your team got a new name, but the SharePoint site still shows the old one everywhere. The name takes a minute to fix; the URL is a separate, admin-only job. In this tutorial, I’ll show you how to change SharePoint site name settings from Site information, and then how a SharePoint admin changes the site … Read more >>>
A sales manager at one of my clients once asked why the margin in her Power BI report said 4,736%. The model used a calculated column for the margin and the table visual simply added up every row’s percentage. Switching it to a measure fixed the number in two minutes. That mix-up is the heart … Read more >>>
The Power Automate chunk() function cuts a string or an array into pieces of the length you choose, and returns them as an array. To split an 18-character activation code into blocks of four, put this in a Compose action: It returns [“M7Q2″,”K9X4″,”P8R3″,”T6W1″,”B5”]. The last piece holds whatever is left over, so it can be … Read more >>>
Say you’re automating web orders for a Chicago outdoor store, and every order ID looks like ORD-2026-10-4471-CHI. You need the year, the month, the order number and the store code in separate columns, and the substring() expression pulls each piece out by position. In this tutorial, I’ll show you how to use the power automate … 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