Category: Power Apps / Custom Pages / Dataverse / Power Fx

Create Data Export Profile Failed Error with Data Export Service

When using the Data Export Service, you may run into the following error when creating a new profile: “Create Data Export Profile failed. Following tables or stored procedures or user-defined types with the destination prefix {0} already exist in the database: TABLE : dbo.AttributeMetadata,dbo.GlobalOptionSetMetadata,dbo.OptionSetMetadata,dbo.StateMetadata,dbo.StatusMetadata,dbo.TargetMetadata. TYPE : dbo.StateMetadataList,dbo.StatusMetadataList,dbo.OptionSetMetadataList,dbo.TargetMetadataList,dbo.AttributeMetadataList. PROCEDURE : dbo.UpsertAttributeMetadata,dbo.UpsertGlobalOptionSetMetadata,dbo.UpsertOptionSetMetadata,dbo.UpsertStateMetadata,dbo.UpsertStatusMetadata,dbo.UpsertTargetMetadata. . Please delete these database objects before you create the profile.” In this case, these tables already exist in the … Continue reading Create Data Export Profile Failed Error with Data Export Service

Deleting a PowerApps Environment

To delete a PowerApps environment, log into https://admin.powerapps.com/ and go to Environments, then select the environment. Click Delete: Enter the name of the environment to delete: You will see: The environment will then be deleted.  

Retrieve and RetrieveMultiple JavaScript using Xrm.WebApi

Let’s look at how to use Retrieve and RetrieveMultiple using JavaScript and the Xrm.WebApi. Consider the scenario where we have an account: We can run this code in browser debugger. Hit F12 and let’s run this code: We get the output: And if we want to do a RetrieveMultiple: We get:  

How to Embed a Canvas App in a Model Driven App in PowerApps

In PowerApps, there are 2 types of apps, Canvas Apps and Model Driven Apps. If you are new to PowerApps, you can learn more about the differences here. In short, Canvas Apps are designed to build a flexible user interface that connects to various data sources easily, whereas model driven apps are designed with an out of the box business model that you can easily extend and integrate. In this … Continue reading How to Embed a Canvas App in a Model Driven App in PowerApps

Adding a JavaScript Function to a Field in Dynamics 365 Power Apps On Load with addOnChange

In this post we will look at how to add a function to field in Dynamics 365 / Power Apps, so when a form loads, the function will run on change of the field. We can do this by using addOnChange. Let’s say I have a field called My Optional Field (new_myoptionalfield) which is on an entity called My New Entity. The field is on the main form: Now let’s say … Continue reading Adding a JavaScript Function to a Field in Dynamics 365 Power Apps On Load with addOnChange

Create a Mobile App from an Excel Workbook with PowerApps

PowerApps are powerful! One of the great features is to be able to connect to an Excel spreadsheet and literally turn it into an app that you can use on your phone. Here we will go through just how to do that. First, let’s create an Excel workbook. I have one that has a list of Customers (fake numbers, of course!): Select the range of your data, and then Home->Format … Continue reading Create a Mobile App from an Excel Workbook with PowerApps

What are the Web API Primitive Types in the Power Platform and Dynamics 365?

They are: Type Web API Type BigInt Edm.Int64 Boolean Edm.Boolean DateTime Edm.DateTimeOffset Decimal Edm.Decimal Double Edm.Double EntityName Edm.String Image Edm.Binary Integer Edm.Int32 Memo Edm.String Money Edm.Decimal Picklist Edm.Int32 State Edm.Int32 Status Edm.Int32 String Edm.String Uniqueidentifier Edm.Guid

Enabling Flow on Dynamics 365 Forms and Site Map

To enable Flow in Dynamics 365, go to Settings->Administration and System Settings: Select Show Microsoft Flow on forms and in the site map: Click to Enable: You will then see Flows. Click to Create a flow: This will take you to below. Click Continue: You may see “When a record is select (deprecated)”: Click Delete: Add a new Trigger, searching for Dynamics 365: Select your D365 Org: Click to add … Continue reading Enabling Flow on Dynamics 365 Forms and Site Map

How Solution Version Numbers Work in the Microsoft Power Platform

Dynamics 365 Power Apps solutions contain a version number. These numbers are used to keep track of what functionality is contained in a particular solution release, as well as used by the Power Platform to determine if code being imported is a solution or a patch. When you create a new version, you will be asked to enter the version number. This defaults to 1.0.0.0: And must be in the … Continue reading How Solution Version Numbers Work in the Microsoft Power Platform