Level of Difficulty: Beginner – Senior. One of the biggest challenges in the Power Platform is maintaining control of the environments with the necessary visibility, especially when faced with the risk of orphaned artefacts (apps/flows without owners – possibly because the owner has left the organisation and the user account associated no longer exists). TheContinue reading “[Power Automate] Ensuring Center of Excellence (COE) Control of Apps and Automate Flows”
Author Archives: Jacqui Muller
[Automation] Unit Testing in Power Automate Flows
Level of Difficulty: Beginner – Senior. Unit testing is a crucial aspect of software development, helping developers ensure that individual components of their code function as expected. But what about when you’re working with low-code or no-code automation platforms like Power Automate? Can you apply the same principles of unit testing to ensure the reliabilityContinue reading “[Automation] Unit Testing in Power Automate Flows”
[Power Automate] Asynchronous Processing and Concurrency in Flows
Level of Difficulty: Beginner – Senior. In today’s fast-paced digital landscape, the need for efficient and responsive automation has never been greater. As developers and businesses strive to streamline operations, enhance user experiences, and tackle increasingly complex tasks, one key concept has emerged as a game-changer: asynchronous processing. In this blog post, we’ll dive deepContinue reading “[Power Automate] Asynchronous Processing and Concurrency in Flows”
[Power Apps] Working With SharePoint Lookup Columns in Lists, Through Power Apps
Level of Difficulty: Intermediate – Senior. In today’s dynamic digital workspace, organisations continuously seek versatile tools to enhance data interactivity and streamline workflows. Many organisations use the Microsoft suite which brings together their whole ecosystem which is generally accompanied by a SharePoint-central strategy. Citizen development and business processes largely make use of SharePoint lists andContinue reading “[Power Apps] Working With SharePoint Lookup Columns in Lists, Through Power Apps”
[Power Apps] Creating a Full Outer Join Between Collections in Canvas App
Level of Difficulty: Intermediate – Senior. To join or not to join! Let’s delve deep into the realm of data manipulation by introducing the concept of a “full join” and how to implement it between two collections in Power Apps. If you come from a database background, the term ‘full join’ might be familiar. ForContinue reading “[Power Apps] Creating a Full Outer Join Between Collections in Canvas App”
[Power Automate] Exporting a Power BI Report Page as an Image and Embedding it into a Word Document
Level of Difficulty: Beginner – Senior. Now, we all know that data speaks volumes, but only if we can understand its language. Power BI has been a game changer in converting complex data into insightful, visually engaging reports. But there’s more magic in the mix! Have you ever tried extracting a Power BI report intoContinue reading “[Power Automate] Exporting a Power BI Report Page as an Image and Embedding it into a Word Document”
[Automation] Integrating with the MusicMaker Bot on Discord (Using UiPath)
Level of Difficulty: Beginner – Senior. Discord is a great place to get a community of like-minded people together to partake in a whole range of activities, from gaming and home automation to Q&A community forums right across to using educational forums and everything in between. The more informal options often have text or voiceContinue reading “[Automation] Integrating with the MusicMaker Bot on Discord (Using UiPath)”
[Automation] Download Files from Google Drive in C#
Level of Difficulty: Beginner. There are multiple ways to download files from Google Drive, some of which require authenticaton and others that require lots of code. Here’s the simplest way to download the files, provided you’ve got the right file url. The above approach also works when writing to memory stream, instead of copying toContinue reading “[Automation] Download Files from Google Drive in C#”
[Et al.] Understanding UiPath Licensing Compared to Power Platform Licensing
Level of Difficulty: Beginner – Senior. As a follow-on from the post written comparing UiPath to the Microsoft Power Platform, this post aims to unpack the different licenses and licensing strategies implemented by the two different vendors. Since both are leaders in the automation space, it is apt to understand both when evaluating the feasibilityContinue reading “[Et al.] Understanding UiPath Licensing Compared to Power Platform Licensing”
[Automation] Getting Data from the ‘New’ GitHub Projects
Level of Difficulty: Beginner – Senior. GitHub Projects is nothing new – it has been around for a while now with a really cool API that allows you to pull data from it. For those who have made use of that functionality, it has been a breeze trying to automate and integrate different tasks acrossContinue reading “[Automation] Getting Data from the ‘New’ GitHub Projects”
The JPanda 