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.
Almost every Power Apps app I build has the same pattern: a gallery of items on the left, and the details of whichever item you tap on the right or on the next screen. A project tracker, a product catalog, a list of help desk tickets. It all comes down to one property, Selected, and … Read more >>>
An HR team I worked with sent a weekly reminder to managers about incomplete employee records: missing job titles, missing phone numbers, missing start dates. The first version of their flow pulled all 1,200 records and checked each one in a loop, which took several minutes and used thousands of actions. A Filter Query that … Read more >>>
An HR coordinator I helped had an onboarding flow that sent new hires a welcome email with their start date. It worked for months, until someone added a new employee before the start date was confirmed. The flow failed with an error about a null value, and nobody noticed for a week. One blank-date check … Read more >>>
An HR team I worked with had a flow that emailed IT every evening with the list of employees leaving that day, so their accounts could be disabled. It ran at 8 PM Eastern, and it kept listing the wrong people: tomorrow’s departures instead of today’s. The filter used utcNow(), and at 8 PM in … Read more >>>
A training coordinator I worked with wanted an email every time someone signed up for a Java course in their SharePoint enrollment list. Their flow used contains() to check the course name, and it worked in testing. Then real sign-ups started, and it missed half of them. People had typed “java” and “JAVA”, and contains() … Read more >>>
At a marketing agency I worked with, the account team opened the same three folders every morning: the brand guidelines on the Marketing site, the client contracts on the Legal site, and their own project library. That’s a lot of clicking through site navigation. Ten minutes of setting up shortcuts saved each of them that … Read more >>>
A consulting client of mine tried to share a project page with a partner who used a Gmail address, and SharePoint refused: “Your organization’s policies don’t allow you to share with these users. Go to External Sharing in the Office 365 admin center to enable it.” The page owner assumed they’d done something wrong. They … Read more >>>
A marketing team I built an intranet for wanted this quarter’s campaign deck right on their home page. Their first try was a link to the file, and almost nobody clicked it. Once the slides were playing on the page itself, people actually flipped through them, and the team stopped fielding “where’s the latest deck?” … Read more >>>
When an HR team I worked with launched their new SharePoint site, the first comment from employees wasn’t about the content. It was “Why does it just say HT?” Every new site gets a colored square with the site’s initials as its logo, and on a busy intranet those squares all start to look alike. … Read more >>>
An HR director I worked with found out the hard way that their Salary Adjustments list was visible to the whole company. The list lived on the HR site, the site was open to all employees, and the list simply inherited that access. Nobody had done anything wrong; they just hadn’t known that a list … 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