An implantable cardioverter-defibrillator (ICD) is a small device that is placed under the skin of the chest to monitor and treat heart rhythm problems. It is often used in people who have a high risk of sudden cardiac arrest. I survived a suspected cardiac arrest...
Continue reading...What is the Power Platform?
Power Platform is a collection of low-code, no-code tools created by Microsoft that allows users to automate business processes, create custom apps, and analyze data. The platform includes five main components: Power Automate, Power Apps, Power Virtual Agents, Power BI and Power Pages. Power Automate...
Continue reading...Add user to Distribution List
It’s still the case that you cannot directly add a user to an Exchange Distribution List via Power Automate as can be seen here Working with groups in Microsoft Graph – Microsoft Graph v1.0 | Microsoft Learn (distribution groups cannot be managed by Graph API)...
Continue reading...Efficiently Filter a JSON object in Power Automate
Here is an interesting sample JSON object {}, that contains a JSON array [] with 3 objects. The final solution will have 3000 objects. The aim is to retrieve two key values from the object whilst checking another nested array for a common string ‘ACABA’....
Continue reading...Bulk Import Tasks into Planner
Using Power Automate and Excel (or any other available data source 😉), you can bulk import tasks into planner using Power Automate. I have previously recorded a video on this process and use both a tasks table and a config table to support this cloud...
Continue reading...Export Power BI Report or Visual to File
Power Automate has an action “Export to File for Power BI Reports” which enables you to export a Power BI Visual or Page as a PDF, Power Point (PPTX) or Image (PNG) file. Below you will learn about the Workspace requirements, how to identify the...
Continue reading...Disable Microsoft Forms via Power Automate
It is technically possible to disable a Microsoft Form from Power Automate. Why would you want to do this? Maybe it’s time limited – ok sure you can specify an end date via the existing UI. But what if that date or time was to...
Continue reading...Update Event and Hide Attendees
It would appear that the standard actions for Events in Power Automate will send your attendees an email each time a new attendee is added or updated. In addition to this, attendees are visible to all. Using the Graph API and the Update Event call...
Continue reading...Restore deleted Flows as an Admin
As an admin, you will only know too well, that if a user deletes a flow, you will need to raise a call with Microsoft to restore that flow to Power Automate. Until May 2022 that is, when the Restore-AdminFlow cmdlet was released. There are...
Continue reading...Split a Workbook into Multiple Worksheets
It is possible to quickly split a workbook into multiple worksheets based on a key column using Office Scripts in Power Automate. For instance, if your Excel sheet contains data relating to sales and for each of those sales, the sales manager responsible is in...
Continue reading...