When working on one of my recent projects, our team had already been using a SharePoint Online site to manage project documents, track progress, and share updates. However, we realized that most of our daily communication was happening separately through chats and calls. To bring everything together, like files, conversations, and collaboration, we decided to … Read more >>>
You can change data source in Power BI Desktop in a few clicks: go to Home > Transform data > Data source settings, select the source, choose Change Source, enter the new file path or server, and apply the changes. Your visuals, measures and relationships stay as they are. A typical case: a Contoso sales … Read more >>>
In Power BI, a slicer is a visual on the report canvas that readers click to filter the page, while a filter lives in the Filters pane and can apply to one visual, one page, or the whole report. Both filter the same data. The difference is where they sit, who uses them, and how … Read more >>>
Power Automate employee onboarding works best with a SharePoint list as the hub: HR adds one row per new hire, and flows send the welcome email, remind the manager before the start date, and track the checklist. The key is to schedule the reminders with a daily check, not with long Delay until steps. I’ll … Read more >>>
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 >>>
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