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 >>>
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 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 >>>
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