While working with CDS I was attempting to import data to a newly created entity (“prospects”) from an Excel workbook. I’d tried using the “Get data from Excel” functionality only to be greeted with the following message: “Your import is done. 0 row(s) successfully imported to cr3e2_prospects entiti
Read the full article hereA New Zealand Business Number (NZBN) is a free, globally unique identifier, available to all Kiwi businesses. With an NZBN, it’s faster and easier for businesses to connect and interact, which will save everyone time and money. An NZBN holds all the key information organisations are most often aske
Read the full article herePowerApps can easily be shared with another user from the same organisation. To share your app, sign in to PowerApps. Click on Apps. Select your App from the list and Click Share. Enter user’s name or email address. Check the Co-owner tick box if you would like the user to edit and share the app. Cl
Read the full article herePowerApps can be created using data from an Excel spreadsheet. Users can create their tables in Excel and upload it to OneDrive. In this blog, we will learn – how to create a PowerApp using Data from Excel. Open a worksheet in Excel and insert a table to it. Add some data such as First Name, Last Na
Read the full article hereMicrosoft Dynamics CRM/365 provides functionality to integrate your CRM with your mail system. This allows you to track email messages in CRM and send timely email messages to the people that matter most for your organisation. There are several options available for email integration with Dynamics C
Read the full article hereI have been working on an upgrade from CRM on-premise to CRM online, which requires us to migrate data from the on-premise system into online using the SSIS Toolkit. During the migration, I received the following error: The input value for 'address1_stateorprovince' field (or one of its related fiel
Read the full article hereIn the past I’ve talked about how easy it is to prevent these types of errors in Microsoft Dynamics CRM by turning them off at a system level, rather than leaving individual users to do it. Microsoft Dynamics CRM 2013, and Microsoft Dynamics CRM 2015In Dynamics CRM 2013 and 2015, when you go to Set
Read the full article hereThere is a feature of Dynamics CRM that I have only just learnt about but provides a way to simplify the forms that a user is presented is the ability to hide the form navigation on a record.As you can see from the images below, the difference in the pages is subtle but the overall effect is signifi
Read the full article hereYou may have heard that performing SQL operations on your Microsoft Dynamics CRM databases are dangerous or unsupported. But what does that mean? What is so dangerous about it? Why is it unsupported?To clear the air, I’m talking specifically about anything that will alter data in your system and I’m
Read the full article hereWhen working on a server with multiple instances of CRM you may need to locate the user groups that relate to your CRM deployment. Unfortunately, you will be met with a large list of groups each with a Guid in their name that seems to have come out of nowhere, and doesn’t match the Guids for your gr
Read the full article hereBusiness Process Flows have been around for a while in Dynamics CRM (now Dynamics 365 of course), since 2013 in fact. They are very useful in helping organisations model their processes in CRM and help guide users through stages of the process. However, there are some limitations which are important
Read the full article hereAlong with the rename of Dynamics CRM to Dynamics 365 came new licenses. If you’re on Office 365 with the old Dynamics CRM licenses being assigned to users you will need to re-assign Dynamics 365 licenses to these users at some point. If you have tens of users then manually removing and assigning th
Read the full article hereSales people are expensive people to bring on-board. We tend to know our own worth and are often motivated by winning and being well recompensed for our efforts. We will research a prospective employer and weigh up all aspects of the company including remuneration, sensible target and quota se
Read the full article hereRecently while trying to programmatically migrate Personal Email Templates between CRM organisations I got this error: “An unhandled exception of type 'System.ServiceModel.FaultException`1' occurred in Microsoft.Xrm.Sdk.dll Additional information: An unexpected error occurred.” Event Viewer didn’t g
Read the full article hereWhy would you want to do this? Well if you’re reading this you probably have a good enough reason. My reason was because we needed to retrieve a personal view in a plugin. It needed to be a personal view because certain users should be able to edit the view, and we can’t give users access to customi
Read the full article here