[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] Basic Exception Handling in Power Automate Cloud Flows

Level of Difficulty: Beginner – Senior. Power Automate is a powerful tool that works well for integration and even automating workflows. Citizen developers have started adopting Power Automate to automate some of their day-to-day activities. One of the most important parts of a traditional solution development strategy is error and exception handling. Automation would typicallyContinue reading “[Automation] Basic Exception Handling in Power Automate Cloud Flows”

[Automation] Things I wish I knew Before my First Power Automate Hyperautomation Implementation

Level of Difficulty: Beginner – Senior. Any toolset comes with it’s own unique tricks and challenges. There is a ‘first time’ for everything which comes with a list of lessons learnt. By sharing these lists, we better prepare the community of developers who may be facing similar challenges. Here’s a summarised list of lessons learntContinue reading “[Automation] Things I wish I knew Before my First Power Automate Hyperautomation Implementation”

[Automation] Using Power Automate as a Data Integration Tool with Excel (for Bulk Processing)

Level: Beginner – Senior. Power Automate connects into multiple different platforms and systems, making it a very powerful integration tool. Power Automate has been positioned by Microsoft as a platform that aims to facilitate Robotic Process Automation (RPA). Although there is still some work to be done before the Power Automate toolset can match competitors,Continue reading “[Automation] Using Power Automate as a Data Integration Tool with Excel (for Bulk Processing)”

[Automation] 10 Tips for Optimising Power Automate Flows

Level of Difficulty: Beginner – Senior. Power Automate is a powerful tool that allows for integrations and RPA solutions to be developed through the use of Power Automate Desktop and Cloud flows. A disadvantage of using Power Automate is that it can take strain when working with large volumes of data. Lengthy flows take longContinue reading “[Automation] 10 Tips for Optimising Power Automate Flows”

[Automation] A Comparison Between UiPath and Power Automate

Level of Difficulty: Beginner – Senior. Automation is becoming a hot topic in conversations about the fourth industrial revolution (4IR) and fifth industrial revolution (5IR). Automation is referred to as the use of technology to replace human labour or even work alongside people in some way, leading to some sort of benefits (or saving) ofContinue reading “[Automation] A Comparison Between UiPath and Power Automate”

[Azure] In-Stream Excel Manipulation in .NET Core, using Azure Blob Storage and Azure Functions

Level of Difficulty: Junior – Senior. So you have an Excel template stored in Azure Blob Storage which will be read and manipulated by inserting data into the Excel template returning the manipulated file in stream. This can either happen (Time Trigger) on a schedule or per request (HTTP Trigger) basis. The decision is toContinue reading “[Azure] In-Stream Excel Manipulation in .NET Core, using Azure Blob Storage and Azure Functions”

[Automation] Retrieve Power Automate Flow Run Logs and Visualise in Power BI

Level of Difficulty: Intermediate – Senior. This post will focus on pulling the Power Automate flow run logs, using PowerShell, exporting them to a CSV file and visualising them in Power BI What are the steps? The steps that we will be following are: Setup PowerShell Get the data Visualise in Power BI Setup PowerShellContinue reading “[Automation] Retrieve Power Automate Flow Run Logs and Visualise in Power BI”