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 few months ago, a sales manager asked me why their monthly report flow had “lost” most of the orders. The flow read a SharePoint list of 328 orders with Get items, added up the amounts and emailed a summary, and the total was far too low. There was no error in the run history. … Read more >>>
One of my clients tracks Power Platform training in a SharePoint list. Each time an employee enrolls in a course, a new item is added with their name and the course they chose. For a long time, someone in HR then had to find the right course material, copy its address and paste it into … Read more >>>
I once built a Power Apps form for an HR team that onboarded a handful of new starters every week. On the first day of testing, one of the HR officers pointed out that they were typing exactly the same things into every new record: the office address, the IT department, today’s date and their … Read more >>>
One of the first SharePoint projects I helped with was a small sales team that tracked orders in a list. Every order had the customer’s name, email and phone number typed in by hand, so the same customer appeared in a dozen slightly different spellings, and when a customer changed their email address, someone had … Read more >>>
If I look back at the flows I’ve built over the past few years, a surprising number of them start by breaking a piece of text apart. A Microsoft Forms question returns several choices in one comma-separated answer. A SharePoint column holds email addresses separated by semicolons. An email body needs to be processed line … Read more >>>
If you build flows in Power Automate for long enough, you’ll meet this error. It usually appears on a flow that worked perfectly in testing, runs fine for a few days, and then suddenly fails on one particular item: The first half of the message sounds alarming, but it’s the same for every version of … Read more >>>
Is your SharePoint list full of dates and hard to understand at a glance? When everything appears as rows of data, it becomes difficult to track deadlines, project timelines, events, or schedules. Quick answer: Open the list, select + Add view, choose Calendar under Show as, pick the Start date and End date columns and … Read more >>>
A client of mine had a simple problem: new employees kept asking who they should go to for approvals, and HR spent a surprising amount of time emailing out the same org chart diagram, which was always slightly out of date. We fixed it by adding SharePoint’s Organization chart web part to the intranet home … Read more >>>
Most desktop flows I build end up working with a data table at some point. It might hold rows read from an Excel file, a table scraped from a web page, or the results of a SQL query. And sooner or later, the flow needs to add a row to that table: a new record, … Read more >>>
Last year we built a travel request app for a client in Power Apps, with every request stored in a SharePoint list. Employees and a handful of external partners needed to submit requests, but the client didn’t want to give all of them Edit permission on the list. With Edit access, anyone could change or … 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