The most recently updated SharePoint, Power Apps, Power Automate and Power BI tutorials from EnjoySharePoint. Every tutorial is tested in a real Microsoft 365 tenant.
I was building what should have been a five-minute flow for a SharePoint list: whenever someone adds an item, email the person named in the Approver column. The flow saved without complaint, but the very first test run failed with OpenApiOperationParameterTypeConversionFailed and this rather intimidating message: Once you know how to read it, though, this … 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 >>>
The first time I built a leave request app for a small HR team, I let people type the leave type and department into ordinary text boxes. Within a week, the SharePoint list had “Sick”, “Sick leave”, “sick lv” and “HR”, “Hr” and “Human Resources”, and none of the reports added up. The fix was … Read more >>>
A facilities team I worked with built a Power Apps request form, and the first thing people complained about was typing their own name, email, department and office location every single time. Microsoft 365 already knows all of that. Five minutes with the Office 365 Users connector filled those fields in automatically, and the complaints … 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 >>>
When I built a help desk app for one of our clients, the first round of test tickets arrived half empty. People were pressing Submit before they’d typed a title or described the problem, and the support team had to chase them for the details. The fix took one formula: the Submit button stays greyed … Read more >>>
The first time I used utcNow() in a flow, I stamped “Approved on” into a SharePoint list, and the approver in Chicago asked why her approval said 11:40 PM when she’d clicked at 6:40 in the evening. utcNow() had done exactly what its name says: it returned the time in UTC. utcNow() is still the … Read more >>>
A finance team I work with has a flow that runs on the first of every month, builds a report of the previous month’s expenses, and saves it as “Expenses – August 2026.xlsx”. Getting “August” out of Power Automate on September 1 takes one expression, but it has to be the right one, and it … Read more >>>
A marketing coordinator I worked with wanted the company logo at the top of every automated welcome email. Her first attempt linked to the logo in SharePoint, and it looked perfect in her own inbox. Every new customer saw a broken image icon instead, because they couldn’t sign in to the company’s SharePoint. There are … 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