Adding a Database to an Existing PowerApps Environment

To add a database to an existing PowerApps environment, do the following. Log into https://admin.powerapps.com/ and go to Environments, then select the environment. You will see a Create my Database button. Click it: You will see below: Select a Currency and Language, then click Create my Database: You will see “provisioning database”: Once complete, it will look like below: Go to https://make.powerapps.com/. Select the environment, and you will see the entities installed:  

Convert a PowerApps Trial to Production

To convert a PowerApps environment from a Trial to Production, log into https://admin.powerapps.com/ and go to Environments. Select the environment: On the right, click the Convert button: You will be prompted, click Confirm: Once complete, you will see the message “This environment was converted to production”: On the Environments page, the type will now show as Production:  

Installing Visual Studio 2019

The install Visual Studio 2019, go to https://visualstudio.microsoft.com/ and click Download: Select the edition. We will install Enterprise: Open the file. Click Continue: You will see: Now select the components to install, then click Install: The installer will run: And finally, the reboot: After restarting, select Visual Studio 2019: Select an option, e.g. Create a new project. You can now start using Visual Studio 2019:  

Dynamics 365 Plugin Registration Input string Was Not in a Correct Format Error

In this post, we will look at when happens when you get the error “An unexpected error occurred. —> System.FormatException: Input string was not in a correct format.”. You may have created a plugin using Visual Studio, and signed and compiled it. You then import it into the Plugin Registration Tool and you get this error (you can copy it into Notepad if you can’t see it in this UI): … Continue reading Dynamics 365 Plugin Registration Input string Was Not in a Correct Format Error

Using GitHub with Visual Studio

In this post, we will look at how to use GitHub with Visual Studio. Download and Install First, let’s download and install the GitHub extension for Visual Studio. In Visual Studio, select Mange Extensions and find the GitHub Extension for Visual Studio, then click Download: You will see a message to restart VS: Click Modify: We see the extension installing: Click Close when complete: Create Project Now let’s create a … Continue reading Using GitHub with Visual Studio

Tips for Getting Parameters from Windows Navigation Rules in USD

In this post, we will look at some things to note when getting parameters from Windows Navigation Rules in Unified Service Desk (USD). When running an Entity Search in a Windows Navigation Rule, we can use the Id of the record in the entity search using [[id]]. That will then give us everything we need regarding the record. When we get into the Actions behind a Windows Navigation rule, we … Continue reading Tips for Getting Parameters from Windows Navigation Rules in USD

Hiding the Plus Button on a Subgrid in Dynamics 365

In Dynamics 365, on subgrids there is a plus button which can be used to add records. In some cases, you may want to hide this button from users. For example, let’s say on the Account form you would like to hide the + button on the Contacts subgrid: To do this, we can use the Ribbon Workbench application. Let’s first create a new solution and add the Contact entity … Continue reading Hiding the Plus Button on a Subgrid in Dynamics 365

Register a Function OnLoad of a SubGrid in Dynamics 365 Power Apps

In this post, we will show how to register a function that runs on the loading of a subgrid in Dynamics 365. Consider the Contacts subgrid, of which the control is called “Contacts”: We can write code to get the control below using the formContext: var subgrid = formContext.getControl(“Contacts”); Now, in order to add a function, we use the addOnLoad method. Let’s add a function on the fly here: subgrid.addOnLoad(function() … Continue reading Register a Function OnLoad of a SubGrid in Dynamics 365 Power Apps

Filtering Subgrids in Dynamics 365 Power Apps with setFilterXml

Subgrids in Dynamics 365 allow us to do several things with JavaScript. In this post, we will look at filtering a subgrid using setFilterXml. Note this appears to be an unsupported method, please check the Microsoft documentation to see if this becomes supported. Let’s look at the Contacts subgrid on the Account entity: Note the Contacts subgrid is called Contacts: The subgrid is a control, and we can get it … Continue reading Filtering Subgrids in Dynamics 365 Power Apps with setFilterXml