Dynamics 365 Education and Knowledge

Many clients wish to have a look on how their systems are performing and especially the ones facing the end users, therefore, they sometimes need to track the peak time when the users are connected to their systems to do some statistics, analysis, and take actions based on the data collected. The same applies to the PowerApps portal which is our topic in this post, where I will show you how to get the user last login date to the portal . As you know, users that connect to the portal, are saved in the Dynamics 365 as contact records, and to save the last login date to the portal, a new date/time field named Last Successful Login will be created in the contact entity during the portal provisioning. In order to fill this field by the appropriate date time when a portal user has logged in, a setting should be set and enabled Open the portal settings entity ...

The data existing in D365 application represents the most important thing to any customer, and all of us are helping clients to better use and improve the data entry to be more consistent and cleaner as much as possible. Most fields allow users to enter specific type/format of data, for example, an option set field will provide a list of items to select between them, the lookup field will provide data from another entity, the number field will limit the data to be numeric.... However, the main concern will be on the text fields where the users can enter any info and save it. Here, the data might start to become inconsistent and can lead to erroneous outcome in some scenarios. Therefore, in order to maintain the consistency of data entered in the text fields especially for the ones that present sensitive info to the business, you can add the Auto-complete control where it will start giving suggestions and ...

In this quick post, I will talk about an issue you might face during import wizard of a csv file in order to update some data in Dynamics 365. PROBLEM The following error message appears during import wizard of the csv file A record with these values already exists. A duplicate record cannot be created. select one or more unique values and try again. REASON After exporting the Excel file, it has been saved as a csv file which has been selected for the import to update the records SOLUTION You need to make the needed changes on the exported Excel file and import it without changing its type to csv. It will update the needed records with the new data Hope This Helps!

PROBLEM You might have faced the following script error when setting a Date field in CRM App for Outlook in JavaScript using the method formContext.getAttribute("<fieldName>").setValue(Date.now()); Error: Value should be of type: DateTime at h (https://<crmurl>/uclient/scripts/app.js?v=1.3.163-201103-224104:12:164) at b (https://<crmurl>/uclient/scripts/app.js?v=1.3.163-201103-224104:12:327) at t.prototype.setValue (https://<crmurl>/uclient/scripts/0.js?v =1.3.163-201103-224104:209:21956) at setDateReceptionField (Unknown script code:561:13) at e.prototype.executeFunction (https://<crmurl>/uclient/scripts/app.js?v=1.3.163-201103-224104:1659:50881) at e.prototype.execute (https://<crmurl>/uclient/scripts/app.js?v =1.3.163-201103-224104:1659:50686) at e.prototype._executeIndividualEvent (https://...

Have you faced a situation where you wanted to conditionally show/hide the time part of a date-time field on a form? After upgrading from D365 V8.2 to D365 V9 (9.0.16.7) on-premises, there is abnormal white space around the ribbon buttons . This behavior was everywhere whether in the views, forms or other areas. You can do it using the ClientAPI JavaScript function formContext.getControl("<datetimefieldname>").setShowTime(true); to show the time part Or formContext.getControl("<datetimefieldname>").setShowTime(false); to hide the time part Bonus Tips: In addition to setting the visibility of the time part, you can get whether the time part is ...

Some of you know that it is possible to show/hide the header and footer of the form using Client API. Sometimes, you need to have more space to show additional data on the form or the client simply request to hide some parts of the header. Here comes the utility of hiding the header or footer elements of the form. The header is divided into three parts : Command bar , Body , and Tab navigator as per the following. In order to dynamically control the visibility of each part, you can call the following functions: Header command bar visibility Hide : formContext.ui.headerSection.setCommandBarVisible(false); Show : formContext.ui.headerSection.setCommandBarVisible(true); Header body visibility ...

In other posts, we saw how to refresh a subgrid and how to filter a subgrid in JavaScript. In this post, we will see how to change the view selected for the subgrid in JavaScript . You can use this each time you need to display different columns in a sub grid based on a field value on the form because showing/hiding a column in a sub grid is not possible. Go to the entity form and open the form or field properties where you want to call the JavaScript function Under the Events tab, add the appropriate event handler and call the function that will change the subgrid view Save and Publish the form As outlined in the below JavaScript function, use the setCurrentView function to change the subgrid view . func...

In this previous post , we saw how to register and call event handlers related to the BPF . In this post, we will see how to change the Business Process Flow (BPF) stage in JavaScript that will be directly reflected in the UI. In order to achieve this, you have to use the functions formContext.data.process.moveNext() and formContext.data.process.movePrevious() so you can move the stage back and forth in the active BPF of the form. Go to the entity form and open the form or field properties where you want to call the JavaScript function Under the Events tab, add the appropriate event handler and call the function that will change the BPF stage Save and Publish the form As outlined in the below JavaScript function, use the moveNext or movePrevious functions ...

In this quick post, I will talk about an issue you might face if you want to import data using data import wizard upon selecting the file you want to import on Dynamics 365 V9 on premises. Note: This error does not appear on the online version The Problem The following error message appears when you select the file you want to import The records were not updated because the following Microsoft Dynamics CRM fields were not found : <column name> The Reason Two fields in the entity you are trying to import the records to, have the same display name The Solution Change the display name of one of the fields in order to fix this problem and run the import wizard again Hope This Helps!

Usually, installing a cumulative update for Dynamics 365 on premises is easy and does not require deep expertise in order to achieve it. However, you might face errors as happened the last day with one of my colleagues. PROBLEM He informed me that he is not able to install the cumulative update (9.0.23.7) of D365 on premises on one organization. While, he was able to do it on another and both organizations are on the same development server. Therefore, I got the error log and the trace is the following (kept only the interesting part): System.Exception: Error.ActionFailed Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction ---> Microsoft.Crm.CrmException: Error in Action: Microsoft.Crm.SE.DatabaseActions.dll: Execute on attempt 3. System.Reflection.TargetInvocationException : An exception was thrown by the target of a call. ---> Microsoft.Crm.CrmExcepti...

In other posts, we saw how to change the selected view of a subgrid and how to refresh a subgrid in JavaScript. In this post, I will talk about how to filter a subgrid using JavaScript in Dynamics 365 and display the needed records . For the sake of this post, I will take the example of an account record and its related cases that are displayed in a sub-grid component. In the account record, a field called Case Type that contains three options (Problem, Question, Request) Based on the case type selected, the sub-grid should be filtered and show the appropriate cases records To apply a filter on the subgrid, a fetchXml needs to be injected in the sub-grid and filtered based on the case type selected Therefore, go to the Case for...

In other posts, we saw how to change the selected view of a subgrid and how to filter subgrid in JavaScript. In this post, we will see how to refresh a subgrid in JavaScript in order to show the latest records related to a parent record upon an action on the form or clicking a ribbon button. For the sake of this post, I will take the example of the cases subgrid related to an account record. Let's take the scenario, where an action is done on the client side that adds a case related to the account record. Therefore, the sub-grid should be automatically refreshed to reflect the updated list of cases. In order to do this, a JavaScript function should call the refresh() in order to refresh the subgrid and display the expected result. function refreshSubGrid(context) { var formContext = context.getFormContext(); ...

As you know, System views are available to all users, while, the Personal views are available to only the users who created them and the users these views are shared with. Both of these are called Predefined queries and can be retrieved and executed using WebAPI. System views are the system defined views and are contained in the entity named SavedQuery Personal views are the personal views and are contained in the entity named UserQuery You can use the following WebAPI calls to execute the predefined queries: System views : https://<OrgUrl>/api/data/v9.0/account?savedQuery=<SystemViewId> Personal views : https://<OrgUrl>/api/data/v9.0/account?userQuery=<PersonalViewId> To get the...

In this quick post, I will talk about a limitation you might face when working in D365 CE which is exceeding the maximum number of link entities in a query . The exception message that you will receive is the following: Error : Number of link entities in query exceeded maximum limit. where the maximum number of link entities is 10. You get this error in different scenarios In a view when you add fields of more than 10 related entities because they are reflected as link entities with outer join to the main entity <OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">......... <Message> Invalid FetchXml on SavedQuery.Update. </Message>......... ...

Let's take the scenario, where a user has to choose Department 1, Department 2 and Department 3 on a form for escalation purpose. Each department has its own enabled and required fields where a user in the department has to fill before saving. In this situation, when you have multiple attributes on the form that operate similarly, and if needed, as a best practice, they should fire the same JavaScript function. In order to achieve this, you need to dynamically get the attribute name of the field being changed ( source of the event ) in the function to know which dependent fields should be enabled and set as required. Here comes the role of the getEventSource() function by calling it as follows formContext.getEventSource().getName(); that will retrieve the schema name of the field being changed, and this way, you can achieve some work based on it as per the below function. ...