Please refer to my previous blog better understand why the same records are required in two different Organizations or Environments. Click Here Import Phase: Login to Destination Environment in which you want to import the Data with the same GUID. In Destination Environment, Open the Entity View and click on right three dots for import options. Click on the > which is present on the right side of “Import from Excel” Click on the Import from CSV You will get the Screen like shown in below Screen and now you have to select the file and click on Next   You will get the Screen as shown in the below Screenshot. Now, click on the Review mapping. After Clicking on the Review Mapping you must map the column header to fields of Entity. Now, here comes the most important of this blog. Here you have a map the column which has the GUID of the entity to Entity name present in the Destination Environment. Here I have mapped Customer Header (having GUID) to Customer (Entity Name). You can ignore the mapping of “Created On” Date or else you can map it will “Record Created On”.   Click on the Finish Import and see the magic. All the Data will be imported with the same GUID as of source Environment. You can see the imported data in the following screenshot. To check whether the GUID of records present on both the Environment is the same or not. Just export data from both the Environment and match the GUID of each record. Below you can see the GUID of imported and exported records are the same. Following is exported Data from Source Environment. Following is exported Data from Destination Environment.

Why it is required? Let’s discuss the scenario where we will be required to have some records in the Multiple Environment. Let’s say we have workflow or flow which is configured or running with specific records. So, if we move the flow or workflow to another organization or Instance so the same record is not available with the same GUID. To run the flow or workflow we must change the flow or workflow. Now if we have 10 – 20 flow / Workflow like the same, then it will be so much time consuming So, the best solution to have the Same records with the same GUID in multiple instances. Prerequisite: The system must have the same entity and fields present in both the system in which you must transfer records. Because it will through an error while import to destination Environment Solution: Exporting Phase: Login to Source Environment from where you want to export the Data. Open the Entity of which data needs to be migrated. You can see I have an Entity called Customer which is having a few numbers of records present in the system. Now You need to export the Data from the source Environment. Export Data from the advance find or direct from the View. After Exporting the Data from the system, an excel file will be downloaded with the same columns as in the views. Now, open the exported Data file. The following is the screenshot of the file. You can see there will hidden Columns in Excel A, B, and C. Now to Unhide the Hidden Columns, select all Data Or Press Ctrl + A and Go to Format in Home Section > Under the Visibility Section Click on Hide & Unhide > Unhide Columns. Please see the following Screenshot for more reference. Now You can see all the three Columns as (Do Not Modify) Entity Name, (Do Not Modify) Row Checksum & (Do Not Modify) Modified On. You can see the Hidden Column in the screenshot after unhiding. Let’s move forward now, we must delete (Do Not Modify) Row Checksum & (Do Not Modify) Modified on Columns because we are not required those columns while importing to another environment. If we will import with those columns it will through the error while import Operation. Change the Header from (Do not Modify) Entity_name to Entity_name for convenience while mapping during importing and Save as CSV. Now Your File is ready to import in another system. Let’s go towards the importing phase.

This chrome extension allows to easily find the logical names of entities. It also allows Dynamics CRM users to perform advanced actions, that normally require bookmarklets. Steps: Install Chrome Extension Link-https://chrome.google.com/webstore/detail/level-up-for-dynamics-crm/bjnkkhimoaclnddigpphpgkfgeggokam   The other major functionalities provided are: Hope this helps!

Customer service is the most important element in today’s business. If you do not take care of your customers well, they will not stay loyal to your brand or products. Hence, you need to do everything possible to provide them with the best service. Unfortunately, these days a lot of companies are struggling with this thing. Dynamics 365 for Customer Service from Microsoft is the best product as it will help you as a business to focus on the right aspect of the business. It will not only streamline the processes in your company but it will help you to become efficient in addressing issues that are of grave concern to the customers. Installing and using this product is easy. Since there are certain things that are confusing. Here is a blog explaining how to tackle a problem you will face. Problem: Whenever we are assigning the new owner to Lead present in the CRM, the Last Date Modified of the Email Activity gets changed to the current date and time when the new Owner is assigned. Now due to this, all the Old Email Activity with other owner get re-posted to the Activity Timeline of the Lead because email activity by default sort by the Last Date Modified. Now, above the situation is happened due to the 1: N relationship present in the CRM between Leads and Email Entity which has “Parental” Type of Behavior. So, when we assign a new owner then some of the fields get modified. Following is a step where you can find Lead to Email Relationship: Go to Solution and find the Lead Entity Click on Lead Entity and then open 1: N Relationship 3. Now open Lead Email Relationship, it will be same as the following:  Now to Change the Current Behavior of the Relationship So, Email Activity should not be re-posted whenever the new owner is assigned to Lead. Step to change the Relationship Behavior: 1. Change the Type of Behavior to Configurable Cascading under the section of Relation Behavior After changing the behavior, change the Cascade All to Cascade none in Assign field. This will not change the owner of the Email Activity as well as the Last Date Modified of Lead’s old Email Activity when Lead is assigned to new Owner. Following is before and after of the configuration has been changed. If we don’t change Relationship behavior, the following is the scenario 1.1 Lead Email Relationship Configuration 1.2 Before assigning the owner 1.3 After assigning a new Owner If we change Relationship behavior, Parental to Configurable Cascading and Assign (Cascading All) to Assign (Cascading None) 1.1 Lead Email Relationship Configuration 1.2 Before assigning the owner  1.3 After assigning an Owner Hope this helps!

“Run Jobs” – as the name suggests is a process between Retail Channels and Retail essentials through which we transfer data between channels and database. Please Note: Jobs Run at a specified time which may be different for every Retail Scheduler. Be aware of what the time is set for jobs to run automatically.  Running jobs at a specific time requires setting to be done so that we can schedule a specific job to run at specific time. It can be easily done manually. You’ll have to follow the below steps: Step 1: Go to distribution schedule or Channel database in Retail Dynamics 365. If the job doesn’t run from distribution schedule run it through channel database. Step 2: Go to download sessions and make sure your Job is available or in applied state. If it is in available state, go to “Batch Jobs“. Step 3: Now you will have to find the same batch job that you were searching and need to run it at a specified time. Step 4: Here, since the Job is in waiting state, you need to change it’s scheduled date and time to current time. This change must be according to the time at which you want your job needs to be run. The specified time will make your job run immediately.   Step 5: You can check if Job is being applied in “Download sessions” whenever required. Step 6: You can also change how often the job should run from going to Recurrence. Step 7: Only things highlighted in Red boxes should be checked. Hope this helps!!! Thank you! Please feel free to post any doubts you have.

Problem Definition: The sales cycle in my company demands me to create an opportunity every time a CR is requested or there is an additional estimate via a proposal that we ask on the current project from the customer. This needs me to go through the cycle from Opportunity to Quote to Contract. But, in this cycle, I do not want to create another Quote or contract, but update the existing one to add another Quote Line Detail. This is not possible once the Quote is marked a won in PSA. Solution: Following is what can be done to enable the Quote to move it to Draft mode an make it editable. Step 1: Go to the Quote and click on the Flow button in the Ribbon control and click on Create New Flow as shown in the screenshot below. Step 2: Use the Common Data Service Template and click on Continue. In case you see this page and you are not signed in with your account, please sign in and continue. Step 3: On the next screen select the details as shown in the below screenshot. Step 4: Select the Update Record Option from below as shown.   Step 5: Click on Add Dynamic Content link and select Quote field from there as shown below. Step 6: Change the field “Status Value” to Draft and Save the Flow. Step 7: Navigate to the flow and name is as shown below. Step 8: Its time now to test the Flow developed. Navigate to your Quotes and filter out the Won Quotes. Open one Quote and Click on Flow button from the Ribbon control and select the Flow that we wrote as shown below Step 9: Refresh the page and check that the Flow has done its job and the Quote is now in the Draft mode, ready to edit. This blog reflects my personal findings and based solely on my experience of using PSA for the last 3+ years. For those who are looking for a platform that can track and manage the entire procedures of sales and project management, I would highly recommend them to try Microsoft dynamics 365 for project service automation.

Customers are crucial to the success of any business. When you build your business focusing primarily on giving the best experience to your customer, your business is going to bloom. Your profits are going to multiply each year. Dynamics 365 for customer service is one of the best ERP solutions that you can find in the world.  It will help in streamlining the processes in all the departments to make your business customer-friendly and customer biased. When customers know that you value their association, they are going to stay with you for a long time becoming your loyal customers.  People who never used this ERP solution may not know how to find what they want. Here is a topic that you should learn as it will be quite helpful to you in the long run. Data Integration project support two types of executions Manual and auto-refresh i.e. schedule-based refresh. For a manual refresh, we have to select the project and click on run. In this blog, we will learn how to create a schedule to run an Integration project at a specific date and/or time. First, go to Admin Center Go to the Data Integration -> Projects and click on the ellipses of the project to be scheduled and click on Schedule We will get two options a. Run Manually b. Run on specific day and/or time  Now let’s schedule the project, in this example we going to schedule the project every hour starting at 17-Aug-2019 to 30-Aug-2019, and it should run form 12 AM to 2 AM. After scheduling click on save We can schedule the project in another way also, to do this  go to the scheduling after selecting on the Integration project After clicking on the project following window will open and then click on the Scheduling and same scheduling window will appear. In this way we can create schedule-based refresh for the Integration project

These days there are so many companies that are developing software applications to help businesses manage the projects. But, nothing comes close to dynamics 365 project service automation. It is unique and is one software that every business should have if they want to manage projects and help them to become successful. Companies can track as well as manage projects well when they use this particular software.astering this software is essential if you want to use this application efficiently. PowerApps is one service that Microsoft offers, and developers can use it to build apps as per the requirement of the client. As my thoughts build to initiate writing this blog, similar was the feeling when I first thought about exploring Power Apps. The expression was, “What exactly is Power Apps?”. When the world is talking about it, it brings me more curiosity to understand what is so powerful about it. Let’s first commence with understanding what exactly is Power Apps: PowerApps is an initiative by Microsoft that allows developers and nontechnical users to build mobile applications from selectable templates. The objective of PowerApps is to enable business users to build new capabilities via apps, without requiring that they have code expertise. Types of Power Apps: Model driven apps: These types of apps directly publish the entity on the mobile/ tablet. These apps can be used from Microsoft Dynamics 365 App from mobile. They are very easy to make and can be ready within 15mins of time. Canvas apps: These apps are blank canvas given to the developers with a free hand to design the app in the way they want. In this blog we shall focus more on how to make a Canvas app. Follow the steps below to make a PowerApps. Step 1: Login to www.portal.office.com Step 2: Click on PowerApps icon as shown in the image below: This will open a new browser tab where we need to select what kind of app do we need to make. Step 3: Click on Canvas app from blank, which opens a pop up. Please name your app and select whether the app is for Phone or for Tablet as shown below and click on Create button. This opens the Canvas app editor as shown below: To take this blog forward, I will use an app that is created by me and explain a few commands used by me and how was the design done in that app. The app captures the Grievances of people in office. There are 5 screens created by me and they are: list_Grievances Screen: This list all the grievances in the system. 2. frm_GrievanceRecord Screen: This opens a grievance record. 3. Frm_NewGrievance Screen: This screen is used to capture a new grievance. 4. Frm_CameraScreen : This is used to capture the image of the grievance using camera control. 5. SuccessScrn: This is used to display the success on the screen. Technical dive Let’s take a dive in each screen and get into understanding of functionalities developed on each screen: List_grievances: a. New Grievance button: This button will navigate to a frm_NewGrievance Record to capture new grievance from the employee. The code written behind that is:………………………………………………………………………………………………………………Navigate(frm_NewGrievance,ScreenTransition.Fade );   …………………………………………………………………………………………………………………….b. To display the list of Grievance I have inserted a List Screen as shown in the image below: c. To display the list of Grievance, we need to add a Data Source. How to add a data source is shown below: There are approximately more than 250 Data sources to which Power apps can connect. Select the data source you wish to connect. In my case, I will connect to Dynamics 365 Data Source. It will ask you to choose your entity and then you can click on connect. Your Data Source “Grievances” will start appearing in Items drop down of Property Window. Post that we can align the attributes that we need to see on the list view: To Display Employee Full Name, below is the code that I wrote: ………………………………………………………………….. ThisItem.’Employee Full Name’ ………………………………………………………………… To get the department value, which is a lookup to another entity below is the code that was written: …………………………………………………………………. LookUp(Departments,new_departmentid=ThisItem.Department, new_name) …………………………………………………………………. To display the image from the SharePoint Library, below is the code: LookUp(GrievanceLibrary, Title = TitleGrievance.Text, Image)   Where GrievanceLibrary is the Sharepoint Datasource added in Powerapp and Title and image are the fields created in SharePoint.   To open the Grievance record on frm_Grievance Record, write the below code: Navigate(frm_GrievanceRecord,ScreenTransition.Fade,glryGrievances.Selected)   frm_NewGrievanceRecord: To store the new grievance record, we used the Form Screen. On the update button, write the below code: Patch(     Grievances,     Defaults(Grievances),     {         new_employeefullname: DataCardValue3.Text,         new_description: DataCardValue15.Text,         _new_departmentl_value: DataCardValue10.Selected.new_departmentid,         _new_grievancetypel_value: DataCardValue6.Selected.new_grievancetypeid,         new_signature: PenInput4.Image     } ); Patch(     GrievanceLibrary,     Defaults(GrievanceLibrary),     {         Title: DataCardValue3.Text,         Image: First(Collection1).Url     } ); UpdateContext({resettext: !resettext}); UpdateContext({resetcombobox: !resetcombobox}); Navigate(SuccessScrn,ScreenTransition.Fade); frm_CameraScreen Insert a Camera Media Control on the form as shown in the below screen shot. Insert an image control on the form below the Camera Media control. Capture button code: ClearCollect(Collection1, Camera1.Photo) Collection 1 s described above is the SharePoint collection object which needs to be cleared and then referred with the new Photo from the Camera Control, which in our case is Camera1. Confirm button code: Confirm Button will only Navigate it to New Grievance form and the code is ass per below: Navigate(frm_NewGrievance)  To summarise: We learned how to create a Canvas Power app. Different controls that can be used. How to store image on Sharepoint in a Power app. Again I am sharing the code for storing the image on Sharepoint herewith: Patch(     GrievanceLibrary,     Defaults(GrievanceLibrary),     {         Title: DataCardValue3.Text,         Image: First(Collection1).Url     } ); To explain the above code, GrievanceLibrary is the SharePoint site of which Data Source is added. Title: This is a field in the Sharepoint library that will store the name of the Grievance. The data type in Sharepoint for Title is Single line Text Image: This will store … Continue reading First Canvas Power App: Learn Few Easy and Important Commands →

Dynamics 365 for Customer Service is the right ERP software to use if you desire to see the customer service improvement in your company. When businesses provide excellent customer support, clients not only have the best experiences, but they also stay loyal to a business. Of course, there are so many ERP solutions out there in the market. Dynamics 365 solutions are, however, the best in the world as many companies tried and tested this product and love the way it helps them to become a lot more organized. Since Microsoft owns this product, they do a lot of research to enhance this particular product. One problem people do not know how to fix is the infinite loop issue. Here are some fantastic tips to help you to surpass the problem. While using fetch xml to retrieve records more than 5000 records and if you have multiple entities involve in it. There are chances that you will get into an infinite loop even if you have less than 5000 records. Description: We have noticed that after 9.0 if you are using the old method to retrieve more that 5000 records using the fetch xml in the script it is possible that you will get the into infilter loop. This happens due to the internal multiplication of table which gives fist and last records id same in fetch XML. You need to make sure that include the header as shown in the below screen Need to make sure that you have below check condition before calling the fetch next record collection if (data[“@Microsoft.Dynamics.CRM.fetchxmlpagingcookie”] != null && data[“@Microsoft.Dynamics.CRM.morerecords”] != null && data[“@Microsoft.Dynamics.CRM.morerecords”]==true) { It has more than 1 record true only than call the next request Conclusion Hope this helps you to solve your infinite loop issue.

Customer Service is one of the essential segments of any business if they want to become successful. Every single thing about it does matter. Dynamics 365 for customer service is one of the tools that a business can use to improve brand loyalty and also to improvise the value that the companies offer to their clients. Any company that wants to improve in this segment needs to work on this thing. D365 Customer Service will set your company apart from the rest of the firms out there. This software will help you stay ahead of the customer’s expectations and to resolve their concerns a lot faster. Customers can reach out to the company a lot quicker and get resolutions for the problems they are facing at a much faster pace. Microsoft Dynamics 365 CE streamlines the way your employees communicate with customers and enhances their ability to collaborate. Problem Statement Clients implement D365 CE for all departments also need home/landing/default page for each department. This blog will help you to configure default URI for each department in D365 CE implementation for Company. Configuration Steps 1.       Open Dynamics 365 Sales app 2.       Navigate to “My Apps” in Settings group 3.       Open Manage Roles Click on ellipses(…) and pop-up open, click on Manager Role 4.       Setup App URL Enter URL Suffix e.g. SL and automatically URL is generated. 5.       Setup Roles Roles are assigned to URL, Users with specific roles can only access App. 6.       Copy URL and click Save button also share with Users for opening. Conclusion After following above configuration steps, we can share App URL with Sales Department similarly we can configure for Customer Service, Project Service, Field Service or any custom App share with the respective department. Hope this blog helps you to configure Department-wise or based on App for a group of people.