Notes on code and the things I build.
Azure , azuredatafactory , dynamics-crm , low-code
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...
.NET , AI , dynamics-crm , powerplatform
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...
devops , dynamics-crm , tips
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:...
dynamics-crm , low-code , powerautomate
Have you ever forgotten to create a new secret for your Azure App Registration causing your application to error? The problem with the UI is we can't detect when the secret will expire. And of course, I'm too lazy to open 1 by 1 to check when the secrets will expire! From the UI,...
BulkDeleteRequest is a feature in Dataverse that we can use to delete data across multiple tables. It is based on a scheduler (optional) and runs in an asynchronous process (as this process runs in the background, meaning this operation will not be performance-friendly). By...
.NET , dynamics-crm , powerplatform , tips
As a person who cherishes "Early-Bound" so much, I want to ensure my team also uses it in the project. The step to generate the "Early-Bound" is not too complicated, especially after Microsoft Power Platform CLI (pac modelbuilder build). But, again, enforcing it on other team...
dynamics-crm , powerplatform , tips
This is another benchmark blog post, in which I tried to upgrade the greatest snippet on how to do bulk insert, update, or delete (blog post by Mark Carrington that you can read here) with the async operation. As you know, the latest Dataverse ServiceClient supports async...
dynamics-crm , powerplatform , tips
Quick tips for those who want to retrieve data using QueryExpression, join it with multiple tables, and filter it using OR condition based on LinkEntities. To simplify the explanation, let me show the SQL Query that we want to achieve for the scenario: SELECT contact.firstname,...
dynamics-crm , low-code , powerplatform
If you use the Appointment table, some attributes like RequiredAttendees and OptionalAttendees are tricky to use in Power Automate. For instance, if the Appointment status is completed, you want to trigger an email that needs to be sent automatically to the...
We must construct the SQL Connection String when connecting to Dataverse TDS Endpoints via .NET code. The structure of it by default is just "Server={orgname}.crm.dynamics.com;Database={orgname};Persist Security Info=False;". When we talk about SQL connection strings, there are...