PowerApps Part 3 – Using an App on a Smartphone and Web

In our previous posts, we created an app that connects to Dynamics 365 and showed how to configure the app settings, share the app with users and publish the app. In this post, we will use the app on a smartphone and on the web. A nice feature of PowerApps is that when you create an app for mobile, you don’t need to go through the additional step of registering … Continue reading PowerApps Part 3 – Using an App on a Smartphone and Web

PowerApps Part 2 – Publishing and Sharing an App

In our previous post, we created a PowerApp that connects to Dynamics 365, displays a list of Accounts and allows a user to select an account and edit it, thereby submitting the change to Dynamics 365. In this post we will show how to publish the app, share it with different users, and use it on a smartphone. Let’s edit the app and prepare it for publishing. First, we want … Continue reading PowerApps Part 2 – Publishing and Sharing an App

PowerApps Part 1 – Creating an App from Scratch

PowerApps is “a service for building and using custom business apps that connect to your data and work across the web and mobile”. Put simply, think about the scenario where you would like to build an app, such as one that you have on your smartphone. Normally, this would be a complex task and would probably involve developers and heavy coding. Microsoft has created a service that allows apps to … Continue reading PowerApps Part 1 – Creating an App from Scratch

Creating, Deleting and Updating Records in the Data Export Service for Dynamics 365

The Data Export Service for Common Data Service apps such as Dynamics 365 is used to copy data from the cloud-based Dynamics 365 data store to an Azure SQL Server database. Let’s look at some synchronization examples. First, let’s connect to our Azure SQL database and search our accounts for an account where the name is TEST. We can see it does not exist: Now, in the Dynamics 365 org, … Continue reading Creating, Deleting and Updating Records in the Data Export Service for Dynamics 365

PowerApps and Common Data Service for Apps – Create Environment

The Common Data Service for Apps (CDS for Apps) is a way to build rich applications built as implemented by the Common Data Model (CDM) utilizing PowerApps. When you develop an app, you can use the standard base entities and build your own custom entities. From there, you can leverage business rules, business process flows, workflows and extend through code. To administer PowerApps environments, go to https://admin.powerapps.com/environments. You will see: This … Continue reading PowerApps and Common Data Service for Apps – Create Environment

Adding an OnChange Script Programmatically in Dynamics 365 Power Apps

In this post, we will look at how to programmatically add an OnChange script in Dynamics 365 Power Apps, so when a user tabs off a field, the script is run. First, when we tab off a field, such as this fax field on the account record, we would like our script to run: Without doing this programmatically, we would select the field and select Change Properties: Then go to … Continue reading Adding an OnChange Script Programmatically in Dynamics 365 Power Apps

Update a Record using Xrm.WebApi

Let’s look at how we can use the Xrm.WebApi to update a record. Let’s use the Account entity, where we have a field called My New Field (new_mynewfield): Here’s the update script: We can run this in the browser console or in a web resource. We see we get a Success callback: In advanced find, we see the field has been updated: Interestingly, if we were to run this with … Continue reading Update a Record using Xrm.WebApi

Get the Id of a Record on a Page in Dynamics 365 Power Apps

Let’s look at how to get the Id of a record in Dynamics 365 Power Apps using JavaScript. We can see below our Account record with the Id in the URL: To get the Id of the record in JavaScript, let’s run the code below, which Xrm.Page.data.entity.getId(); or by passing the formContext: formContext.data.entity.getId(); And to remove the curly braces: Xrm.Page.data.entity.getId().replace(“{“, “”).replace(“}”, “”); Or formContext.data.entity.getId().replace(“{“, “”).replace(“}”, “”);  

PowerApps Landing Page Tour

When navigating to https://powerapps.microsoft.com/, users will see a link to sign in on the top right. Click Sign In: From here, users will be directed to the PowerApps landing page. Here you will see several links, including: Home Learn Apps Data Business Logic Notifications Let’s look at each. Home Learn Apps Data This contains additional options for Entities, Option Sets, Data Integration, Connections, Custom Connectors, Gateways: Business Logic (Flows) Notifications Design … Continue reading PowerApps Landing Page Tour

PowerApps – Useful links, blogs and resources

Below is some useful PowerApps resources. PowerApps Community at Microsoft PowerApps Guided Learning at Microsoft Webinars PowerApps Documentation at Microsoft – Find Apps, Create Apps, Administer Apps PowerApps Blog at Microsoft Developing Business Applications with Microsoft PowerApps, CDS, and Flow at EdX