A client asked me for a report where managers could just type a question, like “total sales by category”, and get a chart back without learning Power BI. The Q&A visual does exactly that: you ask in plain English, and Power BI picks the fields and the chart for you. In this tutorial, I’ll show … Read more >>>
A colleague of mine built a sales matrix in Power BI with products on the rows and years across the columns. Two cells were empty, and his manager’s first question was whether the data was missing. It wasn’t: those products simply sold nothing that year, and a 0 would have said so much more clearly. … Read more >>>
A project manager I worked with sent the same email every Monday: open the project workbook, copy the table, paste it into Outlook and fix the formatting that broke. It took 15 minutes each week, and the table never looked the same twice. Power Automate Desktop can do the whole thing in seconds. There’s no … Read more >>>
On almost every intranet I build, someone asks for a “meet the team” section: who runs the project, who to call in HR, who the leadership team is. A list of names in a text box goes out of date fast. The SharePoint People web part doesn’t, because it reads names, photos and job titles … Read more >>>
When I build an intranet home page, the first thing people ask for is a set of links they use every day: the employee handbook, payroll, training and the help desk. If those aren’t visible the moment someone lands on the page, they assume the site doesn’t have them. The SharePoint Quick Links web part … Read more >>>
I was building a bulk approval screen for an Expense Claims app. Managers check the claims they want in a gallery, pick an approver and a status at the top, and select Bulk Update. After the update, I wanted every check box to clear, so I added Reset(chk_Select) to the button. Power Apps refused it … Read more >>>
A sales manager I worked with wanted one screen in her Power Apps app that showed, at a glance, which product brought in the most revenue. A table of numbers didn’t do it, but a pie chart did: every slice showed a product’s share of total sales. In this tutorial, I’ll show you how to … Read more >>>
Sooner or later, every Power Automate flow I build gets a chunk of JSON back from somewhere: an HTTP call, the SharePoint REST API, Microsoft Graph or a Power Apps form. Most of the time, I only need a few fields from it, as a clean array I can pass to the next step. In … Read more >>>
Almost every Power Apps screen I build needs a way to tell the user what just happened: the form was saved, a required field is missing, or something went wrong. The Notify() function does that with one line, by showing a colored banner at the top of the screen. In this tutorial, I’ll show you … Read more >>>
A client once built a flow that read his Outlook calendar with Get calendar view of events (V3) and wrote the events to an Excel file. It worked every time he ran it. Then he shared the flow with a colleague, and her runs failed with “The specified object was not found in the store”. … 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