A sales director asked me for a simple matrix: products down the side, years across the top, and in each cell, every city where that product sold. I dragged Location into Values and got one city per cell. Power BI wasn’t broken; it was doing exactly what it does with text in a matrix, which … Read more >>>
An HR team I worked with exported their employee list every week and spent twenty minutes building “Last, First” names and mailing addresses in Excel before a mail merge. A few calculated columns in the SharePoint list did the joining for them, and the export was ready to use as soon as it downloaded. In … Read more >>>
A regional manager I work with wanted a quick way to spot overdue work in a SharePoint task list without opening every item. We added one calculated column with an IF formula that labeled each task, and a view that sorted by it. It’s still the column she looks at first every Monday. IF is … Read more >>>
An operations manager I worked with wanted a screen that looked like a spreadsheet: every product in a SharePoint list, one row each, with columns for name, category, price and release date. A gallery can do it, but it takes a lot of layout work. The Data table control gives you headers, columns and scrolling … Read more >>>
An HR coordinator I worked with entered leave requests for a whole department one after another. Every time she submitted one, the Approver box still showed the last person she’d picked, and twice a request went to the wrong manager. The app needed one thing: reset the combo box after each submit. Resetting sounds simple, … Read more >>>
A regional sales manager I work with emails the same two Excel reports to her leadership team every Monday morning. The files are generated on her PC by another desktop flow, so the natural next step was to have Power Automate Desktop send them too, through her own Outlook, from her own address. In this … Read more >>>
Almost every desktop flow I build ends up cleaning text: an order number buried in an email subject, a customer name with extra spaces from a web form, a CSV line that needs splitting. Power Automate Desktop has a group of Text actions for this, and once you know a handful of them, you rarely … Read more >>>
A project office I worked with sent status updates from a SharePoint list, and their first flow sent the same update as twelve separate emails, one per person. Replies went to one person at a time, nobody could see who else was informed, and a few people got it twice. What they wanted was one … Read more >>>
I was building an issue tracker for an appliance repair team when Power Apps put a red line under a formula that looked perfectly reasonable, with the message “Expected Record value.” I wanted the Assigned To box to show the technician from the selected ticket. I gave it the technician’s name, and Power Apps said … Read more >>>
An operations manager I work with needed a monthly report of every meeting her team held: who, when and how long. She’d been copying events out of Outlook into Excel by hand. A flow now does it on the first of each month, and a second flow does the reverse, turning rows in a planning … 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