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...DamoBird365
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...Building an app is Child’s Play – Part 1
Whether you are building your first Power App or looking to get your own child or class started with Power Apps, this is hopefully a great place to start learning by doing. I was challenged by my 9-year-old daughter, Emily, to build a Power App...
Continue reading...Create Table in Excel WorkSheet
If you are receiving daily/weekly excel workbooks containing data that isn’t saved as a table, how are you going to query it in PowerAutomate? One method is to use Office Scripts. With a relatively simple piece of TypeScript, you can insert a Table into your...
Continue reading...Round Robin in Power Automate
If you are looking to implement a round-robin allocation of list items, Microsoft form submissions, tasks, or emails via Power Automate, I have a couple of very easy solutions that you can implement using either a Microsoft List or Security/Distribution Group for the user array/list....
Continue reading...