• 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
    • OptionSet Mapping in KingswaySoft SSIS

      Arpit Malhotra, 16 April 2019

      Mapping CRM OptionSets is fairly simple when migrating data using KingswaySoft SSIS. It allows you to either map the options using the optionset value or using the optionset name. However, things may become complex if your source and the destination system have optionsets with different value and di

      Read the full article here
    • Enable Entities for Dynamics 365 for Outlook

      Megha Kainth, 15 April 2019

      Dynamics 365 App for Outlook lets you create activities, track emails, create records in CRM from Outlook. Some out of the box entities are searchable by default - for example Account, Contacts and Leads. Some entities such as custom entities aren’t available in the app out of the box. To allow use

      Read the full article here
    • Data Import Error - Microsoft Dynamics 365 Fields were not Found

      Megha Kainth, 12 April 2019

      One of our clients had an issue with Data Import, where while trying to import data an error was getting displayed – "The Records were not updated because the following Microsoft Dynamics 365 fields were not found: <field name>". This was a bit strange as the field was right there in the Heade

      Read the full article here
    • Combine Columns to Import Data in Dynamics 365

      Megha Kainth, 11 April 2019

      Recently, one of our clients was having trouble while importing data in Dynamics 365. They exported data from another system to import into Dynamics 365. That system has fields for First Name and Last Name but has no combined field for Full Name. They exported the data in a csv file and wanted to i

      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
    • How to Create, Share, Delete and Set a Personal View to Default in Microsoft Dynamics 365

      Harshani Perera, 09 April 2019

      A view in Microsoft Dynamics 365 is like a saved query where you can add filters to show the relevant records you require. Once you create the view with your criteria, all you need to do is select the view in CRM and you will see all the records that meet this criteria. Before you create, share or d

      Read the full article here
    • Upgrading to Dynamics 365 with Click Dimensions

      Zoe Sands, 08 April 2019

      When upgrading to Dynamics 365, it’s important to be aware of any add-ons you may have. For example, we recently upgraded a system from Dynamics CRM 2015 to Dynamics 365 Online which contained Click Dimensions. The Dynamics 365 Online environment already had Click Dimensions installed. When importin

      Read the full article here
    • How to Set the Entity Image on a Contact in Dynamics 365 Using C#

      Adam Murchison, 05 April 2019

      When trying to set an entity image for a contact programmatically it may seem logical that you would set it using the base64 string of an image just like you would set the ‘documentbody’ field in an annotation, but this is not the case for entity image. When deciding on an entity image for the conta

      Read the full article here
    • Enabling the New Dynamics 365 Online Unified Interface by Default

      Paul Nieuwelaar, 04 April 2019

      In Dynamics 365 Online, you can now set the Unified Interface client as the default and only mode for users. In other words, you can completely disable the old classic UI, and force users onto the new UCI. Previously this was not possible, so when users tried to access the default URL, e.g. https:/

      Read the full article here
    • Get More Storage Space by Switching to the Latest Dynamics 365 CRM Licensing

      Gayan Perera, 03 April 2019

      In April 2019, Microsoft announced a raft of changes to the way Dynamics 365 CRM licensed. One these changes is related to storage. Prior to April 2019, the following was true: •    Storage meant data records + files + audit records •    10GB of storage by default •&nbs

      Read the full article here
    • Dynamics 365 CRM and NZBN Add-On Solution Now Available!

      Gayan Perera, 01 April 2019

      A New Zealand Business Number (NZBN) is a free, globally unique identifier, available to all Kiwi businesses. With an NZBN, it’s faster and easier for businesses to connect and interact, which will save everyone time and money. An NZBN holds all the key information organisations are most often aske

      Read the full article here
    • Data Migration Is like Moving House

      Nick Chin, 29 March 2019

      I’m Nick and I have been working with Microsoft Dynamics CRM for over 10 years. In that time, I have done many data migrations and I have also moved to a new house a few times. There are many similarities between data migration and moving to a new house; I’m going to list a number of lessons I have

      Read the full article here
    • Hide/Unhide Search fields on Lookup Window in Dynamics 365

      Jasper Marri, 28 March 2019

      An overlooked feature of Dynamics 365 is the ability to hide the search box on lookup window for an entity. In this blog, I would like to share how we can do that as it can be used to keep users from searching on look up window if necessary. Let’s use the Account entity as an example: We have a par

      Read the full article here
    • New Dynamics 365 Portal Feature: Diagnose and Resolve Problems

      Jordan Hohepa, 27 March 2019

      With recent upgrades to the Dynamics 365 Portal there are a few new options available on the Portal Configuration page. These options can be seen on the left side navigation in the screenshot below. To get to this configuration page you need to navigate to the Dynamics 365 Administration Center, cli

      Read the full article here