Posts

Showing posts from August, 2021

PORTAL USER LAST LOGIN DATE AND TIME

Image
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

HOW TO ENABLE AUTO COMPLETE CONTROL IN DYNAMICS 365 FORM

Image
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

DYNAMICS 365 IMPORT WIZARD ERROR WHEN UPDATING RECORDS

Image
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!

DYNAMICS 365 HOW TO SET DATE FIELD IN APP FOR OUTLOOK

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://&

DYNAMICS 365 SHOW HIDE TIME PART OF DATETIME IN JAVASCRIPT

Image
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