Microsoft Dynamics CRM

{New Tool} Crypto for Dynamics 365

It has been a while that there was a new tool being published from my end on Dynamics CRM. One of the recent things that I noticed which was needed was the ability of people to be able to encrypt sensitive/critical information.

This is particularly relevant in some scenarios in Dynamics 365 implementations such as:

  • Storing Credit card information in Dynamics 365
  • Storing bank account details in Dynamics 365
  • Storing sensitive information such as Public service numbers in Dynamics 365(For example Social security number in US, etc.)

In all such scenarios, there is need to encrypt certain fields in addition to field security. Me and fellow CRM community member Simaranjit researched about this and have come up with a set of workflow activities which let you encrypt and decrypt the fields that you wish. Not only that you can choose between two encryption standards:

AES Encryption

AES (acronym of Advanced Encryption Standard) is a symmetric encryption algorithm.

The method looks like this:

  • From the 128-bit key, AES generates 10 keys of 128 bits each.
  • These keys are placed into 4×4 arrays.
  • The plain text is also divided into 4×4 arrays (128 bits each).
  • Each of the 128-bit plain-text items is processed in 10 rounds (10 rounds for 128-bit-keys, 12 for 192, 14 for 256).
  • After the 10th round the code is generated.
  • Each single byte is substituted in an S box and replaced by the reciprocal on GF (2 8).
  • Then a bit-wise modulo-2 matrix is applied, followed by an XOR operation with 63.
  • The lines of the matrices are sorted cyclically.
  • The columns of the matrix multiplication are interchanged on GF (2 8).
  • The sub-keys of each round are subjected to an XOR operation

MD5 Encryption with TES Algorithm

The MD5 algorithm is a widely-used hash function producing a 128-bit hash value. Due to its vulnerabilities, we have combined the MD5 algorithm with another algorithm Triple DES Cryptography to enhance its performance. A configured alphanumeric string is used for computing the hash key.

Here is a video demonstrating the tool:

Here is the download link: Click here

Note: This is one way of encryption/decrypting CRM data and adding additional security on top. CRM provides encryption over the database as shared on following link:  Click here

Hope it helps and Happy CRMing!




Google Play Store:

Microsoft Dynamics CRM

{Quick Tip} Add Record Hyperlink with text in Send Email via workflow in Dynamics CRM

It is a very common scenario to send record URL while sending emails from Workflows in Dynamics CRM.

Ever been in a situation where notifications need to be sent with URL via Email to a user/set of users for example on creation of a new Opportunity.

Using out of box workflow(Settings->Process->New) and Send Email step, this can be achieved easily:


Send Email step Set Properties:


When Email is sent out, it will appear as below:


Notice the way that the record URL does not appear as a hyperlink but full URL.

Here is a simple solution to make record URL appear as Hyperlink:

Navigate back to the Send Email step of the workflow, Click set properties and Select Insert Hyperlink:


Insert Text and select URL as Record Dynamics URL and click OK:


Notice that this time Email body will be generated with hyperlink with a meaningful text:


Remember, Giving attention to Little details creates the best user experience!

Please keep in mind that in internet facing deployments the record URL always points to the external URL. This can be a bit annoying for users as they probably need to authenticate before they can open the record mentioned in the email.

Hope it helps and Happy CRMing!




Google Play Store: