How to Use the Import Template to Determine Fields When Customizing Entities in Microsoft Dynamics 365

When you customize entities in Microsoft Dynamics 365, you want to be extremely thorough in determining which fields you want an entity to have, so that when you import data, you import all of the necessary data, and don’t have to go back and make lots of changes later. Updating fields and forms in one clean sweep sounds tricky, but with the right approach, it can be quick and painless. Let’s go over one aspect of that approach that’s going to get you going on the right track.

Each entity includes a data import template that you can download. Not only can you download it, however, you can also edit it. The reason this is so useful is that the template for each entity includes a column for every single field within that entity as it comes out-of-the-box, which, essentially, provides you with a simple list of the fields the entity contains. What you can do with this is download the import template, review the fields it contains in comparison to the fields you need it to contain, and then edit the template, removing the fields you don’t need and adding the ones you do.

Remember, though, after editing the template, you need to actually go back into Dynamics 365 and customize the fields and forms for the entity to match the ones you outlined in the template. We have a bunch of easy-to-follow videos available for free in our Success Portal, including this one that will teach you how to do basic customizations, including customizing fields and forms; if you don’t have an account, get a free account just by setting xRM as your Partner of Record.

Let’s walk through the steps for downloading, reviewing, and updating the import template now.

First, log in to Dynamics 365 and click the down arrow to the right of the current app name, then choose the desired app. Within that app’s menu, click the name of the desired entity to open. Note: If you want to customize the entity name, check out this video and blog post for a simple how-to.


Within the desired entity, click the down arrow to the right of Import Data, and choose Download Template for Import from the dropdown list.


Click the file name to open it in Excel after it downloads (where the file appears will vary based on your browser; if you’re using Google Chrome, the file will be available to click in the bottom left corner of your browser window after it downloads).

Click Enable Editing along the top of the screen.


If you scroll to the right within the spreadsheet, you’ll see that there are quite a few columns. Each of these columns represents a field within the entity. You may find it useful, at this point, to open up a similar record within your old system, or be viewing your exported data in some way when customizing the template, to ensure you think of all necessary fields.

Go through the template, column by column, and determine if each field shown is relevant. As you go, make note of which fields should be removed from the template (and, thus, the entity), and which fields should be added.


Once you have created a comprehensive list, go through and use the list to make the necessary changes to the template, deleting and adding columns as needed.


Finally, when you’ve updated all desired fields, click File, choose Save As, and save the template to your computer.


Remember, before you import the data, you need to customize the fields and forms within the entity itself to match the fields you just determined the entity should contain. Use this template as you make these customizations to ensure you add and remove the desired fields.

After updating the entity’s fields and forms, check out this video for step-by-step instructions on how to upload the completed template back into Microsoft Dynamics 365.

Visit to see our newest five videos, with new videos added weekly, and check out to learn about our variety of excellent Dynamics 365 and CRM training and customization options for all budgets.









Read More

How to Customize an Entity Name in Microsoft Dynamics 365


One of the great things about Microsoft Dynamics 365 is that nearly everything can be customized to meet the needs of your organization, including entity names. For example, if you use the term “prospect,” not “lead,” you can easily change the Leads entity to Prospects to avoid confusion.


First, note that not all entities can be customized. All custom entities you create yourself can be edited, but some system entities and managed custom entities are not customizable.

Let’s get started.

Click the down arrow to the right of the current app name, then choose the Settings tile and click Customizations within the Customization column.

Click Customize the System.


Click the white triangle to the left of Entities along the left side of the screen to expand the menu, then click the name of the desired entity.



You can also get to this screen by simply clicking the ellipses within the menu bar for any entity, then choosing System Views.


Enter desired text for both the Display Name and Plural Name fields, and rephrase the Description field if needed. Click Save.


After saving, find the new entity name in the menu along the left; its menu will have automatically expanded, but you may need to scroll to find it, as the name will have changed.


After changing an entity (or field) name, you’ll need to ensure that you update applicable system messages. These are messages used in interface text and error messages within the system. Click Messages within the menu for the entity along the left side of the screen, and change the text for each message to reflect the new entity display name.


Either double-click the desired message, or click the check mark to the left of the message, then click More Actions and choose Edit.



Replace the old entity name with the new entity name in the Custom Display String section, then click Save and Close.


Back in the Solution window, repeat this process to customize the rest of the messages. Then click Publish All Customizations to activate the changes you just made.


Now, when you click the down arrow to the right of the app name and choose the appropriate app tile, you’ll see that the entity name has been updated based on your changes.


That’s it! Changing an entity name is simple, and only takes a few minutes. Check out for our 5 newest videos; new videos are added weekly! Plus, visit for a free Success Portal account where you can access hundreds of how-to videos on Microsoft Dynamics 365 and Microsoft Dynamics CRM completely free!

xRM is a Microsoft Gold Partner, offering excellent training and customization options to meet every budget. Check out our three basic options for implementing Dynamics 365 and getting your business off to a running start at!



Read More

How to Create a New Email Server Profile in Microsoft Dynamics 365 for Server Side Synchronization

Wouldn’t it be nice to be able to manage email mailboxes and profiles, configure users and queues, and track errors, as well as synchronize appointments, contacts, and tasks right from Microsoft Dynamics 365? With server side synchronization, you can.

Your instance of Dynamics 365 comes with a default Exchange server set up, but if you have another email server, you can make use of server side synchronization by creating a new email server profile for one or more Exchange servers or POP3 servers for incoming email, and one or more SMTP or Exchange servers for outgoing email. If you want to learn how to use server side sync with an Exchange server, check out the Server Side Synchronization in Microsoft Dynamics 365 for Enterprise video on the Success PortalClick here to designate xRM as your Partner of Record to get a free Success Portal account and access to hundreds of instructional videos on Microsoft Dynamics 365).

First, let’s walk through creating a new email server profile. Click the down arrow to the right of the current app name along the top of the screen, then choose the Settings tile. Click Email Configuration within the System section.

Click the down arrow next to New. There are three options here: Exchange Server (Hybrid), Exchange Online, and POP3/SMTP Server. Let’s walk through setting up a POP3/SMTP Server.

Within the General section, name your email server profile something that will help you remember, in case you set up multiple email server profiles. Next, enter text in the Description field, then complete the Incoming and Outgoing Server Location fields. If you don’t know server information, check your account settings, or search online. For example, if your email address ends in, you could search “ email server settings” to find the information to set up that email server profile.

Next, within the Credentials section, choose how to authenticate. For this example, I’ve chosen Credentials Specified by a User or Queue. This means that the email credentials have been entered within the user’s mailbox profile.

Choose the appropriate radio button for whether or not to use the same credential settings for incoming and outgoing connections.

In the Advanced section, check the incoming and outgoing server port information, and change if necessary.

You can choose to complete additional fields, if desired, otherwise simply click Save. If there are any errors, you won’t be able to save.

Now, you’ll see the new email server profile in the email server profiles list.

Make sure to go back into the mailbox and select the new email server profile in the Server Profile field, then click Save, and Test & Enable.

That’s it for setting up a new email server profile in Microsoft Dynamics 365! Remember, you can have totally free access to hundreds of short how-to videos on Microsoft Dynamics 365, just by setting xRM as your Partner of Record. Our 101 page details additional training and customization packages as well; we have something for literally every budget to help you and your company get the most ROI on your instance of Dynamics 365 or CRM, and can even set you up with a free 30-day trial of Dynamics 365, Office 365, and/or Azure!

Read More

How to Add and Remove Sample Data from Microsoft Dynamics 365

Microsoft Dynamics 365, out-of-the-box, comes with sample data installed, to help you get a feel for the product and its functionality, without affecting your actual data.

You probably won’t want this sample data to be there forever, though, since you’ll eventually have your own data to use. At the same time, though, you may, at some point, want the sample data to be there, such as to train new employees on the platform.

Lucky for you, adding sample data back in is just as easy as removing it.

First, check to be sure you have System Administrator privileges; you’ll need them for this. To do this, start by clicking Settings (the gear icon) in the upper right corner of the screen, then selecting Options from the dropdown list.

Scroll down in the window that appears, and click View your user information.


Along the top of the screen, click the down arrow to the right of your name, then choose Security Roles.


If System Administrator is not already shown, click Manage Roles, find it in the list and check the box to select it, and click OK.


Click the Save icon in the bottom right corner of the screen.

Please note that depending on your current roles, you may not have the appropriate privileges to change your role; if this is the case, contact your system administrator.

Close the window, then click OK in the window that remains open.


Now, let’s remove that sample data.

Click the down arrow to the right of the current app name along the top of the screen, then choose the Settings tile and click Data Management within the System column.

On the page that appears, click Sample Data.


Next, click Remove Sample Data in the window that appears, then click Close.

That’s it! You’ve successfully removed sample data. If you ever want to add it back, just follow the same steps, clicking Sample Data, and then clicking Install Sample Data instead of remove. Close the window when finished.

Check out for access to hundreds of free how-to videos on Microsoft Dynamics 365, with new videos coming out weekly!

Read More

How to Add New Contacts Individually to Microsoft Dynamics 365

When you first subscribe to Microsoft Dynamics 365, you’ll probably want to use the contact import feature to save time, since you’ll be importing lots of contacts at once.

After that, though, when you get new contacts, you’ll want to add them right away, so adding individually will make the most sense.

Adding new contacts in Microsoft Dynamics 365 is simple and straightforward; let’s walk through it now.

Click the down arrow to the right of the current app name, and choose the Sales app, if it isn’t already selected. Click Contacts within the Customer column.

Click New.

Enter as much information as possible about the contact. The only required field is Full Name, but it is always recommended to add more information.

If the contact is associated with an existing account, be sure to complete this field as well.

When you get to the address field, enter the address; please note that Microsoft Dynamics 365 may suggest an address based on what you enter. If the suggested address is correct, click to select it, then click Close. Otherwise, close without selecting to keep your original entry.

Click Save & Close when finished.

To edit this contact, click the check mark to the left of the contact name, and click Edit.

That’s it! You’ve successfully added a contact individually. Follow our blog, and visit our website ( for tons of free how-to videos and posts that will help you get the most out of Microsoft Dynamics 365! New videos on our homepage weekly!

Read More

What Microsoft Dynamics 365 Can Do for Your Business

If you haven’t yet tried Microsoft Dynamics 365, you’ve come to the right place. Let’s go over the basics. This cloud-based platform builds and expands upon the features of Microsoft Dynamics CRM 2016 while allowing you to access and upload data anytime, anywhere. It focuses on and unites the things that matter most to your business: people, data, and processes.

Big or small, non- or for-profit, Microsoft Dynamics 365 offers something for every organization Subscriptions are flexible and allow you to purchase the specific apps and access levels that make the most sense for you. If you don’t need the functionality of an app, you don’t have to pay for it. If 90 percent of team members don’t need administrative privileges, the price reflects it, with user licenses available for as little as $8 per month.

Combining customer relationship management (CRM) and enterprise resource planning (ERP) tools, Microsoft Dynamics 365 provides everything from customer-facing portals and  automated email marketing campaigns targeted at specific markets to coordinating across departments and scheduling the appropriate resources based on skill, location, and availability.

Dynamics 365 can aid your customer engagement, employee empowerment, operations optimization, and product transformation efforts, and take your business to the next level.

Check out to download a free 30-day trial of Microsoft Dynamics 365, access hundreds of free instructional videos, and learn about our training and implementation packages.

Read More

How to Customize the Theme in Microsoft Dynamics 365

In Dynamics 365, the theme determines the colors within the platform, the icon in the upper left corner of the screen, and the tooltip that appears when you hover over this icon. In addition, the theme is easy to customize.

Click the down arrow to the right of the current app name along the top of the screen, then click the Settings tile. You may have to use the arrows to scroll over, depending on the number of apps you have.

Click Customizations within the Customization column.

On the page that appears, click Themes.

You’ll see CRM Default Theme in the All Themes view. The easiest way to create a custom theme is to click the check mark to the left of this theme name to select, then click Clone.

Copy of CRM Default Theme will be the name of the cloned theme; click the check mark to the left of this theme name to select, then click Edit.

When the theme opens up, enter desired text to name the new theme, and desired text for the logo tooltip; remember that the tooltip text is what appears when you hover over the logo in the upper left corner of Dynamics 365.

Next, enter the desired hex (HTML) value in the Navigation Bar Color field. This will change the color of the bar along the top of the screen. You can change any or all of the other colors shown on this page as well, in the same way.

Next, you can add a custom logo by clicking the magnifying glass for the Logo field, then selecting a logo from the dropdown list, clicking Look Up More Records, or clicking New.

If you click New, next you’ll need to enter text in the Name field; note that spaces are not recognized since you’re adding a web resource, so use underscores in place of spaces in the name.

Enter text in the Display Name field (spaces are permitted here), and the Description field, if desired.

Click within the Type field, and choose the appropriate file type from the dropdown list. Make sure that your logo file is one of the listed types.

Next, click Browse, and select the logo file from its location on your computer. Click Open.

Click Save, then click Publish All Customizations.

Close the popup window.

Now, after you add a new web resource, you’ll need to click the magnifying glass for the Logo field again, then click Look Up More Records.

In the window that appears, scroll or search to find the resource, then click the check mark to the left of the resource name to select it. The word “new” is added at the beginning of your web resource name, so keep that in mind when searching. Select the resource you just created, then click Add.

When you’re finished customizing, simply click Publish Theme. This will apply the theme to your instance of Dynamics 365 immediately.

At any time, I can change the theme back to the default theme, simply by returning to the Themes, page, clicking the check mark to select it, and clicking Publish Theme.

That’s it! You’ve customized your theme in Microsoft Dynamics 365!


For more videos, blog posts, and information on Microsoft Dynamics 365, visit!

Read More

How to Set Up Global Search in Microsoft Dynamics 365

Global Search is a feature of Microsoft Dynamics 365 that should not be overlooked. It allows you to query multiple entities simultaneously with the magnifying glass icon in the upper right corner of the screen.

While out-of-the-box, Global Search is set up with default settings, customizing the entities and fields it searches to meet your business needs is simple. Let’s detail both parts: selecting entities and selecting fields.

Selecting the Entities for Global Search

Within Dynamics 365, click the down arrow to the right of the current app name, choose the Settings tile, then click Administration within the System column.

On the Administration page, click System Settings. In the window that appears, within the General tab, scroll down to the Set up Search section. Click Select to select the entities for categorized search.

The Selected Entities column shows the entities that Global Search currently pulls results from. As you can see, currently it’s only querying 8 different entities. This is how it will be set up out-of-the-box, but you can actually include up to 10 entities. Be careful, as you can select more than 10 entities in this window, but when you save, you’ll receive an error if there are more than 10 selected. You can do a couple different things in this window.

Here’s a quick rundown:

  • Select an entity by clicking it in the Available Entities section, then clicking Add.
  • Remove a selected entity by clicking it in the Selected Entities section, then clicking Remove.
  • Change the order results are displayed in by clicking a selected entity, then clicking Move Up or Move Down.

Click OK when all desired entities are selected.

Click OK again to close the System Settings window.

Selecting the Fields for Global Search


After setting up the entities to search, you need to update the Quick Find view for the entities you included in Global Search so that the desired fields are being searched within each of the entities.

Click the down arrow to the right of the current app name again, choose the Settings tile, then click Customizations within the Customization column.

Click Customize the System. In the window that appears, click to expand the Entities section, then click the name of one of the entities you selected for Global Search to expand. Within the desired entity, click Views. In the list that appears, find the Quick Find view, click the check mark to the left of the view name, then choose Edit from the More Actions dropdown menu.

In the window that appears, you’ll see a table that shows the columns of information that will display in the Quick Find view for that entity. To the right of the table, you’ll see Add View Columns and Add Find Columns.

Click Add Find columns and check the boxes to select the fields to search on for Global Search. For example, if I add Address 1: City, and Address 1: State, then I can type a city or state into Global Search and return a list of the accounts located there. Click OK when finished.

You’ll notice that the columns shown in the table will not change. This is you’re simply adding fields to search on, not fields to show in the view. If you want to change the Quick Find view, use Add View Columns, then use the arrows to rearrange them.

When you’re finished, click Save & Close.


Now, in order to activate these changes, you must click Publish All Customizations.

That’s it! You’ve selected custom entities and fields to use for Global Search.

For more videos, blog posts, and information on Microsoft Dynamics 365, visit!

Read More

Social Engagement on Microsoft Dynamics 365

Because the name has changed, and the product has evolved, there is some confusion about the details around what is now known as “Social Engagement” and Microsoft Dynamics 365. This article aims to clear up any confusion and to also explain what can be done with this component in the context of Microsoft Dynamics 365.

Background and Setup

Social Engagement (formerly known as Social Listening) provides the ability for users to track and analyze social communications across public networks about specific topics. There is a broad range of social “channels” that can be monitored, such as blogs and social apps. Within these channels are the obvious sources, such as Facebook, Twitter, Instagram, and Pinterest, to name a few. This is accomplished with “Social Profiles”, each of which is a little different to set up, depending on the policies of the social provider. For instance, for Facebook, there are “access tokens” that need to be set up and renewed periodically. For other sources, the setup is a bit simpler. Each profile is created as needed in order to establish a source of information.

Once the sources are identified and configured, data acquisition begins. Because Social Engagement has a limit of 10,000 posts collected per month, there sometimes needs to be adjustment made to the topics to narrow or broaden the search. For this reason, it should be understood that Social Engagement is something that needs to be monitored itself. After some data has begun to be collected, the application provides for a rich set of analysis tools. Figure 1 below shows a typical dashboard:

Figure 1 – Typical Dashboard for Microsoft Social Engagement

Integration with Microsoft Dynamics 365

Social Engagement comes with Microsoft Dynamics 365 Enterprise Plan 1, as well as the Microsoft Dynamics 365 Enterprise Sales and Service apps. However, it is essentially a standalone product that is configured in a separate “tile” in the Office 365 admin portal as shown below.

Note that in the Office 365 Admin center, Dynamics 365 and Social Engagement are managed separately, as each has their own “Admin Center.” However, they can be configured to integrate with each other.  What this specifically means is that data that is automatically captured in Social Engagement can be moved into Microsoft Dynamics 365, both automatically and manually. 

The integration starting point is found in the management section of Social Engagement. In Settings  Connections you will find the ability to connect to both Microsoft Dynamics 365 and even Microsoft Azure Event Hubs, which is used to process massive amounts of data.

Once you have connected your Social Engagement to your instance of Microsoft Dynamics 365, you have the ability to bring that data into your CRM system.


An example of how this integration can work is shown in the figure below, which is a part of Social Engagement called the “Social Center.”  In this instance, I have selected a post in Social Engagement that could be a lead in CRM.  To bring up this window clicked the link as shown and I can now create the lead from the post itself.  Once I click Create a lead with show up in Dynamics 365 for me to interact with in my defined sales process in Dynamics 365.


This is a demonstration of the ability to create a lead from a social post without leaving Social Engagement.
As you can see, by clicking on the small link icon (circled here) it’s also possible to create Cases (service requests) from posts in the same way. It’s also possible to automate this. For instance, it’s possible to configure the integration in a way where certain posts are added automatically as social activities in Dynamics 365, and then create a workflow in Dynamics 365 to convert certain types of social activities to Cases or Leads.  More information as to precisely how to achieve this is found here.

New Features

A few new features have recently introduced as explained below.

Selling Assistant

With this new feature your team can get personalized recommendations to share on their social networks and enable them to increase their social presence, and ultimately generate more leads. As with all parts of Social Engagement, this requires some configuration – particularly “Get Insights” where users will configure groups of topics that will generate insightful recommendations. This is configured in the new “Social Selling” tile in the Social Engagement app.  Once it is configured, the Social Selling Assistant will provide recommendations, such as the one shown below, where it is suggesting that I Share a post.

Social Insights, Relationship Insights and Customer Insights

This is where it might get a little confusing, because “Social Insights” is a borrowed part of what used to be called Inside View and is now called simply Insights.  Same for Relationship Insight sand Customer Insights.  Previously, Inside View provided information streamed into Microsoft Dynamics CRM about a given Company or topic.  This ability has now been applied to Social Engagement and the Selling Assistant, where there is now an “Assistant” section of the activity pane.  The Relationship Assistant will present a “card” which appears as a sort of reminder as shown below, which is reminding me front and center on the first dashboard I see when I log in about an important task. The same is true for the Selling Assistant. For Customer Insights, an Azure subscription is required and additional configuration as well. Shown below are some “cards” presented in Microsoft Dynamics 365 from the Relationship Insight assistant.

The same card appears under the Assistant section in my Activity Pane:


Social Engagement as a standalone product provides a one-stop shop for the collection and intelligent analysis of selected parts of the massive social universe that is available to us.  It is a way to focus and present to you and your staff what you may consider the most important part of the “noise” – the part that matters to your business.
Beyond the use of the standalone product, it becomes especially powerful when the data collected from Social Engagement makes its way into the platform you use for sales and service, such as Microsoft Dynamics 365 Enterprise for Sales and/or Service.
The product continues to evolve, especially with the merging of Insights and Social Engagement, and with the release of various “Assistants” to feed actionable information to the Dynamics 365 user. Properly configured, these improvements can have a real impact on the productivity of your teams.
The fact that Microsoft now offers this as an integral part of Microsoft Dynamics 365 Enterprise at no additional cost provides a compelling reason to take the time to configure this powerful solution and integration. If you have questions beyond what they article provides, or if you need help in configuring this solution,  please feel free to reach out to us for more information.



Read More

Getting Started with Dynamics 365 PowerApps

Today, the business world relies heavily on mobile technology. We don’t just work from cubicles, offices and desktop computers; we work from subways and taxis, coffee shops, and basically anywhere that we are. We have the luxury of being able to tackle nearly any work-related task from our phones.

It’s not unheard of, however, that some business tasks still have to be done on computers. Mobile apps for business tasks have lagged behind. Those apps that do exist have not always been as comprehensive or accessible as desktop solutions.

Microsoft saw this issue and presented a remedy: Microsoft PowerApps, which is part of Microsoft Dynamics 365.

But what is PowerApps? Essentially, it’s a simple way for the average person to create the apps they, specifically, need, while leveraging the rich and diverse data sets that are provided with the Dynamics 365 Business and Enterprise Editions.

Developers and other employees alike can quickly create the apps they need with data they already have, be it on-premises or cloud-based.

PowerApps will appear within the app menu of Office 365. Upon logging in for the first time, users will be met with a couple things. In addition to a popup window explaining, in the simplest of terms, what PowerApps can do, there will be several short videos and images showing the user how to go about getting started. In the bottom left corner of the screen, there is a New app button. Click this button, then choose one of the two options that appear: PowerApps Studio for Windows or PowerApps Studio for web. If you aren’t running Windows 8 or 10, you’ll want to choose the web version.

If you’ve chosen PowerApps for Windows, click Get when the page appears, then click Launch once PowerApps has downloaded. If you’ve chosen the web version, you can skip that step.

Within the New tab, choose to either start with your data, or start with a blank canvas or template. For this example, we’ll start with existing data. Click Phone layout for the desired data connection.

Choose the desired dataset from the list that appears

Choose the desired table, then click Connect

The page that appears will allow you to design the app; you’ll choose what order you want data to appear, whether or not to include images, and more. After designing the app, you can share it with any desired individuals.

Don’t think you’re stuck because you don’t have an app that does what you need; PowerApps makes it not only possible, but easy, to create the apps you need in just a few minutes.

Please feel free to reach out to us if you need help with PowerApps or have additional questions.

Read More