Tuesday, December 31, 2019

Dynamics 365 Customer Engagement release version transparency

By now, you should be aware know that all Dynamics 365 Customer Engagement Online environments are on the same “major” version but it is also important to understand that Dynamics 365 CE receives continuous updates on a weekly release cadence. You probably already saw these updates being announced in Office 365 message center.

Each update is deployed as part of a Release Train, stopping at each ‘station’ along the way before rolling on to subsequent station. Not all regions would be on the same release as any time. Early station will have lower levels of number of customers impacted, ending with Europe and North America where majority of our customers are and then dedicated scale groups where customers with larger organisations are hosted. For a more in-depth session on this topic I can highly recommend the recording BRK2039 - Microsoft PowerApps and Dynamics 365: Modernizing the way we update

In November 2019  Microsoft updated their documentation and provides a lot more transparency on this release process - so you can now get a full overview of Released Versions of Dynamics 365 for Customer Engagement which outlines all previous releases as well as the upcoming releases in the different stations.

The version number mechanism for Dynamics 365 CE instances has also been updated so it is now easier to see which update has already been rolled out to a specific instance.

Dynamics 365 and Power Platform monthly reading list November 2019

Technical topics (Configuration, customization and extensibility)

Topics for Dynamics 365 Business Application Platform analysts, project managers and power users

Friday, November 29, 2019

Microsoft webinar redelivery Dynamics Power! Saturday Brussels December 3th

Two weeks ago we had Dynamics Power! Saturday Brussels - a community event on Microsoft Business Applications with over 250 attendees and 25 different international speakers.

For those of you who were not able to make it, Microsoft will organise a short redelivery of 3 sessions in webinar format on Tuesday December 3th - more info and registration available on https://www.microsoftevents.com/profile/form/index.cfm?PKformID=0x8855388abcd 


  • Updates on Power Platform (UI Flows, AI Builder, … )
  • Integration between Dynamics 365 Sales/Customer Service and Dynamics 365 F&O (ERP)
  • Dynamics 365 Mixed Reality

Thursday, November 28, 2019

Transition to the Unified Interface presentation from Dynamics Power! Saturday Brussels 2019

I had a lot of fun presenting at Dynamics Power! Saturday Brussels 2019 together with @philipverlinden and @stephanedujour

The presentation was largely composed using the slide decks that Microsoft made available in the Unified Interface Playbook


Dynamics 365 and Power Platform monthly reading list October 2019

Dynamics 365 – 2019 Wave 2 topics

Technical topics (Configuration, customization and extensibility)

Topics for Dynamics 365 Business Application Platform analysts, project managers and power users

Monday, October 21, 2019

Using Twitter analytics data in Power BI – Part 1

I have been using Twitter for over 10 years but I never paid a lot of attention on engagements or impressions statistics but after listening to the Microsoft flow with Jon Levesque podcast  from @nz365guy I decided to take a look at what are drivers for more impressions or engagements on my Twitter account. So I decided to create some Power BI reports based on Twitter activity exports.

I only used Power BI in proof of concepts up until now so this was a good opportunity my Power BI skills which got a little bit rusty after not using it for more than a year. To get started I first exported my tweet activity report in CSV format from Twitter Analytics  (I did it manually but there is a REST API available as well). Next I combined the different CSV files while loading it into Power BI (I followed these instructions - How to load data from a folder in Power BI). After the usual data cleansing (remove unused columns, rename columns, setting appropriate date types) and data transformation I started extending the data model. Since I also wanted to know whether there is a difference in engagements/impressions based on the day of the week the tweets was sent, I created a custom date dimension. Power BI creates a default date dimension as well but I decided not to use this – see Power BI Date Dimension: Default or Custom? Is it confusing? for more info.

I also wanted to remove the urls/hyperlinks from my tweet text before building up a word cloud with the most common terms. Luckily Power Query supports some interesting transformation, you can temporarily transform a text into a list using Text.Split(text, “”), perform operations on each word and then reassemble it again using Text.Combine(list, “ ”)  (Trick found on Multiple replacements or translations in Power BI and Power Query)

I used a similar trick to found out the number of hashtags used in a specific tweet.

The Power BI report is still a work in progress but if you already want to have a temporary copy - DM me on Twitter


Tuesday, October 15, 2019

Quick tip: Using XrmToolBox with a MFA enabled login

More and more customers are introducing Azure Multi-Factor Authentication (MFA) for Dynamics 365 CRM and while this is a good idea, there are some gotchas. If you are using XrmToolbox – the Swiss army knife in the Dynamics CRM consultant tool belt – you will need to revise the way you setup connections to your CRM/CDS environments.

Use the SDK Login Control when choosing a connection method

Next click on Open Sdk Login Control – this will open the standard browser login page and will allow you to fill in the details required in MFA.


Tuesday, October 08, 2019

Dynamics 365 monthly reading list September 2019

Preview 2019 Wave 2 release topics

Technical topics (Configuration, customization and extensiblity)

Topics for Dynamics 365 Business Application Platform analysts, project managers and power users

Saturday, September 14, 2019

Getting started with Forms Pro : customer feedback is the ultimate truth

On  July 1th, Microsoft announced the general availability of Microsoft Forms Pro. Microsoft Forms Pro is an enterprise survey tool built on top of Microsoft Forms and the Common Data Service (CDS). Forms Pro allows you to design surveys in a user-friendly manner, distribute these surveys to your target audience and afterwards analyze the results using the built-in dashboards or using Power BI. Microsoft Forms Pro has been part of the Microsoft Forms Pro April 2019 release.
Forms Pro has been built on top of the Common Data Service (CDS) which allows for a deep integration with Dynamics 365 for Sales & Customer Service. (For background on CDS and Dynamics – read Making sense of XRM,PowerApps and some other acronyms (CDS,CDM, etc..)).

The goal of Forms Pro is to capture customer's (or employees) feedback about their experiences with and expectations for your products or services. By analyzing the response and taking appropriate action, you can increase customer loyalty, decrease customer churn and improve the way that your organizations interacts with customers, etc …

The goal of this blog post is to highlight some of the features I have been using on the project I’m currently working on  – for more extensive information I can highly recommend the blog posts by Megan Walker on the subject (see list at bottom of only  few out of the 20+ posts) as well as her Youtube FormsPro play list. Another option is to listen to  Episode 58 of the CRM MVP podcast

Getting started
To get started you need to install Forms Pro from AppSource (the Forms Pro solutions are already installed on a Dynamics 365 CE instance but are hidden by default) which will enable the forms editing and management environment. When you open it for the first time (https://forms.office.com/FormsPro/Pages/DesignPage.aspx) – it will show you a sample survey which is created in the default CDS instance.

If you want to create your surveys in a specific CDS (or Dynamics 365 instance) – you need to select this instance in the top right corner.

Creating a survey
I really like the survey design environment which is very easy to use. You can quickly add different types of questions – choice, text/long text, rating, date, Likert, Net Promotor Score, … with the ability to also format the questions (basic options such as bold,italic, font type/size, etc…).  Some question types you will have additional features e.g. render choice questions as dropdown or choice options, for ratings using stars or numbers and ability to use 1-5 options, …

You can personalize your surveys by inserting placeholders/parameters but  also by adding conditional branching rules in your surveys for the different questions – e.g. if a low NPS rating is given, you might want to ask extra feedback. You can hide questions and then make them visible using the conditional rules.  For more details see https://docs.microsoft.com/en-us/forms-pro/create-branching-rule

Theming your surveys is quite easy with the ability to change colors  and add images (for background and header) as required – at the moment there is no support (yet) to add custom CSS.

Distributing the survey
There are many ways of distributing your survey, manually send it, embed it in a web page, using your own distribution channel (e.g. SMS or other marketing platform) or using a QR code. But Forms Pro also comes with Microsoft Flow integration which provides Flow templates to send Survey invitation on common business transactions like sending out a survey when a customer case has been closed, asking feedback after a purchase, etc …. You can customize these Flow templates or create from scratch depending on business needs.

Viewing and analyzing survey responses
On the overview tab, you are able to see summary data about your survey like number of invites, number of responses received, Net Promotor Score (NPS) etc… You are also able to drill into the details of the question responses etc and export the data to Excel from here. Another interesting functionality is Survey Insights which uses AI and machine learning to find correlations between question answers and calculation of a sentiment score for text-based questions.


Forms Pro is a new product but it builds on top of both Microsoft Forms and the CDS platform of which a lot of functionality is leveraged. Although the foundational functionalities are very strong,  there are still some gaps and rough edges that you will encounter during an implementation.  But having worked with the Forms Pro product team in the previous months reassures me that the product team is open to feedback and are working hard on improving the product. Customers who are currently using the Voice of the Customer module should plan a migration path since  (source: Replace your Voice of the Customer Surveys with Microsoft Forms Pro)  If you think that some  functionality is missing I highly recommend you to use the Forms Pro Suggestion box on UserVoice .
In a next blog post, I will delve a little deeper into some of the gotchas and share some tips and tricks when implementing Forms Pro.


Blog posts by Megan Walker on Forms Pro:

Sunday, September 08, 2019

Introducing the PowerApps Checker PowerShell module to check PowerApps solution quality

Microsoft recently updated their tooling for checking the quality of  CDS/PowerApps/Dynamics 365 solution files by releasing the PowerApps checker PowerShell Module . With this new PowerShell module it is possible to receive a detailed report for your solutions identifying problems/issues taking into account best practices around performance, usage, upgrade readiness, supportability and maintainability. The static code analysis is based on rulesets which are provided by Microsoft and which are updated on a regular basis.

The main difference with the previously released tooling in the PowerApps maker portal (See Announcing general availibility of Solution Checker) is that you can now also do checks to validate both managed and unmanaged solutions (CRM2011 to current) so include on-premise solution validation.

The PowerShell module can be installed from https://www.powershellgallery.com/packages/Microsoft.PowerApps.Checker.PowerShell/1.0.2  and provides a number of commands that you can use to perform the checks.

Before you can use the Invoke-PowerAppsChecker PowerShell cmdlet ,  you need to create an Azure Active Directory (AAD) application in a tenant with PowerApps or Dynamics 365 licenses. Follow the steps on Get started using the Microsoft.PowerApps.Checker.PowerShell module to correctly do this using either PowerShell or manually.

The PowerAppsChecker cmdlets in interactive-mode (meaning you need to login everytime you run the checker) or using an application-based token.

Behind the scenes the PowerShell module will connect to the PowerApps checker Web API

The output of Invoke-PowerAppsChecker  is a zip file containing one or more reports in a standardized JSON format. The report format is based on static analysis results referred to as Static Analysis Results Interchange Format (SARIF).

By analyzing results and fixing indicated errors, you can learn how to write high-quality code and decrease the cost of fixing issues later.

Depending on the size & complexity of your project, I might be recommended to include it as part of your ALM strategy.

Other blog post:

Tuesday, September 03, 2019

Dynamics 365 monthly reading list August 2019

Preview 2019 Wave 2 release topics

Technical topics (Configuration, customization and extensibility)
Topics for Dynamics 365 Business Application Platform analysts, project managers and power users

Monday, August 19, 2019

D365 CE 2019 Wave 2 Preview: Dynamics 365 Business card scan preview feature

Top request by customers: scanning business cards and capturing the information will be available in the upcoming Dynamics 365 release and is now available in instances with early access enabled. It worked remarkably well except for my own business card ...


The functionality seems to be provided by the new "AI Builder Business Card control" which is added on the quick create contact form. Next on the todo list - testing out modifying the mappings.

Saturday, August 17, 2019

D365 CE 2019 Wave 2 Preview: enable contextual email communication

One of the upcoming enhancements that a lot of my colleagues were excited about is  Contextual email communication in Dynamics 365 for Sales & Customer Service.  Contextual email communication allows you to overlay an email composition screen on top of the existing Dynamics 365 forms without having to navigate away from the screen that you are on. After you have enabled your environment for early preview access you can go to App Settings > Enhanced email  to enable this new functionality. (You might need to do a hard refresh after enabling use CTRL-F5)

After you enable this feature, adding an e-mail to the timeline will open the composition overlay allowing you to consult information on the contact while creating your e-mail.

Thursday, August 15, 2019

Early opt-in to Dynamics 365 CE release wave 2

You can now enable the features coming in the 2019 release wave 2 update by opting in to the updates in the Power Platform Admin Center. Opting in will enable all changed user experience updates for Dynamics 365 for Customer Engagement.

Don't do this on your production environment but test it out on a copy of production - once enabled you can not turn this off

From October 2019, all environments will be enabled for 2019 release wave 2. Opting in now, allows you to get hands on experience with wave 2 changes and testing out the impact on your specific solution setup.

Tuesday, August 13, 2019

Dynamics 365 monthly reading list July 2019

Technical topics (Configuration, customization and extensibility)

Topics for Dynamics 365 Business Application Platform analysts, project managers and power users

Thursday, August 01, 2019

Azure Databricks training material on Microsoft Learn

Still on my todo list – reviewing the 15 modules on Azure Databricks and the learning paths for data engineering with Databricks.
Modules : https://docs.microsoft.com/en-us/learn/browse/?products=azure-databricks
Learning Path : https://docs.microsoft.com/en-us/learn/browse/?products=azure-databricks&resource_type=learning%20path

Code tip: Nullable datetime in C#

Nullable types are used when you need to represent the value of an underlying type. By default DateTime is not nullable in C# because it is a Value type, but using the Nullable construct (or the ? shorthand), you can assign the null literal to the DateTime type. Syntax is below:

 DateTime? dt = null;  
 Nullable<DateTime> dt = null;  

Wednesday, June 19, 2019

Dynamics 365 monthly reading list May 2019

Technical topics (Configuration, customization and extensibility)

Topics for Dynamics 365 Business Application Platform analysts, project managers and power users

Wednesday, June 05, 2019

PowerApps Component Framework available in public preview

On April 23th the PowerApps Component Framework (PCF) and the PowerApps CLI was finally made available for public preview. The PowerApps Component Framework (PCF) is the foundation for all controls used in the new Unified Interface released with Dynamics 365.

PCF allows 3d party developers to build visual components using the same framework which is used internally by Microsoft (see picture below for some examples) in the unified interface.

Components created using the PowerApps Control Framework are solution aware and can be used to build a more compelling user experience. The Dynamics365 developer community immediately picked up on this exciting news and Andrew Ly already shared the source code for 3 different controls  - Progressbar control , keybinding example  and countdowntimer.

Guido Preite  @crmanswers also set up PCF Gallery which contains a list of different controls like a timeline control, data card and UK postcode validator. Everyday new controls based on PCF are added.

The PowerApps Component Framework has been in private preview for quite a while but some details were already shared on a number of occasions in 2018. Initially the framework was called Custom Controls Framework and I you encourage to take a look at some interesting post from Bob Guidinger on this topic (see references below). Do keep in mind that there are some changes between the private preview and public preview – see Update existing custom components for more details.

You will notice from the documentation that most samples are using Typescript to implement custom components so I added also some other reference links below which might help you to get started. For a brief introduction you might also want to take a look at the PowerApps April community call recording (PCF presented from 00:47:00 onwards). One thing to note though is that this is a framework which is clearly targeted at professional developers so the Dynamics consultant who occasionally writes some Javascript web resources or some simple plugins in C# will face a steep learning curve. I even think that pure Javascript/.NET developers even have an edge on the average Dynamics consultant when trying to learn the necessary skills required for PCF development.


Tuesday, May 21, 2019

General availability of PowerApps Solution checker makes it easier to check Dynamics 365 solution quality

On May 2th Microsoft announced the general availability of the PowerApps Solution Checker, tooling which allows you to run a static code analysis of your CDS and Dynamics 365 solutions against a set of best practice rules. By running these checks, you can identify problematic patterns in your code base which might impact performance or maintainability/upgradeability of your code.

Tooling like this is a must have for Dynamics 365 CE Online where releases are delivered on a continuous basis (with bi-weekly releases). With this release schedule, the risk of low quality solutions (from ISVs or SIs) interfering with Microsoft updates becomes more probable.

But this is not only about Microsoft safeguarding their Dynamics 365 SAAS platform but also about delivering value quicker and in a reliable fashion. I truly believe that code quality is a good indicator about how quickly developers can add business value to a software system. Static code analysis tools such as PowerApps solution checker might not be the holy grail but they at least give you an indication of the amount of technical debt that you have amassed within your Dynamics 365 instances.

I have been using PowerApps solution checker since a couple of months now and for projects with lots of different teams working on solution it allows you to have some indication of code quality without having to delve through 10.000 lines of code.  I also think that announcements such installing the solution checker by default, introduction of the Solution Health Hub and the announcement of PowerShell script support coming soon are showing Microsoft’s commitment on finally delivering on a good DevOps story for Dynamics 365.


Monday, May 13, 2019

Dynamics 365 monthly reading list April 2019

Technical topics (Configuration, customization and extensibility)

Topics for Dynamics 365 Business Application Platform analysts, project managers and power users