• Logging a Power Platform ticket with Microsoft

      Alfwyn Jordan, 06 June 2019

      As a Dynamics 365 administrator, you may be familiar with requesting support from Microsoft through the Office 365 admin site as documented in an earlier blog post but now we can submit support requests through the Power Platform Admin Center. You can access the portal at https://admin.powerplatform

      Read the full article here
    • Ensuring users can view Duplicate Records in Dynamics 365 v9

      Alfwyn Jordan, 14 May 2019

      Recently one of our Dynamics 365 clients came to us saying that some users were unable to see the results of a duplicate detection rule when entering new contacts. Instead of seeing the duplicates that had been found by the rule, an empty view like the one below was displaying:  After a bit of

      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
    • Fix Incorrectly Created Status Reasons in Dynamics 365

      Alfwyn Jordan, 10 April 2019

      You’ve accidentally deleted the default status reason of an entity and now you’re receiving an error code 0x80040353 every time you create a new record in the entity, and you want to know how to solve the issue. First, you’re going to create a new solution with just the entity involved and then you’

      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