Notes on code and the things I build.
Jan 20, 2024
Still talking about the Virtual Table (Entity). Last week, we learned how to configure the Virtual Table (Entity) that reflects data from SQL DB (which you can learn here). Today, we will learn how to prepare the solution for export and import it to other environments! Prepare...
Jan 13, 2024
What we will learn in this blog post is about retrieving data in SQL Table (outside of Dataverse - via Virtual Table mechanism) and creating the simplest business logic possible (in my opinion). For example, we want to build a point-based system where we can Add and Deduct the...
Jan 6, 2024
In architecting a solution, we have lots of ways to do it. Specifically, in the Power Platform world, we can combine Dataverse (Dynamics CRM) with Power Platform to do integration/whatever scenarios that we need. But, what if we want to implement the generic integration with only...
Dec 16, 2023
Have you ever heard about Dataflows? Dataflows is an automation to copy (from various data sources) > Transform (Power Query Transformation - which leverages the same technology with PowerBI) > and paste (to Dataverse/Power BI workspace/Azure Data Lake Storage Account). I will...
Dec 9, 2023
Today's demonstration will show AI Copilot Control (Preview) on the Model Driven App. The scenario I can think of is when a user clicks the command/ribbon button on selected tables, we will let the user interact with AI Copilot Control for that table. Initially, I want to use the...
Nov 26, 2023
It's been a long time since I wanted to try the offline capability of Dataverse in the Canvas App (You can learn more in this official documentation). Again, the one that makes me curious is how the system behaves (in terms of managing concurrency and how we enforce strict...
Nov 19, 2023
Hi Folks! This time, we will learn about Elastic Table. Before we begin, I need to credit the great Mark Carrington for his blog post (about Elastic Table too) that you can read here. Elastic Table is the new way to store data in Azure Cosmos DB for heavier workloads with...
Nov 11, 2023
In Dataverse, we have lots of Data Types that we can use. But, there are two Data Types that seem similar (in terms of functionality -I skip the rollup columns as this type has a period of time/manual to be refreshed). We know the great Calculated Columns that have already been...
Oct 28, 2023
UPDATED: Carina M Claesson DM-ing me that this feature is already in GA based on this article (but in my tenant, the label naming is still in Preview). Sorry for the confusion guys 😊. Work queues is a feature based on Dataverse, that simplifies the process for creating queue...
Oct 22, 2023
I think you guys mostly notice. When faced with low-code features (Power FX or Power Automate), it took me longer than creating the same solution using code 😭. So to make myself smarter, today, we will learn how to implement email reminders to close the Dataverse record....