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  

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

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

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

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

PowerApps – Using a Model Driven App on Your Smartphone

To access a model-driven app from a mobile device, you have 2 options: Download and install the Dynamics 365 mobile app Access your organization from a web browser To access through the mobile app, first install the app and log in. You will then see a list of published apps: Select an app to use it. Here we are selecting an app we previously created: When using the website on … Continue reading PowerApps – Using a Model Driven App on Your Smartphone

PowerApps – Create a Model-Driven App

In this post we will go through creating a model-driven app. These types of apps are different from canvas apps, which we created in a previous post. Log into https://web.powerapps.com/. In the bottom right, select Model-driven apps: You should see something like below. Select + New app: You will probably receive this message, as we have not yet created any databases – “No database found. To work with apps, you need … Continue reading PowerApps – Create a Model-Driven App

PowerApps, Canvas Apps, Model Driven Apps, Common Data Service and Dynamics 365 Explained

Microsoft has made several exciting new releases and updates to its PowerApps and Dynamics 365 platforms. In this post, we will explain what the different types of PowerApps are and the differences between Canvas Apps vs Model-Driven Apps. We will also discuss the Common Data Model and the Common Data Service, and what the new Common Data Service for Apps exactly is. We will then show how Dynamics 365 ties this … Continue reading PowerApps, Canvas Apps, Model Driven Apps, Common Data Service and Dynamics 365 Explained