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 >>>
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 >>>
To sort a stacked bar chart in Power BI by value, select More options (…) on the visual, point to Sort by, choose the value field, such as Sum of Revenue, and then pick Sort descending or Sort ascending. The bars are then ordered by their total, which is the sum of all segments. At … Read more >>>
Recently, while working on a Power BI Report with 30+ measures, I found it challenging to track which measures belong to which table. To address this, Microsoft Power BI provides a solution by creating a table for better organization. In this Power BI tutorial, we will explore the concept of a Power BI measure table … Read more >>>
Recently, I created a Power BI report using various visualizations, such as a Pie chart, Table, Card, Matrix, and Line chart, as well as Slicers, etc. In that report, I had two slicers: ‘Product Sales’ slicer that has fields such as (Month Name, Product & Profit)and ‘Month Name’ slicer, as shown in the image below. Now, I … Read more >>>
I recently worked with a client who needed to customize the visuals in their Power BI reports to reflect their business data better. Changing visuals in Power BI is a powerful way to enhance data presentation and make your reports more insightful. In this tutorial, I will show you how to change the visual in … 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