Introduction: In this blog, we will see how to get response from Rest Api through GET call Solution:  Consisting of basic authentication, we will pass username and password in byteStr and for the endpoint we will put it in url in below code. class CFSJSTestRestAPI { public static void main(Args _args) { int find; str url,aosUri,activeDirectoryTenant; str activeDirectoryClientAppId; str activeDirectoryClientAppSecret; str postData,activeDirectoryResource; str aadClientAppSecret,oAuthHeader; str returnValue,jsonString,jsondszstr; System.Net.HttpWebRequest request; System.Net.HttpWebResponse response; System.Byte[] byteArray; System.IO.Stream dataStream; System.IO.StreamReader streamRead; System.IO.StreamWriter streamWrite; System.Net.ServicePoint servicePoint; System.Net.ServicePointManager servicePointmgr; System.Net.HttpVersion version; CLRObject clrObj; Newtonsoft.Json.JsonReader reader; System.Text.Encoding utf8; Counter countCounter; Object obj; Map data; System.Byte[] byteArraynew; System.Net.WebHeaderCollection headers = new System.Net.WebHeaderCollection(); new InteropPermission(InteropKind::ClrInterop).assert(); str byteStr = strfmt(‘%1:%2’, “USERNAME”, “PASSWORD”); headers = new System.Net.WebHeaderCollection(); url = “http://dummy.restapiexample.com/api/v1/employees”; clrObj = System.Net.WebRequest::Create(url); request = clrObj; request.set_Method(“GET”); request.set_KeepAlive(true); request.set_ContentType(“application/json”); utf8 = System.Text.Encoding::get_UTF8(); byteArraynew = utf8.GetBytes(byteStr); byteStr = System.Convert::ToBase64String(byteArraynew); headers.Add(“Authorization”, ‘Basic ‘ + byteStr); request.set_Headers(headers); servicePoint = request.get_ServicePoint(); System.Net.ServicePointManager::set_Expect100Continue(false); System.Net.ServicePointManager::set_SecurityProtocol(System.Net.SecurityProtocolType::Tls12); response = request.GetResponse(); dataStream = response.GetResponseStream(); streamRead = new System.IO.StreamReader(dataStream); jsonString = streamRead.ReadToEnd(); info(strFmt(“RESPONSE: %1”,jsonString)); dataStream.Close(); response.Close(); } } Thanks for reading !!!

Instead of viewing dashboard and report on Power BI Web Service, we can directly view it in CRM. We need to publish the Power BI dashboard to our CRM Environment. This Blog will guide you through it can be done.

Problem Statement: Data Cleansing is always considered as a tedious task. When we have a look at our CRM systems we might find data full of duplicates, test records or blank records. A well defined approach comes in handy to systematically clean up your data. Below is the approach to clean Account data in dynamics CRM. Approach: We need to follow the below steps for cleansing the data. Step 1: Segregate the data Download the accounts data and segregate it in below sheets. Blanks Test Records Duplicates Step 2: Deactivate the test and blank records. These records are not of any use and so the right thing to do is deactivate this records. Step 3: Analyze the Duplicates For the duplicates, we will use the OOB Merge Functionality of CRM. Understanding Merge Functionality in CRM: D365 CRM has OOB functionality to merge two records. We can select the records we want to merge and then click on Merge button on the ribbon. Once we click on merge a pop up will ask us to choose the master record. The master record is the one that will remain active in the system which the other record will automatically become inactive. All the child records of this record will be moved to the Master record, also the inactive record will have a notification saying ” Merged with XYZ record”. We need to analyze our data on the below points, so that we choose the right Master record: A) Important Fields – For any records, fields like ID, Address, Name might hold significance and a record that has these fields has greater chances of being the Master record. B) Related Records- If we take an example of Account entity, it has related opportunities, contacts, projects, cases; the account record which has more no of related records can be the master records. With an Advanced Find we can get the count of related records. Analyzing the data on above points will help us decide the correct master record. Step 4: Deactivate/ Merge the records Once analysis is done, we have a better clarity for deciding the records to be merged or deactivated. Conclusion: Clean and precise data makes working with systems fast and easy. The above systematic approach for data clean up proves a boon when we have large amount of data.

Introduction: In this blog, we will learn how to set the position of Data Card in form. Steps: 1.This is the form of Quote Product. Where all the Data Card is placed one after another. 2.We want this card to be beside one another. 3.To achieve this, click on the Data Card and change X and Y property. 4.These are the X and Y of different Data Card. Conclusion: Hope the above Blog helps you to Change the Position of Data Card in Form.

Introduction: In this blog, we will learn how to set multiple search fields in a Lookup Field. Use Case: We have a requirement where there is a Field (Data Field: Lookup) on the form, which should search records according to multiple columns. The Field on the Form is a Combo Box Steps: 1. This is the form of Quote Product. We want to allow searching based on multiple column. 2. To allow searching based on multiple fields, click on the Combo Box. Items property: Set ExistingProduct.Items =  Sort(                                                    Filter(                                                        Filter(                                                               Data Source,                                                               Condition                                                              ),                                                           StartsWith(                                                                 Text, SearchText                                                      ) Or StartsWith( Text, SearchText                                                 )                                       ),                                            ColumnName                                        ) For eg: ExistingProductQPEditForm_2.Items =Sort(                                                             Filter(                                                                     Filter(                                                                                 [@Products],                                                                                 Status = ‘Status (Products)’.Active                                                                              ),                                                                    StartsWith(                                                                                ‘Product Code’,                                                                                ExistingProductQPEditForm_2.SearchText                                                                              ) Or StartsWith(                                                                              Name,                                                                              ExistingProductQPEditForm_2.SearchText                                                                               )                                                                       ),                                                                      Name                                                                 ) SearchFields property: Set ExistingProduct.SearchFields =  { “ColumnName”, “ColumnName”} For eg: ExistingProductQPEditForm_2.SearchFields = {“cf_productcode”, “name”} Conclusion: Hope the above Blog helps you to search based on multiple columns for the Lookup field.

Dynamics 365 portal helps you to provide additional support to your customers, partners, employees, and others. It helps you to stay connected and provide the necessary assistance. The best part about the whole thing is that you can get the portal if you have an active Dynamics 365  subscription. You need to follow simple steps to active the demo portal. Here are the steps that you need to follow if you want to activate the demo version.  Step # 1: Navigate and find the Dynamics 365 Administration Center. From the Office 365 home (open link: https://portal.office.com/), you need to open admin centre. Step # 2: After opening it, you need to click the applications, and then look out for Portal Add-On. Step # 3: Here you need to click ‘Manage’ and then input the following parameters Name — This names should help you to identify the portal. No need not worry much as you can change the information as and when required.  Url for the Portal (You can change this information as well later.) Select or choose the CRM instance Pick a Language Select the Administrator Pick the Audience Partners — Though they are not your employees, they will need some sort of interaction with the CRM to close deals or in delivering the services 2. Employees — You can provide the necessary support to your employees by tailoring the portal by using features such as Employee Self-Service 3. Customers —  Since they are external parties, they can benefit through your portals such as community building or customer service Pick the Portal Template  Community Partner Employee Self-Help Customer Self-Service Custom Portal Step # 4: Wait for some time – now this takes at least 20 minutes to a few hours to work. Click on Solutions Link under Instance in Admin Center under Dynamics 365 to check the status. It may show the status as ‘installing,’ if the download did not complete. In a few minutes, you will have the demo Dynamic 365 Portal working. In Conclusion Always think from the angle of your customers, partners, and employees when creating the portal. It should make their life easy. What kind of support can you provide them? This question should haunt you when creating the portal.

Introduction: In this blog, we will see how we can get list of users who has assigned a specific security role   Solution:  UserInfo userInfo; SecurityRole securityRole; SecurityUserRole securityUserRole; while select networkAlias from userInfo where userInfo.networkAlias exists join securityUserRole where securityUserRole.User == userInfo.id exists join securityRole where securityRole.RecId == securityUserRole.SecurityRole && securityRole.Name == ‘Sales manager(NameOfTheSecurityRole)’ { info(userInfo.networkAlias); } Thanks for reading !!!

The best part about Dynamics 365 is that you can now launch portals related to customer, support or the prospect. Now, 100 per cent of these things including maintenance and integration can be controlled using Dynamics 365. The Dynamics 365 portal allows the audience to collaborate and communicate via an online location.  It also permits people to get the necessary support pertaining to issues, how-to guides, and search knowledge guides to name a few. Now, the information that the audience is going to get depends on the category they belong to such as customers, internal team members or the business partners to name a few categories, Thus people can learn a lot about the products and services that are available. You do not need any additional software, hardware, licenses or certificates to make this work.  If you already have a subscription for Dynamics 365 Enterprise, you have access to at least Dynamics 365 portal. Using it, you can differentiate yourself from others or more specifically your competitors.  Do I Need a Dynamics 365 Portal If I Have a Website If you already have a website, that’s wonderful, Dynamics 365 portal is not going to supplant it anyways. Just in case, if you are thinking that it is going to replace it. No doubt, your company’s website is a lead generating machine. But, it helps you in extending your web presence from a homepage and a few service pages to a territory that allows people to engage and communicate actively. Here are the benefits that you are going to enjoy when you properly leverage a portal which comes with pre-packaged templates. Customer Engagement Customers that are going to engage are going to become repeat customers. Those who become repeat customers are the ones who will soon turn to advocates to spread the good news about your products and services. For example, a community portal will encourage prospects and customers to share and discuss your products online. Plan to field questions on these portals so that people can stay engaged.  Encourage questions related to your product on this portal and respond to these questions publicly so that people can trust your brand. Apart from these things, you can host blogs on it so that people visiting the portal can enhance their knowledge about the products that you offer.  Customer Self Help Customer Self Help portals are very beneficial to you if you are already using a CRM. it provides the necessary support to your clients so that your frontline can relax a bit. Before the customer submits his case to you, he can give all the details pertaining to the product that they did buy. On top of it, knowledge-based articles will help the customers to solve most of the minor problems without even registering their complaint. Now, this is the best way to reduce the number of cases from being reported.  Engage Your Partners In case, you want to quickly scale up your business, you need partners such as reseller, distributor, and supplier to assist you with this task. Using the Partner Portal, you can trace the sales channel data. It is just like how you would get information from your sales staff. You can also use it to empower your partners and make quick and better decisions to move your business.  Employee Engagement The employee portal will work similarly to the intranet that you use to connect your staff with others. You can permit them access to certain CRM features that are at for specific groups. In a similar manner of how customer service portal can be used to tackle issues related to customers, this portal can focus on raising tickets and solving issues that customers are facing.  Framework for Custom Portal  If you are one that thinks out of the box, this framework is quite beneficial. You can customize the portal as per your vision and plan. For example, if you are planning to use it to manage a franchise, you can create one for franchise portal. Or you can use it to manage other things such as independent agents, professional relationships, investments and so forth.

Suppose, you want to show a loading/waiting screen to let people know there’s some heavy processing going on in the back-end and they shouldn’t navigate away to do anything else with the record, you can use loading screen by using showProgressIndicator() and closeProgressIndicatory() methods. Xrm.Utility methods There are 2 methods are documented in the Xrm.Utility of Microsoft Docs that you can use to achieve this. Microsoft reference here. In this scenario, let’s say you want to show the Loading page while your Action is being performed by the JavaScript code. You can place the Xrm.Utility.showProgressIndicator(message); before you begin your code to invoke an action and place Xrm.Utility.closeProgressIndicator(); in your success and failure messages. Execution Whenever your JS code will call the action, the progress message will be displayed on the screen as below  – In Classic UI   In Unified Interface –   And once the process is complete, the Xrm.Utility.closeProgressIndicator will remove the message as below and bring back the form you were working on – Side Note: If you are using action calling from JS using invokeProcessAction, as of the day of this post – This doesn’t work well and results in action not supported error on the UCI – invokeProcessAction does not work in UCI   Hope this helps!

Now table browser becomes much easier for Microsoft Dynamics 365 Finance and Operations. Here you go with Google Chrome Extension – Table browser caller for D365FO. It’s very easy to install and use it. After installing the extension to the browser, it appears on the top bar and looks like While clicking on the extension, You can find the tab named with config where you need to put the URL of the respective environment and save it. Once config is setup, you need to go to the main tab that is Table Browser Caller as shown in above figure where you would setup mainly:  Search for table name: name of the table Company Id: name of the legal entity  After that, you need to find the table in the search box and just press the Enter key. And you will be redirected to the table in the new tab.  In addition, Table browser has also few other features like Browse all table lists  Browse all data entities   1. For getting the list of tables you need to click on Table list: Result as,  2. For getting the list of data entities you need to click on Data entities:  Result as,