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

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

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

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