Category: Power Apps / Common Data Service / Dataverse

In this post, we will look at how to set lookup and option set values when creating records in the Web API. Let’s create an Account record. Account have fields such as the following: Parent account – lookup Industry code – Option Set Do not email – boolean Credit hold – boolean Shipping method code – option set Currency Id – lookup Let’s create some JavaScript to create a new … Continue reading Setting Lookups and Option Sets when Creating Records in Web API

As part of the transition to Unified Interface, we can use the Unified Interface Transition Portal to help us. Go to https://runone.powerappsportals.com/. You will be prompted to log in and accept the permissions: Then confirm your details: Select My Environments: From here, you can see the current transition status, and the target date: Selecting an org will show details on the Rescheduling Requests: And you can also click on My Requests … Continue reading Unified Interface Transition Portal Helps with Move to UCI

In this post, we will look at how Managed Properties in manged solutions in the Power Platform work. These can be useful if you want control over how much a user can customize a managed solution component once it has been deployed in a target environment. First, let’s create a new solution: And add a new entity called People: We see the entity is part of our solution: Let’s go … Continue reading How Managed Properties in Power Platform Solutions Work

In Dynamics 365, there are several functions that we can call from the Web API. You can see a list of these functions here. When calling these functions, we can use Xrm.WebApi.execute and specify an action as the operationType: In some cases, this doesn’t appear to work as expected, and you may need to revert to sending through the request using XMLHttpRequest. Let’s look at the example of using the … Continue reading Calling the RetrieveEntity WebAPI Function with Enum Types

In this post, we will import data from an Excel spreadsheet into a model-driven PowerApp, creating a Data Integration Project that uses Power Query. First, let’s look at a spreadsheet we have. It contains 2 accounts, with the account name and revenue: This spreadsheet is sitting in a SharePoint library. Let’s go to PowerApps.com and pull up our model-driven app. Select Entities: Clicking on Accounts, we can see the data … Continue reading Import Excel Data into a Model Driven PowerApp using Data Integration Project

When using JavaScript, we can display alerts in model-driven Power Apps. To do this, we can use openAlertDialog. The syntax for this method looks like below: Xrm.Navigation.openAlertDialog(alertStrings,alertOptions).then(closeCallback,errorCallback); As a simple example, we can use: var alertStrings = { confirmButtonLabel: “Got it”, text: “Something happened.”, title: “Alert Title” }; var alertOptions = { height: 500, width: 500 }; Xrm.Navigation.openAlertDialog(alertStrings, alertOptions).then( function success(result) { console.log(“Alert dialog closed”); }, function (error) { console.log(error.message); } … Continue reading How to Display an Alert in Power Apps using JavaScript