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 finance team I worked with dropped a fresh Daily Report.pdf into a OneDrive folder every morning, and a flow copied it to a SharePoint library where the rest of the company read it. The first morning it worked. The second morning the flow failed, because a file with that name was already in the … Read more >>>
A sales operations team I worked with created a folder for every new client by hand: open the library, select New, type the client name, and hope nobody had already made one with a slightly different spelling. We moved it into a flow that creates the folder automatically when a client is added, with the … Read more >>>
An HR coordinator I worked with kept onboarding documents as attachments on each employee’s item in a SharePoint list: signed forms, ID copies, benefit elections. Whenever a manager asked for someone’s paperwork, the coordinator downloaded every file and attached it to an email by hand. We turned that into a flow: type an employee ID, … Read more >>>
A team lead I worked with wanted a weekly email listing every task their team had finished. The first version of the flow used Set variable inside a loop, and the email only ever showed the last task, because each pass through the loop overwrote the one before. Switching one action fixed it: Append to … Read more >>>
Every Monday, an HR analyst I worked with opened the same Excel workbook, filtered the salary column, and copied the matching employees into a text file for the payroll team. It took about 20 minutes, and one wrong filter meant a wrong report. We replaced the whole routine with a small Power Automate Desktop flow … Read more >>>
Checkboxes in a gallery look simple until you try to do something with them. On one project, the team wanted to tick several projects in a list and act on all of them at once, with a “select all” option, a reset button and a running count of how many were ticked. Each of those … Read more >>>
The first budget tracker I built in Power Apps looked fine in testing, until the finance manager opened it. Every amount was a long run of digits, such as 1250000 and 87500.5, and they had to count the zeros to tell a million from a hundred thousand. Their exact words were that it looked like … Read more >>>
I was building a customer lookup screen for a subscription team when I noticed something odd in the combo box: Blair appeared three times, Johanna twice, and the list of account managers repeated the same three names over and over. The combo box was working correctly; it was simply showing one entry for every row … Read more >>>
A client’s HR team kept their employee records in an Excel workbook, but their onboarding app read the same data from a SharePoint list. Every time someone changed a department or an address in Excel, the list fell out of date, and one of the team had to copy the changes across by hand. They … Read more >>>
A member of one of our client sites messaged me after a team meeting: they wanted to share the recording with a colleague who had missed it, but SharePoint wouldn’t let them. Instead of the usual share box, they saw this message: “Sharing is limited on this item. You can only copy links for people … 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