An HR team I worked with kept an Employee Records list in SharePoint. Whenever someone changed an employee’s End of Contract date, the Employee Status had to switch to Inactive, and nothing else in the record could change. It sounds simple, but there are two traps: the flow can run again on its own update, … Read more >>>
On one of my client’s sites, events kept disappearing from a shared SharePoint list, and nobody knew who had removed them. The fix was a small Power Automate flow that sends an email the moment an item is deleted, with the name of the person who deleted it and the time. In this tutorial, I’ll … Read more >>>
A client’s IT Support team asked me for a SharePoint site that felt like a real help desk portal, not the default team site with a list of documents. They wanted top navigation, a clean hero area, a big “Raise a ticket” button, training links, upcoming events and the faces of the team. I built … Read more >>>
Dates are usually the most important columns in a SharePoint list. When a leave has started, a contract is about to expire, or a project is overdue, you want people to see it without reading every row. In this tutorial, I’ll show you three real examples: coloring whole rows by a start date, coloring a … Read more >>>
A team lead asked me for something simpler than daily reminders: on the first day of each month, every person on her team should get one email listing all of their tasks due that month. No flood of emails, just one tidy summary per person they could plan the month around. In this tutorial, I’ll … Read more >>>
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 >>>
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