Adventures with the Power Platform: Handling Dataflow Upserts

I want to import data from an Excel workbook into my Power Platform Dataverse. To get started, I created a Table to hold the imported data. I added a single column called Name to my Table. I created my Dataflow, in my example, it was from an Excel file hosted in OneDrive. I followed the…

Adventures with Blazor: Custom Markdown Component

I created a simple Blazor Markdown component, you can download it at NuGet Gallery | PhatBrainSoftware.MarkdownEdit 1.0.1. Below is a screenshot of the component in action. The code is at phatbrainsoftware/MarkdownEdit: Blazor markdown editor component. (github.com), feel free to fork and make some changes!

Adventures with Azure DevOps: Manual Validations

I wanted to test adding approvals to an Azure DevOps YAML pipeline, outside of Environment approvals. I created a project that contains the following files: deploy.bicep – Bicep template that will create a storage account in Azure. validate.ps1 – PowerShell script that mocks a validation stage, could be a what-if or some other validation. deploy.ps1…

Adventures with Cosmos: Delete All Documents

When testing my Cosmos database I often like to reset the containers, or in other words, delete all the existing documents. Unfortunately, there is no way to do a DELETE * FROM in Cosmos, at least not yet. I know I could create a Console Application or Azure Function to do this, but I was…

Adventures with Bicep: How to Create an App Service for Containers

I wanted to create the following Azure resources: Azure Container Registry App Service Plan App Service The App Service would need to support Linux containers. I have been doing a lot with Bicep, with the following bicep file as my first attempt: When I ran my script the first time, it wasn’t setup for containers,…

Adventures with PowerShell: Add or Update Resource Tags

Whenever I deploy a release to Azure, using Azure DevOps, I like to add or update a tag with the current build version. To do this, I created a PowerShell script called UpdateTags.ps1. In full disclosure, transparency, and whatever other buzz words there are now for coming clean, I cobbled this script together from a…

Adventures with Azure DevOps: Connect to Azure Database for MySQL

I have been doing a lot around Azure DevOps as of late, and started dipping my toe into the CI/CD for databases, thought of calling it DataOps, but that doesn’t look like the correct term. Anyway, in my Azure DevOps pipeline I wanted to run a few tasks against an Azure Database for MySQL, e.g….

Adventures with Azure DevOps: Assembly Version Validation

I have a .NET 5 Web Api that I deploy using classic pipeline in Azure DevOps. When my Web Api is published I want to confirm that the correct version was really deployed, sometimes things happen where the deployment is successful but for some reason the older assembly might not be overwritten. In my Web…