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.
When a Power Apps screen opens, the gallery selects its first item by default. That’s rarely the one people need. In one app I built, managers wanted the Marketing team highlighted straight away, and after adding a new employee, they expected to see that person selected, not the top row. In this tutorial, I’ll show … Read more >>>
An HR team I worked with ran employee training registrations through Microsoft Forms. Every new registration had to get the next number in a SharePoint list: 1, 2, 3 and so on. SharePoint’s own ID column wasn’t an option, because they wanted their own sequence that they could reset each year. In this tutorial, I’ll … Read more >>>
A client asked me for a report where managers could just type a question, like “total sales by category”, and get a chart back without learning Power BI. The Q&A visual does exactly that: you ask in plain English, and Power BI picks the fields and the chart for you. In this tutorial, I’ll show … Read more >>>
A colleague of mine built a sales matrix in Power BI with products on the rows and years across the columns. Two cells were empty, and his manager’s first question was whether the data was missing. It wasn’t: those products simply sold nothing that year, and a 0 would have said so much more clearly. … Read more >>>
A project manager I worked with sent the same email every Monday: open the project workbook, copy the table, paste it into Outlook and fix the formatting that broke. It took 15 minutes each week, and the table never looked the same twice. Power Automate Desktop can do the whole thing in seconds. There’s no … Read more >>>
On almost every intranet I build, someone asks for a “meet the team” section: who runs the project, who to call in HR, who the leadership team is. A list of names in a text box goes out of date fast. The SharePoint People web part doesn’t, because it reads names, photos and job titles … Read more >>>
When I build an intranet home page, the first thing people ask for is a set of links they use every day: the employee handbook, payroll, training and the help desk. If those aren’t visible the moment someone lands on the page, they assume the site doesn’t have them. The SharePoint Quick Links web part … Read more >>>
I was building a bulk approval screen for an Expense Claims app. Managers check the claims they want in a gallery, pick an approver and a status at the top, and select Bulk Update. After the update, I wanted every check box to clear, so I added Reset(chk_Select) to the button. Power Apps refused it … Read more >>>
A sales manager I worked with wanted one screen in her Power Apps app that showed, at a glance, which product brought in the most revenue. A table of numbers didn’t do it, but a pie chart did: every slice showed a product’s share of total sales. In this tutorial, I’ll show you how to … Read more >>>
I was building a project app on a SharePoint list, and my first dropdown worked perfectly: it listed every project name. The second one, for the Project Status choice column, showed nothing but an empty box and a small warning icon. If your Power Apps dropdown isn’t showing values from a SharePoint list, the cause … 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