Tip #1023: Go directly to any entity in Dynamics 365

Today Leon Tribe gives us a great time saving tip. Send your tips to jar@crmtipoftheday.com.

Want to save time and go directly to a specific entity? Let’s say that you want to find a KB article. Rather than log in to CRM and then go to KB articles, why not go directly to the KB articles?

You can if you know the URL format

https://<dynamics 365 instance>/main.aspx?pagetype=entitylist&etn=<entity system name e.g. knowledgearticle>

So if your org is leonrocks and you want to go to the case entity, you would enter

https://leonrocks.crm.dynamics.com/main.aspx?pagetype=entitylist&etn=incident

Tip #1022: Finding your least active Dynamics 365 users

Neil “Mr. Agile” Benson sent us a great tip on how to identify your least active CRM users. Got a tip? Send it to jar@crmtipoftheday.com.

 was recently asked by a client to find a list of the least active Dynamics 365 users. Believing that my client just wanted to find these users so that she could give each of them a hug and some “special coaching”, I installed the Organization Insights dashboard (https://appsource.microsoft.com/en-us/product/dynamics-365/mscrm.04931187-431c-415d-8777-f7f482ba8095?tab=Overview).

The Active Users dashboard shows me the Most Active Users Performing Operations chart, but that’s only the top ten users. You can find a list of all the active users and their operations in the Organization Insights download area.

 

To find a downloadable list of active users:

  1. Click on the last tab on the left-hand side of the Organizational Insights dashboard.
  2. Select ‘Most Active Users Performing Operations’ and click Download.

 

Note that Organization Insight’s downloadable lists, unlike the charts, are not sensitive to the date range selection.

With the list of 88 active users and a list of all 100 licensed users, my client was able to pay a special visit to 12 licensed users who hadn’t logged in yet. I hope they all survive their special coaching experience.

Tip #1021: Everything is an app

If you provisioning a trial and accidentally or deliberately missed the checkboxes enabling Customer Service, you will end up with Dynamics 365 instance with the “facelifted” Web UI but nothing else. Where’s the much tooted Universal User Interface (UUI) that was meant to replace Interactive Service Hub in the version 9? Well, it’s simply not installed.

One thing to remember that, in the new world, everything is either an app or a solution. Which is also an app but a “first-class” app, accessed via administration center. If you are craving to explore UUI:

  • Open Dynamics 365 Administration Center (https://port.crmX.dynamics.com/G/Instances/InstancePicker.aspx)
  • Select your instance
  • Click little pencil icon next to Solutions
  • Select Customer Service Hub, click Install
    Customer Service Hub Not Installed
  • Have a cup/can/bottle of a hot/cold beverage of your choice
  • Open your instance, click on Dynamics 365 on the top
    Customer Service Hub is available

Enjoy exploring it. Incidentally, that’s the only way to access Knowledge Articles.

Tip #1020: Dynamics 365 mobile offline limitations

The following functionality does not work offline:

  • Workflows
  • Plug-ins
  • Cross-entity business process flows
  • Entity-level business rules

Limitation for mobile offline JavaScript client SDK for Create Record and Update Record

The client SDK can’t be used to create or update intersect entity records; offline disabled entity records; or activity party entities records. No upfront validation of data input occurs. All data-related validations are done during the sync to Dynamics 365.

Limitation for mobile offline JavaScript client SDK for Delete

The client APIs can’t be used to delete the intersect entity; offline disabled entity; or activity party entities.

Limitations for mobile offline JavaScript client SDK Retrieve

  • OData query options should start with $ like URL query parameters
  • $select only retrieves the attribute of the base entity and not of the related entity
  • OData query options should start with $ like URL query parameters
  • $expand only uses navigation property names
  • Only $select can be specified inside $expand
  • Only 5,000 related records can be retrieved—a next link is not provided if one exists

Limitations for mobile offline JavaScript client SDK Retrieve Multiple

  • $select only retrieves the attribute of the base entity and not of the related entity
  • OData query options should start with $ like URL query parameters
  • $expand only uses navigation property names
  • Only $select can be specified inside $expand
  • Only a navigation property where both the participating entities are offline enabled can be used
  • MaxPageSize is optional and should be > 0
  • $filter does not function – these conditional operators are supported (=, !=, < >, <=, >=)
  • Only – AND, OR, NOT – logical operators are supported
  • $filter can be applied on base entity attributes but not on related attributes
  • $expand returns next links for N:1 relationships
  • Next link is JSON formatted and users need to construct the next Retrieve call using the next link
  • $skiptoken, $getOnlyRelatedEntity is for internal use and should not be changed by users
  • $skip is not supported
  • FetchXml only retrieves base entity attributes

Limitations on views in mobile offline

  • Any entity view, which has a date hierarchy-based parameter used as filter criteria, is not available in mobile offline
  • Only system views are supported in mobile offline
  • If a view has attributes from any other offline-disabled entity, data will not be shown in that view in mobile offline

Limitation on mobile offline security

FLS attribute sharing is not supported in offline mode

Tip #1019: Understand decimal precision in Dynamics 365

There are three places in Dynamics 365 that determine the number of decimal digits are displayed on money fields in Dynamics 365. If you find a money field is not behaving as expected, you need to know how these three settings work.

  1. Currency level: On the currency record, set the decimal precision. This will determine the default decimal precision to currency fields in CRM.

2. System Settings: In Settings>>Administration>>System Settings, there is a setting specific to pricing fields. If you set this to a different value than the currency default, fields like the unit price on quotes, opportunities, orders, and invoices will display the number of digits selected in settings.

3. Field level: when you create or edit the configuration of a money field, you can choose the currency default setting (the value selected in #1) or a different precision value.

 

Tip #1018: Automatically create Dynamics 365 records from Social Engagement

This tip comes from Amy Pritts. Send your tips to jar@crmtipoftheday.com.

One of the really cool features of Microsoft Social Engagement is the ability to automatically create records in CRM from social posts. However, you should be aware that there are several steps to make this work.

  • To automatically create D365 records from MSE posts, users must set auto create rules both in Social Engagement AND configure record create rules in D365. Simply setting MSE auto create rules for specific entities like Cases to active does not automatically create a Case, it only automatically creates a Social Activity in D365.
  • This seems crazy to me—why would you have to set up specific entities for auto record create in MSE, then? But that’s when I read this caveat in the documentation:

So you have to set up this…

…AND this

Tip #1017: Protect your cell number

Microsoft’s strong focus on security means sometimes they get false positives for people signing up for trials and misdiagnose them as bots or service abusers. If you provision multiple Dynamics 365 trials, chances are you found yourself in this situation more than once. Other scenario where you wouldn’t want to use your number if you have concerns about your privacy when submitting the number for MFA (multi-factor authentication).

Twilio, the voice and messaging service provider (and we have no affiliation with it), has a very extensive toolkit that allows to use a pre-registered number for MFA while still receiving messages on your phone.

  1. Create new Twilio account if you don’t have one.
  2. Register new phone number with messaging capabilities ($1/month for US/Canada number).
  3. Now can use TwiML Bins to setup message forwarding. Simply create a new Bin in your Twilio account
    TwiML Bins
    TwilML forwarding bin
    and save the following code to it:

    <Response>
       <Message to="+13655550123">{{Body}}</Message>
    </Response>
    

    (Obviously, use your cell number to forward to!)

  4. Head to your Active Numbers page, set your Messaging URL to configure with “Webhooks/Twiml,” and select your TwiML Bin from the available drop-down.
    Incoming number configuration
  5. You’re all set!

I do not believe you’re not circumventing or breaking anything as far as MFA is concerned because its purpose is to prove that you have something that others don’t. Could be a phone, could be just a phone number to receive messages to.

Tip #1016: App Designer and disabled sitemap subareas in Dynamics 365

If you “comment out” subareas in the Dynamics 365 sitemap or disable them with the XRM Toolbox sitemap editor, you should be aware that if you edit the sitemap with the Dynamics 365 App Designer, the disabled subareas will be removed from the sitemap.

Why is this a big deal?

The reason this matters is because it is fairly common to comment out standard sitemap links that you don’t want to roll out yet. Then when you need these features, enable them. Let’s say that you have Field Service installed in your environment, but you aren’t ready to use it. If you delete these links from the sitemap, it can be cumbersome to add them all back later. If you disable the field service group links, you can easily re-enable them when you want to add them to the sitemap. But if you edit the standard CRM custom app sitemap with the App Designer sitemap designer, these disabled sitemap areas will be removed.

Recommendation

Based on this behavior, I recommend that you don’t use the App Designer sitemap editor to edit the default Dynamics 365 sitemap. Only use it to create and edit sitemaps for new app modules–for the default CRM sitemap, use the XRM toolbox if you want to disable sitemap subarea links.

 

Tip #1015: Remove mandatory and locked fields

Tip 1006: “Remove the stuff you don’t need. Doing tickets for internal helpdesk and don’t need entitlements? Turn it off and remove it from the form.”. Easy for Joel to say.

Dynamics 365 has a lot of baggage, both good and bad – let’s see what happens when I create a new Case form. We immediately receive a bunch of fields that are declared to be super important and therefore are locked. Let’s say I don’t case about First Response By but I cannot remove it.

Mandatory field

Lead has a Topic but I cannot remove it because it’s mandatory. Who said that the Last Name is a must have? That’s not quite how it works in some Eastern cultures. You get the picture. Someone over-analyzed the demand, and decided that 80% of customers would like to describe lead using something called topic and what kind of person has no last name?! And that smug decision from years ago made the life of the remaining 20% incredibly miserable.

There are few ways of dealing with mandatory or locked fields:

  • Change the requirement level, publish, then remove
  • Sometimes it is possible to unlock (for sections), then remove. Careful here, it is possible to break some of the system scripts that way.
  • Group those pesky fields on a single section/tab and hide the container. This is probably the safest technique as it won’t break any scripts if they exist and rely on any of the fields.
  • Switch to header or footer and add the field there, Dynamics 365 will now allow you to remove it from the body. Headers will allow piling up the fields with the warning after 4 that the rest is useless.
  • If form to be used in portals, why not to start with Quick Create. Those start as empty shell allowing some neat scenarios. For example, I like to omit Topic from the lead/contact us web form as it does not mean anything to a site visitor. Dynamics 365 will allow record creation without mandatory fields filled in – it’s a UI restriction only. But when Dynamics user opens the full form later on, they will be forced to specify the topic, i.e. to classify the lead, before saving the record. Win-win.

I’d say, whatever were the reasons for making the field mandatory, most likely they do not apply in all or even majority of scenarios. Let me decide where I want to force data entry upon the user. That’d be my ask for Dynamics 365 version 17.

Tip #1014: How to target delegated administrator in apps

I love when people ask a question but then answer it themselves within couple minutes. Take, for example, Steve “RapidStart” Mordue.

Has anyone else experienced issues with attempting to use an App Designer built app with Delegated Admin Role?

Before I could even type my a non-answer stating that only someone insane would try something like that, came in the reply from Steve himself.

To paraphrase: when building an app with App Designer, targeting specific role, and wanting delegated administators to access the app, make sure to include System Administrator as one of the roles for the forms and dashboards. Otherwise delegated administrators will see neither (but “normal” users with system administrator roles will!)

Tîpp Jäår

Delegated administrators are special. They are kind of administrators but without a specific role assigned. Since you cannot assign a specific role to a delegated administrator, the role of system administrator must be assigned to the app explicitly to apply to delegated admins.