Posts in this category.
The bigger your Contacts/Accounts (Customers) data, the more it also consumes your Dataverse Database Capacity. I had a client who had a database overage problem, and further checking, the CustomerAddress table was on the list. If you open the table, you will find lots of empty...
I'm fairly certain that all of us agree that we are performing mundane code to obtain input parameters when developing custom APIs. For populating the context.PluginExecutionContext.InputParameters, we need to extract each parameter and cast the value to the correct data type,...
Azure Durable Functions is an extension of Azure Functions that offers specialized capabilities, including statefulness, orchestration, handling retries, and support for running long-running operations. The orchestration functions can help us group multiple processes and bundle...
With the hype of Model Context Protocol - it's kinda a plugin for LLM (Large Language Model) to interact with the external tool(s), I always wonder how to create one. For my field, which is Power Platform - Dataverse, I saw the great Natraj's GitHub repo about MCP Dataverse, and...
As a (lazy) Developer, I always find a way to implement something as simply as possible. The more experience that we are gaining over the years will eventually show us certain language features/components that can support it. For example, in today's blog post, we want to create a...
When we want to push data to Dataverse/Dynamics CRM using SSIS - KingswaySoft, usually there are relationships (lookup) that we need to settle. In KingswaySoft, there are multiple ways to handle the Lookup: Do not use TextLookup (Input values are provided in GUID Format) Use...
In the PowerApps-Samples repo, I found interesting sample code to execute Dataverse messages using WebAPIs call. For those who ask why there is this option, it is because not so many organizations let you install NuGet Packages freely without having risk analysis (the reason can...
Let's try to create a simple scenario that we can do in Azure Data Factory! Azure Data Factory is a serverless data integration service that sits in the Azure. The terminology of ETL (Extract, Transform, and Load) or ELT (Extract, Load, and Transform) can be processed by it, and...
If you remember, I created this blog post on how to create a class that wrapped ServiceClient. I must do it because instancing a ServiceClient is expensive (around 2 seconds). Hence, I need to find a way to "store" it in memory and ensure it is always ready when I need to call...
Last week, we learned how to create an email notification to remind us if App Registration in Azure expires. Today, we will learn how to apply automation to generate a New Secret and update the Dataverse Environment Variable. In the flowchart, here are the steps that we will do:...