tips

Posts in this category.

Dataverse Benchmark: Calculated Column vs Formula Column

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...

Overview Work queues

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...

Power Automate: Sending Email Reminders to close Dataverse record

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....

MDA: Add confirmation and validation async onSave

Sep 15, 2023

I just learned that in Model Driven Apps (MDA), we can enable async OnSave handlers. Why does it matter? The simple answer is the majority of the API(s) around it also changes to become async as well. For example, in certain conditions of the record, we want to show confirmation...

Using PowerFX with commands for cloning records with N to N relationship

Sep 2, 2023

Today we will learn how to create a command bar to clone a record with many-to-many relationships. For those who don't know, in Model-Driven-Apps, we can create a command bar (previously known as "ribbon button") that uses PowerFX (low code) query. First, I created 2 tables for...

Dataverse: SSIS vs. ExecuteMultipleRequest

Aug 26, 2023

I am always curious to try SSIS (as mostly my experience is on customizing CRM CE/Dataverse side) as people are always telling me how fast it is to process large data. So today, we will learn and compare ExecuteMultipleRequest vs. SSIS. In the SSIS part, we will be using...

How to call OnPremise WebAPI from Canvas App

Aug 13, 2023

In a time where technology is very fast changing, I see some of the Organizations that still rely on so-called legacy systems or probably still depend on systems that just run on their network (on-premise). So, today, we will learn how to call on-premise WebAPI from Canvas Apps....

MDA: Open Lookup Record In SidePane

Jul 22, 2023

I've got a request from my friend about how to implement opening a lookup in the side pane. For this requirement, we must implement the addOnLookupTagClick, the createPane, and the navigate functions. Without further ado, let's see how to do it! First, we will use the Task table...