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

[Power BI] Connecting Power BI to an Excel File Stored on Microsoft Teams, SharePoint or OneDrive as a Data Source

Level of Difficulty: Beginner – Senior. Power BI reports are a quick and easy way to visualise existing data. Often, we want to visualise data from flat files that aren’t necessarily stored on our local computer but rather, files that are modified by other contributors. By storing a file on OneDrive or SharePoint (or indirectly,Continue reading “[Power BI] Connecting Power BI to an Excel File Stored on Microsoft Teams, SharePoint or OneDrive as a Data Source”

[Power BI] Creating a Hamburger Menu for Filters in Power BI

Level of Difficulty: Beginner – Senior. Often we create Power BI reports that require some sort of filtering mechanism but filters take up a lot of real-estate that could be used for other visuals instead. What if we could hide and show a filter pane using a “hamburger” menu mechanism? We can and here’s how.Continue reading “[Power BI] Creating a Hamburger Menu for Filters in Power BI”

[Python] Using Python for SQL Schema and Table Validation and Logging Progress to Microsoft Teams

Level of Difficulty: Intermediate to Senior. So you’ve reached created a database, you’ve created schemas and tables. You’ve managed to create an automation Python script that communicates with the database, however, you’ve reached a crossroad where you need to validate your SQL tables. Some of the validation might include ensuring that the tables exist andContinue reading “[Python] Using Python for SQL Schema and Table Validation and Logging Progress to Microsoft Teams”

[RPA] Using The Microsoft Office 365 Activity For Sending Emails in UiPath

Level of Difficulty: Beginner. This post will assist in using the Microsoft Office 365 Activity, specifically for sending emails with attachments, in UiPath. What are the steps? The steps that we will be following are: Follow the link on how to create an App Registration on Azure Get the Application ID and Tenant ID fromContinue reading “[RPA] Using The Microsoft Office 365 Activity For Sending Emails in UiPath”