Creating a Custom Component using the PowerApps Component Framework (PCF)

The PowerApps Component Framework (PCF) is a Microsoft framework for building custom components in PowerApps. Let’s go through what this actually means and how to build these components. In PowerApps and Dynamics 365, fields have types, such as Single Line of Text, Whole Number, Currency etc. For example, if we open our Account entity, we can see there are many fields, and these fields have different types: We can open … Continue reading Creating a Custom Component using the PowerApps Component Framework (PCF)

Embedding and Viewing an AI Builder Model in PowerApps and Dynamics 365

In our last post, we created a Binary Classification model using the AI Builder in Microsoft PowerApps. In this post, we will continue the example and embed the results in a PowerApp / Dynamics 365 so users can view these results. First, select the AI Model and in the bottom, click Publish: This will publish the model: Once complete, the model will show as “Live”: Now, let’s add this to … Continue reading Embedding and Viewing an AI Builder Model in PowerApps and Dynamics 365

Using the AI Builder in the Microsoft Power Platform for Binary Classification

In this post, we will look at how to use the AI Builder for PowerApps and Dynamics 365 to predict an outcome in the Microsoft Power Platform. Note at the time of writing this is Preview functionality. The AI Builder is an Artificial Intelligence feature of the Microsoft Power Platform that is used to perform AI functionality. In this post, we will look at a Binary Classification example. First, go … Continue reading Using the AI Builder in the Microsoft Power Platform for Binary Classification

Using the AutoNumber Field Type in PowerApps and Dynamics 365

In PowerApps, Dynamics 365 and the Common Data Service, we have the option to use a field type called AutoNumber, which automatically updates the data in the field to a set format and increments a number in the field. Let’s look at how to do this. Log into PowerApps at https://powerapps.microsoft.com/en-us/ and select your PowerApps environment: Let’s add an autonumber field to our Account entity. Go to Data->Entities and select the … Continue reading Using the AutoNumber Field Type in PowerApps and Dynamics 365

Get and Set Field Values using FormContext and JavaScript with Dynamics 365 and PowerApps

In this post, we will look at how to get and set field values using FormContext and JavaScript. Let’s say we want to get and set the Website field of the Account form: Let’s do this on Save of the form. Edit the form and go to Form Properties: Create a new JScript web resource: Add the following code: function GetSet(executionContext) { var formContext = executionContext.getFormContext(); // Get value var … Continue reading Get and Set Field Values using FormContext and JavaScript with Dynamics 365 and PowerApps

How to Disable and Enable Skype or Teams Presence in Dynamics 365 PowerApps Forms

In Dynamics 365 / PowerApps, Skype / Teams statuses can be displayed next to the names of users in fields. Below we can see the status as green (available): And if the user changes the status to Do not Disturb (changing below in Teams): We see the status updated automatically on the record: To enable/disable the status, go to the admin center at https://admin.powerplatform.microsoft.com/ and change the Skype presence: We see now … Continue reading How to Disable and Enable Skype or Teams Presence in Dynamics 365 PowerApps Forms

Accessing Advanced Customizations in PowerApps

In PowerApps, we can access Advanced Customization features. This will look familiar to Dynamics 365 developers and administrators who go into Settings in the Dynamics 365 app. To do this in PowerApps, log into https://powerapps.microsoft.com: and select Settings -> Advanced Customizations: This will open the Advanced Customizations pane: From here, we can manage Users, Security Roles, Themes, Publishers and Developer Resources. Users takes us to: Roles: Publishers: Developer Resources: Note … Continue reading Accessing Advanced Customizations in PowerApps

Import Excel Data into a Model Driven PowerApp using Data Integration Project

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

Download the Common Data Model Poster

Quick link to the Common Data Model poster on the CDM GitHub Repository. A nice one to print out. “Integrate and Disambiguate Data with the Common Data Model” –  https://github.com/Microsoft/CDM/blob/master/docs/CDMPoster_a3.pdf