[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”

[Azure] Creating an Azure Blob Storage Resource and Container

Level of Difficulty: Junior. Do you have files that you would like to store in Azure? Azure Blob Storage is perfect for that. Here’s the 101 on Azure Blob Storage that will be covered in this post: Create a Resource Group Create an Azure Blob Storage Account Resource Create a Container Upload Files Retrieve ConnectionContinue reading “[Azure] Creating an Azure Blob Storage Resource and Container”

[Automation] Using Google Drive, Google Sheets and Python in Google Colaboratory to Automate Rubric Creation and Synchronisation

Level of Difficulty: Intermediate – Senior. Have you ever run into a situation where you have over 200 students whose work needs to be marked and the admin around it is enough to make anyone go crazy? Well here’s a step towards getting around the labour-intensive admin that goes hand-in-hand with marking student projects, usingContinue reading “[Automation] Using Google Drive, Google Sheets and Python in Google Colaboratory to Automate Rubric Creation and Synchronisation”

[Power Platform] 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 “[Power Platform] Retrieve Power Automate Flow Run Logs and Visualise in Power BI”

[RPA] Getting Started With UiPath Insights Cloud

Level of Difficulty: Beginner. UiPath Insights is an RPA analytics solution that enables your business to track, measure, and manage the performance of your entire automation program. UiPath Insights can be used with a cloud orchestrator or a stand-alone orchestrator. If you have a stand-alone orchestrator, you can follow this guide to set up UiPathContinue reading “[RPA] Getting Started With UiPath Insights Cloud”

[RPA] Conditional Assigns in UiPath – Using The Shorthand IF Statement

Level of Difficulty: Beginner. Have you ever wanted to assign a variable based on the value of another variable but… Without the use of an IF statement block? Here’s how to achieve that. Let’s take an example… We have a boolean variable, named UnicornsExist which can be set by the user through an input dialog.Continue reading “[RPA] Conditional Assigns in UiPath – Using The Shorthand IF Statement”

[RPA] Automating Azure DevOps Project, Repository and Work Items Creation through UiPath

Level of Difficulty: Beginner – Intermediate. This post will assist in automating the creation of projects, repositories and work items in Azure DevOps through UiPath by using the Azure DevOps API. There are multiple Azure DevOps libraries available on the UiPath Marketplace that make the API calls for you but the aim of this postContinue reading “[RPA] Automating Azure DevOps Project, Repository and Work Items Creation through UiPath”

[RPA] Using SQL User-Defined Table Types in UiPath as a Component of a Data Exchange Architecture

Level of Difficulty: Intermediate – Senior. This post will assist in understanding what SQL user-defined table types (UDTTs) are and how they can be used within UiPath as a part of a Data Exchange Architecture (DEA). Following explanations of UDTTs and DEA approaches, we will do a practical implementation walkthrough. User-Defined Table Types (UDTTs) User-definedContinue reading “[RPA] Using SQL User-Defined Table Types in UiPath as a Component of a Data Exchange Architecture”