[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] Retrieving a List of Mail Senders From a Shared Mailbox (Using Outlook and Python)

Level of Difficulty: Beginner – Senior. Have you ever had a use case where you have a shared mailbox setup on your Outlook but you don’t have the credentials to the account behind the mailbox (if one exists)? Well you can get around that by running the Python script detailed in this post. The approachContinue reading “[Automation] Retrieving a List of Mail Senders From a Shared Mailbox (Using Outlook and Python)”

[Automation] Working with SQL transactions in UiPath

Level of Difficulty: Beginner – Senior. When working with databases, the use of transactions is a very healthy habit to get used to. It will save you from those update or delete statements without a where clause that cannot be undone (especially in prod… Imagine…). UiPath presents the Start Transaction activity which claims to doContinue reading “[Automation] Working with SQL transactions in UiPath”

[Business Intelligence] Connecting a Google Sheet to Power BI as a Data Source

Level of Difficulty: Beginner – Senior. The market for data collection, visualisation and analysis tools spans across many different providers on many different platforms and in some cases, the best way to become exposed to the variety of tools is by mixing and matching between them. So why not visualise a Google Sheet on PowerContinue reading “[Business Intelligence] Connecting a Google Sheet to Power BI as a Data Source”

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

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