Solve concurrency problems in Dynamics 365 with this free Open source tool

Dave Clark
Jun 6, 2019 · 3 min read
Photo by Connor Wilkins on Unsplash

Dynamics 365 encourages users to manage their data concurrently. Users can view and update records even while their colleagues are modifying the very same records. This contrasts with the old days of Excel sheets being locked when in use by another user.

The challenges of concurrency

What happens when two users access the same record and update it at the same time? Since CRM 2015 Update 1, Dynamics 365 has supported optimistic concurrency, which is detailed in a previous Capgemini post.

The idea is simple, the entities now have a property called RowVersion (auto incremental number) which stores the retrieved version of the record. When an Update or Delete request is executed (and the ConcurrencyBehavior has been explicitly configured), Dynamics 365 will compare if the record RowVersion is the same than the one stored in the database and rollback the operation if they’re not.

However, this feature is only available through the SDK, and can’t be added with basic form customisations. Some developers have found an internal function to access the RowVersion property, but because the function isn’t documented by Microsoft, it isn’t supported.;

So to answer the initial question: when two users update the same record at the same time, the resulting record in the database is a combination of both records. However, if both users updated the same field, then the database will store the value entered last. The user who hit save a few seconds before would therefore lose their data.

Overcoming the challenges

With reference to this post I’ve offered two potential solutions, though these require either C# code or unsupported JavaScript.

I’d like to offer an alternative approach which is lightweight, configurable, supported and requires no code to setup.

Get Along is a small, documented tool which can be installed in any Dynamics 365 environment and configured to notify users when a record they’re viewing is modified by someone else. For developers, the installation is as simple as:

  1. Downloading Get Along from its GitHub page.
  2. Adding a single script file to the relevant form (i.e. Contact or Account).
  3. Registering an onLoad event handler.
Here it is in action

At the time of writing, the project is new and only supports an information-style notification banner to users. The project has a backlog of new features on the way, including:

  • Configurable alert dialog boxes with buttons as a choice rather than notification banners.
  • Configurable notification text displayed to users.
  • Hopefully more added by contributors (the project is open source).

Wrapping up

Being notified of changes elsewhere isn’t always desired behaviour. Users might want to be left alone to manage their data, and could be well aware that other users are tinkering with the same records.

However, sometimes data loss on forms is a problem for businesses.

  • A process within the business might dictate that only one user should be updating a record at one time.
  • Form logic might execute on update of certain fields, that all users should be made aware of. Because form logic is client-side, users will not see this change unless they’re notified to refresh the record.
  • Users may be used to notification behaviour if they use other collaboration tools such as Microsoft Excel Online or Confluence.

There are solutions available such as introducing optimistic concurrency which, as we’ve explored, can either be complex or require unsupported code.

Get Along offers a lightweight, configurable and supported solution to data loss. The project is open source and has a backlog of new features in the pipeline which will grow to support further configuration.

Capgemini Microsoft team

To share best practices, knowledge and experiences of the Capgemini Microsoft team

Dave Clark

Written by

Power Platform content and tutorials for professionals

Capgemini Microsoft team

To share best practices, knowledge and experiences of the Capgemini Microsoft team

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade