powerplatform

Posts in this category.

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

Dataverse: The Importance of OrderBy When Retrieve more than 5k records

Jul 15, 2023

Lately, I've been playing with retrieving large sets of data from Dataverse. The total records that I need are more than 50k records (if you are using FetchXML, you can get the method here). But somehow seems like Dataverse limits my total records and here is how we fixed it. As...

Dataverse: UpsertRequest vs Custom API. Which one is faster?

Jul 8, 2023

For those who don't know, we already have UpsertRequest for so long (I learned how to use it correctly in this blog post that you can read here). UpsertRequest is a feature where we can request Dataverse to create or update the data based on columns that we are defined. In...

[Experimental] Let's try Dataverse Low-code Plugin (Automated)

Jun 11, 2023

Today, we will try the experience of creating Automated plug-ins using the latest Low Code Plugin from this documentation. For today's demonstration, I made the below tables (Header and Details) to do simple calculations (maybe). Prepare the Environment Before we start making the...

Share File into Power Virtual Agents from Dataverse File data type

May 20, 2023

For example, you have a table in Dataverse and let the user upload a File into it. Then, when other users interact with PVA (Power Virtual Agent/Chat Bot), we will allow the user to see/download the file. The flow of the scenario will be like the below image: As you can see, we...

Xrm.Utility.getEntityMetadata to get the localized label

May 14, 2023

I got a request to basically create PCF for Two OptionSet (boolean) with the main purpose is to keep Yes, No, and Null/Empty values. If you get the requirement, making it is not hard. But, usually in the project, we also need to support multi-languages. There's an article from...

Power Automate: Working with DateTime to Dataverse

May 6, 2023

As you know, working with DateTime is never an easy task. Especially if you also combine your Power Automate flow with Dataverse (which by default support showing DateTime based on the System User > Time Zone setting). So, today I will show a little bit of knowledge that I got...

MDA: How to invoke the formOnLoad event after saved

Apr 21, 2023

On form on load event, it is very common to set how the UI looks based on certain conditions. For instance, when the status of the entity/table is Inactive, we need to lock all the controls. So, today we will learn how to do it via JavaScript (client scripting). Without further...