Every Monday, Contoso’s sales director opens the same report and asks one question: is revenue going up or down? A table of 24 monthly numbers doesn’t answer that quickly. A line does. One look at the slope, the peaks in the fall, and the dip every January tells the story. In this guide, I’ll show … Read more >>>
Our help desk manager asked for one page that answers the usual questions without making people scroll through a wall of text. She wanted an accordion: click a topic, see the answers, click again to hide them. Modern SharePoint doesn’t ship a web part called “Accordion,” but you don’t need one. Collapsible sections give you … Read more >>>
Last month, a Contoso finance lead wanted revenue and profit on the same trend chart, and then a second view that compared 2026 with 2025 month by month. Both are a Power BI line chart with multiple lines, but they’re built in different ways, and mixing them up gives you a grayed-out Legend well. In … Read more >>>
Contoso’s sales director wanted the monthly revenue trend to turn orange whenever a month fell below the $250K target, so nobody had to read the axis to spot a weak month. For years, area chart conditional formatting in Power BI simply didn’t exist, and people used a column chart trick to fake it. That changed … Read more >>>
Your team got a new name, but the SharePoint site still shows the old one everywhere. The name takes a minute to fix; the URL is a separate, admin-only job. In this tutorial, I’ll show you how to change SharePoint site name settings from Site information, and then how a SharePoint admin changes the site … Read more >>>
A sales manager at one of my clients once asked why the margin in her Power BI report said 4,736%. The model used a calculated column for the margin and the table visual simply added up every row’s percentage. Switching it to a measure fixed the number in two minutes. That mix-up is the heart … Read more >>>
Our Chicago sales team exports web orders into a SharePoint list, and every order ID arrives padded like [ORD-2026-10-4471] . Their lookup flow kept returning nothing, because a bracket and two spaces don’t match a clean ID. Power Automate has no single remove() function. You combine slice(), substring(), replace() and trim(), and one wrong index … Read more >>>
You pick a template or import a flow, sign in when asked, and Power Automate throws a long error with a GUID in it. Nothing gets saved, and the message doesn’t say which account or setting is wrong. In this tutorial, I’ll walk you through how to fix failed to create connection for connection id … Read more >>>
When Contoso moved its file shares to Microsoft 365, the first question from the project team was simple: “Which kind of SharePoint site do we create?” The marketing group wanted a place to publish news, the finance team wanted a private workspace, and IT wanted all the department sites tied together. Each of those needs … Read more >>>
To count the rows in a SharePoint list with Power Automate, use Get items and wrap its output in length(), or read the list’s ItemCount property with Send an HTTP request to SharePoint. The first method can also count only the rows that match a filter, and the second is the fastest on big lists. … 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