Microsoft MVPI've worked with SharePoint and Microsoft 365 for more than 18 years, starting with MOSS 2007 and SharePoint 2010, and today with SharePoint Online, Power Apps, Power Automate and Power BI. I started EnjoySharePoint in 2011 to write down the fixes and steps I use in real client projects.
Every tutorial on the site is built and tested in a real Microsoft 365 tenant, and I review the tutorials our other authors write before they're published.
The tutorials readers open most, based on Google Search data.
Sorted by the date each tutorial was last updated.
I hit this one while building a flow that matches incoming emails to rows in a Dataverse table called IT Issue Resolutions. The List rows action had a simple filter on the Sender column, yet every run stopped with “Could not find a property named ‘crf9a_Sender’ on type ‘Microsoft.Dynamics.CRM.crf9a_itissueresolutions’”. The column clearly exists, so the … Read more >>>
![Power Automate Trim customer name Compose in code view with @trim(triggerBody()?['text']) as input](https://www.enjoysharepoint.com/wp-content/uploads/2026/11/power-automate-trim-compose-code-view.png "power automate trim compose code view")
Text that people type is rarely clean. A customer name copied from an email arrives as ” Megan Bowen “, and suddenly your Condition says it doesn’t match “Megan Bowen” in the SharePoint list. The Power Automate trim() function fixes that by removing the extra spaces at the start and end of a string. In … Read more >>>
A sales coordinator at Contoso kept finding the same order twice in her Excel tracker. Her flow added a new row every time an order came in, even when the order was already there. The fix is to check if a row exists in Excel with Power Automate first, then either update that row or … Read more >>>
A support team at Contoso asked me for a simple rule: if a customer’s remarks mention a refund, send the request to Billing, otherwise send it to Support. That’s a classic Power Automate condition that checks whether a string contains a value, and it’s easy to get slightly wrong. The catch is case. A customer … Read more >>>
Megan Bowen from our operations team messaged me on a Monday morning: the Denver store folder on her laptop hadn’t changed since Friday. The OneDrive icon showed little blue arrows that never stopped turning, while her Chicago teammates saw newer files. Her plan was to reset OneDrive. That does work, but it disconnects every library … Read more >>>
Say you’re sending a Q4 vendor price list to a partner in Denver, and the prices are only good until mid-November. You don’t want that link floating around in January. The fix is a sharing link with an expiration date: SharePoint turns the link off on that day. In this tutorial, I’ll show you how … Read more >>>
Megan Bowen dropped Order Date onto a line chart to see Contoso’s monthly revenue, and Power BI drew one sloping line between two dots: 2025 and 2026. She asked me whether the chart was broken. It wasn’t. Power BI had turned her date into a hierarchy and started at the top level. In this tutorial, … Read more >>>
Contoso’s finance team set a simple rule for 2025 and 2026: any month under $150K in revenue gets reviewed. Their trend report had a nice line chart, but someone still had to read the axis and squint at every dip to find the bad months. They wanted the line itself to turn red below target. … Read more >>>
Alex Wilber builds the regional dashboard for Contoso’s sales team. His report has a pie of revenue by region and a table of revenue by category. When a manager clicked Furniture in the table, the pie didn’t shrink to Furniture; it just shaded part of every slice, and people kept asking which number was which. … Read more >>>
Megan Bowen, the sales manager at Contoso, asked me for a simple pie chart: each region’s share of revenue for 2025 and 2026. The dollar amounts were easy. What she really wanted to see was the percentage, so she could say "Central brings in about 30%" without doing math in a meeting. In this tutorial, … 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