Posts in this category.
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...
Hi! I'm back after so a long hiatus (probably I'll write the reason for this later 🤣). As [lazy] Developers, we're most likely to interact with a "wrapper" (can be components, services, etc) that hides all the complexity needed. But, I believe at some point, we will be facing...
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...
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...
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...
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...
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,...
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...
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...
Today we will learn how to create a Custom Connector from scratch and implement API Key Authentication. The authentication code that I used is the reference from the below YouTube video from Nick Chapsas: https://www.youtube.com/watch?v=GrJJXixjR8M Without further ado, let's...