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 manager I worked with had a SharePoint task list with a Due Date column, and she was tired of chasing people by email. She wanted the people assigned to each task to get a heads-up 14 days and 7 days before it was due, a reminder on the day, and a nudge when … Read more >>>
A regional sales VP I worked with looked at a Power BI matrix full of dollar amounts and asked the question that comes up in almost every report review: “But what share is that?” Converting the numbers to percentages took a right-click, and a few harder cases, like each product’s share of its own category, … Read more >>>
An HR director I built a report for wanted department filters that looked like buttons across the top of the page, not a list tucked into a corner. The classic slicer can do tiles, but the button slicer goes further: colors per button, a grid layout, images and even a small number under each button. … Read more >>>
A project manager asked me why the slicer on her new report was a dropdown when every slicer she’d built before showed a list of checkboxes. Microsoft changed the default: new slicers start as a dropdown. The checkbox list is still there; it’s just one setting away. In this tutorial, I’ll show you how to … Read more >>>
A finance analyst I work with exports a Power BI matrix to Excel every month, and the nested rows drove her team crazy: Category, Product and Store Type were all squeezed into one indented column. What they wanted looked like a flat pivot table, with each field in its own column. It’s one setting. In … Read more >>>
A sales director asked me for a simple matrix: products down the side, years across the top, and in each cell, every city where that product sold. I dragged Location into Values and got one city per cell. Power BI wasn’t broken; it was doing exactly what it does with text in a matrix, which … Read more >>>
An HR team I worked with exported their employee list every week and spent twenty minutes building “Last, First” names and mailing addresses in Excel before a mail merge. A few calculated columns in the SharePoint list did the joining for them, and the export was ready to use as soon as it downloaded. In … Read more >>>
A regional manager I work with wanted a quick way to spot overdue work in a SharePoint task list without opening every item. We added one calculated column with an IF formula that labeled each task, and a view that sorted by it. It’s still the column she looks at first every Monday. IF is … Read more >>>
An operations manager I worked with wanted a screen that looked like a spreadsheet: every product in a SharePoint list, one row each, with columns for name, category, price and release date. A gallery can do it, but it takes a lot of layout work. The Data table control gives you headers, columns and scrolling … Read more >>>
A hotel front desk app I helped with let staff register guests on a tablet. The first guest of the day always went fine. After they pressed Submit, though, the form went blank and just said “Getting your data…” until someone closed and reopened the app. The guest had been saved to SharePoint every time; … 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