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 Power Apps: Don’t Forget Those Pesky Table Permissions
I created my first Power App. The app, a canvas app, is supported by (2) tables in the Dataverse. The app manages meetings for an internal community. It allows members to sign-up to speak to the community on a topic relative to the community. I shared by app with my teammates, giving them all Basic…
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 Azure: Doh! Built-in App Service Identity Provider Not Working!
In adding the built-in Authentication support to an Azure App Services, I ran into a challenge where I kept getting a 401 Status Code whenever I called an API endpoint. The first thing after setting up Azure Active Directory as my Identity Provider, I used Postman to call the oauth2 token endpoint to get a…
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…