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.
The Power Automate isFloat() function checks whether a string can be read as a decimal number and returns true or false. Use it before float(), so a value like “N/A” or “$25.00” doesn’t break your flow with a conversion error. I ran into this with a Contoso expense form: people typed amounts as “125.50”, “125,50” … Read more >>>
To get the number of items in a SharePoint list with Power Automate, use Get items and wrap its output in length(), or call the list’s ItemCount property with Send an HTTP request to SharePoint. The first method also lets you count only the items that match a filter, and the second one is the … Read more >>>
Contoso’s project managers kept opening every task record just to change its status from Not Started to In Progress. With 40 tasks per project, that was a lot of clicks. Switching the task list on the project form to the Power Apps grid control let them edit the status right in the grid. In this … Read more >>>
To use multiple conditions in a Power Automate Get items filter query, join them with lowercase and or or, and wrap the or part in parentheses when you mix both. For example, (Status eq ‘Pending’ or Status eq ‘Shipped’) and Amount ge 1000 returns open orders worth at least $1,000. I built exactly that filter … Read more >>>
To get SharePoint items whose text begins with certain letters, use startswith(Title,’RET’) in the Filter Query of the Power Automate Get items action. The column’s internal name comes first, the text goes second in single quotes, and SharePoint returns only the matching items. At Contoso, return orders start with RET and normal orders with ORD, … Read more >>>
To set a context variable in Power Apps, call UpdateContext({locCartCount: 0}) in a behavior property such as a button’s OnSelect. The variable is created the first time the formula runs, it belongs to the current screen only, and every later UpdateContext call on that screen updates it. I’ll build a small shopping cart screen for … Read more >>>
To get SharePoint items from the last 30 days with a Power Automate OData date filter, put OrderDate ge ‘@{addDays(utcNow(),-30,’yyyy-MM-dd’)}’ in the Filter Query of the Get items action. SharePoint then returns only the items whose date is on or after the date 30 days ago, so the flow never loads the rest of the … Read more >>>
Contoso’s customer service lead was getting an email for every single feedback form response, and on busy days that meant 40 emails before lunch. What she really wanted was one message each morning with yesterday’s responses in a clean table. In this tutorial, I’ll show you how to build a Microsoft Forms responses summary email … Read more >>>
A Contoso sales director asked me for one Power BI report that the whole sales team could open, but with one catch: the EmployeePay table with salaries and bonuses had to stay invisible to the reps. Row-level security couldn’t do it, because the reps would still see the table and its columns. What she needed … Read more >>>
The owner of a small accounting firm I support called me earlier this year, frustrated. Their staff had started seeing “Approve sign in request” every time they logged in to Microsoft 365, and two of them didn’t want the Authenticator app on their personal phones. They asked me to “just turn Authenticator off.” What they … 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