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

In Dynamics 365 and Power Apps, when we create forms we will probably require users to fill out certain fields. Fields are defined as Business Required, Business Recommended, and Optional. Required fields mean the user needs to enter data into the field before a record can be saved. The Dynamics 365 Power Platform field definition allows us to set which types of fields fall into which category. Once these are … Continue reading Client Side Validation for Dynamics 365 and Power Apps Forms With JavaScript and Business Rules

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

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: [sourcecode language=”JavaScript”] var Entity = "account"; var Id = "d2720425-53ad-43c3-b9dc-e7452b80ae13"; var Select = "?$select=name"; Xrm.WebApi.retrieveRecord(Entity, Id, Select).then( function success(result) { console.log("Success: " + result.name); }, function (error) { console.log(error.message); } ); [/sourcecode] We … Continue reading Retrieve and RetrieveMultiple JavaScript using Xrm.WebApi

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

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

To get the Web Api URL for your Dynamics 365 Power Apps org, go to Settings->Customizations->Developer Resources. It is under Service Root URL: You can then paste this into a web browser:  

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