• How to set the Default Value for a Dynamics 365 Lookup Control in a Canvas PowerApp

      Colin Maitland, 20 August 2019

      In this article, I demonstrate how easy it is to set the default value for a ComboBox control associated with a Dynamics 365 Lookup field in a Canvas PowerApp.The demonstration application is a sample ‘Leave Requests’ Canvas PowerApp. The app uses the Common Data Service (CDS) connector to access a

      Read the full article here
    • Creating a new PowerApps Portal integrated with Dynamics 365

      Jordan Hohepa, 02 August 2019

      Over the past few months Microsoft have talked about a new App Type in PowerApps which is called the PowerApps Portal. This will allow organizations to create a website, similar to the currently available Dynamics 365 Portal, which will allow External Users to interact with the organizations systems

      Read the full article here
    • Autonumbering in Dynamics 365 CRM v9 with the new PowerApps Feature

      Jordan Hohepa, 26 July 2019

      With Dynamics 365 there has sometimes been a need to have some sort of autonumbering field on specific Entities. Autonumbering has been available out of the box for a limited number of Entities and the setting for this is available via Settings -> Administration -> Autonumbering. The screensho

      Read the full article here
    • Power Platform Licensing

      John Eccles, 18 June 2019

      Power Platform unlocks the potential of Dynamics 365 and Office 365. It opens the door for non-software developer users within organisations to manage data and electronic forms, automate business processes and enable mobility. An organisation needs licensing to use Power Platform. In this blog, I wa

      Read the full article here
    • Embedding Maps into a PowerApps Canvas App

      Isaac Stephens, 10 June 2019

      Maps are a great visual way of seeing where a location is and the area around it. This makes embedding a Map into your PowerApp an extremely useful tool. But how do you do this? And what options are there? Currently PowerApps does not let you add a Map as an OOTB control, but here is a way to add a

      Read the full article here
    • How to Import a PowerApp Package

      Colin Maitland, 28 May 2019

      PowerApps can be exported as a package from one environment and then imported into another environment. In this article, I will demonstrate how to import a PowerApp package. This demonstration uses a simple ‘Leave Requests’ PowerApp that connects to Microsoft Dynamics 365. A Plan 1 or Plan 2 licence

      Read the full article here
    • Using Data Integration in Microsoft PowerApps

      Isaac Stephens, 21 May 2019

      Storing data in a CDS entity is a useful way to have it accessible to your PowerApps applications. This is because rather than embedding the data source directly into each of your applications you can connect multiple apps to one source. Another benefit of using CDS is that you can create a Data Int

      Read the full article here
    • Filtering data in PowerApps using Search and Tags

      Isaac Stephens, 15 May 2019

      It is easy to search for an item in PowerApps with the built in Search() function by simply setting the Items attribute in your Gallery to Search(source, textbox.txt) as shown in the image below. However, this only looks for that exact sequence of characters/words. Sometimes you will want to search

      Read the full article here
    • PowerApps -- Passing Null Values to Entities in CDS

      Alfwyn Jordan, 26 April 2019

      In the current version of PowerApps, passing null to a text field is fairly easy as you can use the function Blank(). As the document states, this only works for data sources that support null values. CDS as a data source does not currently allow this. To get around this, we need to enable an experi

      Read the full article here
    • Importing data from Excel into the Common Data Services using Power Query

      Alfwyn Jordan, 17 April 2019

      While working with CDS I was attempting to import data to a newly created entity (“prospects”) from an Excel workbook. I’d tried using the “Get data from Excel” functionality only to be greeted with the following message: “Your import is done. 0 row(s) successfully imported to cr3e2_prospects entiti

      Read the full article here
    • Referencing Collection Columns in PowerApps

      Alfwyn Jordan, 08 March 2019

      When using PowerApps it is quite easy to work with and refer to individual columns in a collection. For example, if we have a collection of fruit, created using the following code:     Collect(Fruit, {ID:“1”, Type:“Apple”, Colour:“Green”}, {ID:”2”, Type:”Lemon”, Colour:”Yellow”},

      Read the full article here
    • New PowerApps View Editor for CDS Model Driven Apps and Dynamics 365

      Jared Johnson, 14 February 2019

      With the addition of solutions for Model Driven apps in PowerApps, we are getting replacements for many of the old editors that have barely been updated since CRM 2011 or earlier including the solution editor, form editor and view editor. Funnily enough this is the second time a new view editor has

      Read the full article here
    • Custom Entities in Business Process Flows for Model-Driven Apps

      Isaac Stephens, 21 January 2019

      The Issue: You may have noticed when creating Business Process Flows (BPF) in PowerApps from your own Entities that they don’t always show up in the dropdown box in the ‘create new’ wizard. This is because by default you are not able to create BPF’s from a custom Entity, you must first enable it you

      Read the full article here
    • Share PowerApps with Another User

      Megha Kainth, 30 November 2018

      PowerApps can easily be shared with another user from the same organisation. To share your app, sign in to PowerApps. Click on Apps. Select your App from the list and Click Share. Enter user’s name or email address. Check the Co-owner tick box if you would like the user to edit and share the app. Cl

      Read the full article here
    • Create PowerApps using Data from Excel

      Megha Kainth, 29 November 2018

      PowerApps can be created using data from an Excel spreadsheet. Users can create their tables in Excel and upload it to OneDrive. In this blog, we will learn – how to create a PowerApp using Data from Excel. Open a worksheet in Excel and insert a table to it. Add some data such as First Name, Last Na

      Read the full article here