Latest posts

Notes on code and the things I build.

devops , dynamics-crm , powerplatform , tips

Power Platform Pipelines: Deploy Solution using specified Service Principal - Part 2

Aug 17, 2024

Based on part 1 which you can read here, I realized that creating a plugin to automate the approval process will be easier compared to creating Power Automate Flow. The main reason is, that if we need to use Flow, then we need to create multiple connection reference components...

dynamics-crm , low-code , powerautomate , powerplatform

Power Platform Pipelines: Deploy Solution using specified Service Principal

Aug 10, 2024

Someone asked me about an interesting scenario which I think is also very common when we want to implement ALM (Application Lifecycle Management). He has multiple service accounts that will be the owner of all the solution components on each of the environments. For example, the...

.NET , Architecture , Azure , dynamics-crm , powerplatform

Dataverse: Create Custom Integration To Azure Cosmos DB for PostgreSQL

Jul 20, 2024

In a world where integration is common to do. Especially, because clouds is a common term, for sure, there are requests to integrate Dataverse with another DB (for reporting, or other system process purposes). Today, we will learn how to create Dataverse Plugins to do CUD...

.NET , Architecture , C# , dynamics-crm , tips

(Dataverse) .NET API Implement Multiplexing Strategy

Jul 5, 2024

In some scenarios, we sometimes need to add a middleware (in this case .NET WebAPI) that connects Dataverse to other applications for integration. The reason can vary such as making the connection, request, and response to Dataverse simpler. If the integration loads are high and...

dynamics-crm , powerautomate , powerplatform , Ssrs

Dataverse: Download SSRS Report using Custom API

Jun 29, 2024

Lately, I've been exploring "not-so-new" requirements where I want to download SSRS reports from Dataverse and use them elsewhere (if you want to use the low-code method, you also can read Nick Hance's blog post that implements the same thing. The difference here is I'm using...

C# , dynamics-crm , powerplatform , tips

Dataverse: Query data using Fiscal Period and Year

May 25, 2024

Do you need to query data with the filter based on the Month/Year based on the specified date in your records? Today, we will learn how to query it and hopefully, you can implement it in your future project! For example, we have several records of Sales Order with the below...

dynamics-crm , powerplatform , tips

Dataverse: Update Time zone adjustment from Time zone Independent to User Local and Date time Behavior

May 18, 2024

Hello everyone! I'm sharing my observation regarding Dataverse Date time (again). Previously, I updated several DateTime attributes from Time zone adjustment "User Local" (which is the default value) to "Time zone independent". Then, my functional reported that the Date Time...