How to automatically update currency exchange rates in CRM using Power Automate

In this blog I am going to show how we can update the currency exchange rates in Dynamics CRM periodically using the power automate. The most common issue we face in CRM is the currency conversion since there is no out of the box option available to update the currency available in Dynamics CE. Most of us do it either manually when working with multiple currencies and that takes a lot of effort and even, we don’t have any in-built option in Power Automate to auto-update currencies in CRM. So, here are the steps which you should apply for automatically updating the currency on periodic basis. Step 1: Start with creating the custom connector. This is just to get the latest exchange rates via an API.     Goto : Data-> Custom Connectors-> New Custom Connector    Add Name and URL (          Click on Security and on the next page click on Definition without entering any value for authentication because the API is open, and we don’t need any subscripti

Move to Microsoft Forms Pro from VOC | Create Forms Pro Survey in CRM using MS Flow | Microsoft Flow | D365

As most you know MS has deprecated voice of the customer and June 2020 is the last deadline for all of us to move to Microsoft Forms Pro (or any other 3rd party apps) for getting feedback from customers. So in this blog I am going to whole process which I followed during transition to Forms Pro from VOC. First, a little information about forms pro: Basically, it's very much similar to Voice of customer and provides seamless integration for surveys with MS CRM. We can send surveys to D365 contacts either manually or automatically on change in records within our CRM like on Case resolution or case creation. Similar like VOC, forms pro also saves all records in CRM. Now, the next point is creating a new survey form. So for this go to the site: and sign-in with your MS credentials. Like VOC, you will get almost same survey designer form where you can create multiple question with different data types, you can apply themes

WebAPI Query | Dynamics CRM | Error: Property 'field' on type 'Microsoft.Dynamics.CRM.entity' is not a navigation property or complex property

Recently when I was debugging my code I got this error : Property 'field' on type 'Microsoft.Dynamics.CRM.entity' is not a navigation property or complex property'. Basically in my WebAPI query I was requesting data from Survey entity and also I was trying to read related entity(in my case it is Incident) data values so that I don't have to do another query. I have this 'Survey' entity and which has a lookup field called 'Regarding' (Schema name: regardingobjectid) which is a and can be related to any system defined entity. Simply when I used regardingobjectid in my query I got error : "Could not find a property named 'regardingobjectid' on type 'Microsoft.Dynamics.CRM.msdyn_surveyinvite'." I removed this '$select' part from the url and directly run that and found that there is field called '_regardingobjectid_value' which returned guid of that 'Regarding' lookup field. Now the new erro

How to query paging using Dynamics 365 WebAPI (More than 5000 records)?

Recently I was working on a requirement where I had to build a WinForm application to get the records from multiple entity which looks like a very simple requirement and it was indeed but the problem came when I completed my code using WebAPI method and server-to-server authentication. The problem was the size of records which was more than 5000 and I had no idea how to query paging in this scenario. Paging using the webAPI is a bit different to using the SOAP endpoint, so I've described the structure of request that should be used and how to navigate to the next page from the response. * To execute the request for the next batch of records after maxbatchsize of request is reached, simply open a new request to the URI specified in the @odata.nextLink attribute using the same header as the initial request. Here is the example of HTTP response which you'll get. Please look at the end carefully, we got the next page link in the @odata.nextLink attribute because the respons

Promise in JavaScript | Async Calls | Dynamics CRM

I am going to explain how we can use promise in our CRM script with little explanation about promise. Let's suppose you have multiple functions in your script and one of those function (name funA) does take time to execute and other function (name funB) in script depends on the result of that function (funA) result. A 'promise' is a special JavaScript object that links both these functions; funA & funB together. Promise makes the result available to funB when it is ready from functionA. Basic syntax of a promise is: var promise = new Promise( function (resolve, reject) {              //Producing code              let  condition =  1 ;              if  (condition <  1 )                 resolve();              else                 reject();         }); The function passed to new Promise is called the executor. When new Promise is created, it runs automatically. It contains the producing code, that should eventually produce a result.

Unified Service Desk generic error: Creating An Instance with CLSID from the IClassFactory failed

Sometime user get this error when they open Unified Service Desk: Creating an instance of the COM component with CLSID {0002DF01-0000-0000-C000-000000000046} from the IClassFactory failed due to the following error: 8150002e Exception frm HRESULT: 0x8150002E For resolving this issue simply do the following steps and then re-start your USD and that's it, issue solved :) 1. Open Task Manager 2. Goto Details tab 3. Look for all iexplore.exe 4. Right click on each of them and select 'End process Tree'

How to establish Server-to-Server Authentication | Dynamics D365 | Azure | CRM Web API

In this blog, I'll explain all steps that how to establish server-to-server authentication using Application User and Azure active directory. I have a very basic requirement to fetch case guid from incident entity based on ticket number from CRM using S2S authentication i.e without using any CRM user credential. Follow the below steps: Step 1:First of all we need to create an App in the Azure application directory : Goto  and enter your credentials. Goto Active Directory > App Registrations > New Registrations Provide all basic details as in screenshots below and click on Register Once the application is created, you will get an application ID (marked with red arrow in image below), copy and paste somewhere; this is your client ID Next step is to create Client Secret for which click on 'Certificates and Secrets' (or Keys for old Azure UI) as shown in image below. This key is used to establish connect
go to top image