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.
In Power Automate, “create table” means one of two things. The Excel Online (Business) Create table action turns a cell range in a workbook into a real Excel table. The Create HTML table data operation turns an array into an HTML table you can drop into an email. Both come up in the same kind … Read more >>>
Power Automate filter query operators are the OData keywords you type in the Filter Query box of actions such as SharePoint Get items: eq, ne, gt, ge, lt, le, and, or, plus functions like startswith and substringof. Which ones work depends on the connector. Filtering on the server is much faster than pulling every item … Read more >>>
The Power Automate error “Cannot find resource for the request addroleassignments” means SharePoint doesn’t recognize the endpoint in your Uri. The method is called addroleassignment, singular, so addroleassignments or any misspelling returns a 404. Use roleassignments/addroleassignment(principalid=…,roledefid=…). You’ll meet it when you grant permissions with the Send an HTTP request to SharePoint action. I reproduced it … Read more >>>
The error “The property ‘__metadata’ does not exist on type ‘SP.List’” means your request body uses the verbose OData format, but the Content-Type header doesn’t say so. Change the header to application/json;odata=verbose, or remove __metadata and send both headers as odata=nometadata. You’ll usually see it when you create a SharePoint list with the Send an … Read more >>>
To convert base64 to an image file in Power Automate, pass the base64 string through the base64ToBinary() expression and use the result as the File Content of a SharePoint or OneDrive Create file action. If the string starts with data:image/png;base64,, use dataUriToBinary() instead. A typical case: an API returns Contoso product photos as long base64 … Read more >>>
A Power BI column chart shows one vertical column per category, and the height of each column is its value. To create one, select a column chart in the Visualizations pane, add a category such as Region to X-axis and a number such as Revenue to Y-axis. At Contoso, the sales manager asked me for … Read more >>>
To create a stacked funnel chart in Power BI, use a stacked bar chart instead of the funnel visual. Put your stages on the Y-axis, add one measure per segment to the X-axis, and put a transparent “spacer” measure first so every bar is pushed to the center and the chart takes the shape of … Read more >>>
To use conditional formatting in a Power BI stacked column chart, select the chart, go to Format visual > Visual > Columns > Color and select the fx button. Then choose Rules, Gradient or Field value, and it works whether or not the chart has a legend. At Contoso, the sales manager wanted two things … 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 >>>
Do you want to apply transparency to the Power BI area chart? In this Power BI tutorial, we will see how to apply transparency in Power BI area chart. I have explained a small difference between colors and transparency. To be transparent means to be see-through and invisible, while being colored means to be visible. … 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