Posts tagged with this topic.
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...
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...
Another journey on how to create a Power Automate Custom Connector with .NET API 8. Last week, we created a .NET API Project that implements the API Key for the Authorization process. Today, we will add more features including adding monitoring logs using Azure Application...
Currently, I'm still focusing on how to improve bulk processing in Dataverse. After implementing User Multiplexing, we will learn another consideration that we can apply which is the total threads and chunks of data per thread. Of course, some variables such as network speed,...
I have an interesting question about how to get the Azure Key Vault Secret from the plugin. The official documentation about the RetrieveEnvironmentVariableSecretValue action states that it can only be triggered from Power Automate Flow. The problem with this step is that it...
We always love SQL4CDS by Mark Carrington. One of its features is using the TDS (Tabular Data Stream) Endpoint for reading data. On one of the cron jobs, I have a logic to aggregate the sum of the data. Although I was using SQL4CDS Engine to retrieve the data, I observed the...
Last week, we learned that bulk operation messages offer higher performance than ExecuteMultipleRequest. Today, we dig deeper with the sample of scenarios that I prepared so you can understand when you need to use ExecuteMultipleRequest vs bulk operation messages. Enjoy!...
This is another benchmark post; this time, we need to compare ExecuteMultipleRequest vs CreateMultipleRequest. For those who don't know ExecuteMultipleRequest allows us to basically mix operations (Create, Update, or Delete) and pass parameters to control if an error is raised...
Have you ever wondered why we can't change the default view when clicking Add Existing in the Subgrid area on Model Driven Apps and at the same time you need to implement business logic to limit users to select the record based on a specific view (similar with this thread)? Fear...