Category Archives: Dynamics 365 CE Online

Datetime zone issue in Liquid – Dynamics 365 Portals

Introduction This article is about the date time format and zone issue in Dynamics 365 Portal. Dynamics 365 CE store date time in UTC format in CRM DB and when you will display date field on Dynamics 365 Portals it will display same date which sometime leads to incorrect date & time. If you are facing same issue this article… Read more »

Fix Duplicate Record Found for Entity error – Dynamics 365 Portals

Introduction This article is about fixing “Duplicate Record Found for Entity error..” in Dynamics 365 Portals. Details Sometime Dynamics 365 CE display confusing error, for example recently one user got following error while assigning a Web Role to user This error seems confusing as it’s saying Duplicate error, but when I looked into this issue, I found this issue was… Read more »

Dynamics 365 CE and Azure Function Part 2

Introduction This is our second article in the Dynamics 365 and Azure series, in first article we discussed basic introduction about azure function and set azure function app. In this article we are going to discuss how we can read CSV file from blob storage and process it to create/update contact record in Dynamics 365. Let’s say we have following… Read more »

Dynamics 365 CE and Azure Function Part 1

Introduction This is our first article in the series, of Dynamics 365 and Azure function integration. We will be discussing how we can import data from CSV file to Dynamics 365 using an Azure function, during these series we will be discussing the following options, 1. Introduction to Azure Function 2. Connecting Azure function to Dynamics 365 3. Setup Server to… Read more »

Executing workflow from command button using Web API

Introduction In our earlier sample, we discussed how to call actions using Web API, today we are going to share sample code to execute workflow from command button using Web API. Requirement Let’s say we got some requirement to validate some logic on click of the command button and need to send email using workflow. Let’s see how we can do that…. Read more »

SystemUserAccessMode is not either of (NonInteractive, SetupUser)

While creating work order record, I got following error: “Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: The user with SystemUserId=2….. in OrganizationContext=5…… is not licensed, and its SystemUserAccessMode is not either of (NonInteractive, SetupUser)……..” First thing I checked if the current user Access Mode is not set to Administrative or non-interactive as the error message was saying, but it was… Read more »

Comparing dates in Dynamics 365 Portals using liquid

Introduction In this article, we are going to discuss how we can compare two dates using liquid in Dynamics 365 portal web template. If you are new to Dynamics 365 portals, Please refer our earlier article for setting up Dynamics 365 trial  and you can refer this KB to provision portal in your trial. Requirement Let’s say we have one customer appointment entity where… Read more »

Access Entity based on N:N relationship for Dynamics 365 Portal

Introduction In this article we are going to discuss how we can configure Dynamics 365 portal Web Roles and entity permission to access entity data based on the system N:N relationship. We are using Dynamics 365 trial and provisioned portal trial. Please refer our earlier article for setting up Dynamics 365 trial if you want to setup a Dynamics 365… Read more »

Query intersect entity and it’s attribute- Sample Code

Introduction When we setup system N:N relationship between two entities an intersect entity is created internally, which is not accessible directly. Let’s say we have N:N relationship between case and workorder entity. And if you will try to see attributes of this entity, you will find following attributes So in case we want to query this entity, we need to… Read more »

Uploading data to Dynamics 365 using Microsoft Flow

Introduction In this article we will discuss how we can create data in Dynamics 365 CE using Microsoft Flow using excel file. Requirement: Let’s say we have requirement to read excel file from one drive for business and create Dynamics 365 CE contacts. We have contact.xlsx file in one drive for business having following fields Solution: We can easily implement… Read more »