Dynamics365 @nishantrana - Tumblr Blog

SQL4CDS UTC Mode: Converting Advanced Find Date Filters to UTC Boundaries– A Quick Reference (Dataverse / Dynamics 365)

While validating record counts for a Work Orders view in Dynamics 365 Field Service, we ran into the same underlying issue covered in an earlier post – Why SQL4CDS Record Counts May Not Match Advanced Find for Date Filters. This time, instead of just explaining the root cause again, we put together a quick reference table for converting an Advanced Find date range into the correct SQL4CDS UTC…

#Advanced Find #CRM #Dataverse #DateTime #Microsoft Dynamics 365 #TimeZone

Hide Expired Sessions in Event Registration Form using JavaScript (Dynamics 365 Customer Insights – Journeys)

One of our recent requirements was to ensure that users could no longer register for event sessions once the session had already ended. The goal was to improve the user experience by hiding expired sessions from the Event Registration form, rather than displaying sessions that were no longer available. Once a session’s end date and time had passed, it should be hidden from the UI so that new…

#Dynamics 365 #Dynamics 365 Customer Insights - Journey #events #Marketing #Microsoft Dynamics 365 #session #session registration

When Entity.Id Is Guid.Empty with QueryExpression.Distinct = True (Dataverse)

While optimising the performance of a Dataverse plugin, we noticed a QueryExpression using ColumnSet(true). The business logic only required a few attributes, so replacing ColumnSet(true) with a minimal ColumnSet looked like an easy performance improvement. The query also used Distinct = true, which we left unchanged because it had always been there and everything was working correctly. The…

#Dataverse #Distinct #Dynamics 365 #Microsoft Dynamics 365

Implementing Cloudflare Turnstile for Dynamics 365 Customer Insights – Journeys Real-Time Marketing Forms

Check the previous posts for more details – https://nishantrana.me/2026/07/22/custom-form-submission-validation-in-dynamics-365-customer-insights-journeys-inside-the-validation-pipeline-and-the-ms_captcha_solution-error/ https://nishantrana.me/2026/07/21/implementing-server-side-honeypot-validation-for-dynamics-365-customer-insights-journeys-forms/ In one of our recent projects, we implemented…

#Captcha #Cloudflare #CRM #Dynamics 365 #Dynamics 365 Customer Insights - Journey #Dynamics 365 Customer Insights Journey #Dynamics 365 Marketing #Marketing #Microsoft Dynamics 365 #Microsoft Dynamics CRM

Custom Form Submission Validation in Dynamics 365 Customer Insights - Journeys: Inside the Validation Pipeline and the "ms_captcha_solution" Error

While implementing custom form submission validation (server side validation) for Dynamics 365 Customer Insights – Journeys Real-Time Marketing forms, we came across the following error, “Required params cannot be null or empty –ms_captcha_solutionms_captcha_typems_captcha_flow_id” after enabling the data-validate-submission attribute on the form as shown below. Setting this attribute to true…

#Dynamics 365 #Dynamics 365 Customer Insights - Journey #Dynamics 365 Marketing #Microsoft Dynamics 365

Implementing Server-Side Honeypot Validation for Dynamics 365 Customer Insights - Journeys Forms

In our previous post, we implemented a simple Honeypot for Dynamics 365 Customer Insights – Journeys Real-Time Marketing forms using JavaScript.Although that prevents most automated submissions, the validation only runs in the browser. Anyone can bypass the JavaScript and submit requests directly to the server.Fortunately, Customer Insights – Journeys provides a server-side validation pipeline…

#Dynamics 365 #Dynamics 365 Customer Insights - Journey #Honeypot #Marketing #Microsoft Dynamics 365 #Validation

Implementing a Simple Honeypot in Dynamics 365 Customer Insights - Journeys Real-time Marketing Forms

While working with Dynamics 365 Customer Insights – Journeys Real-time Marketing Forms, we wanted to explore a simple way of reducing bot submissions. A common technique used on websites is a honeypot. The idea is straightforward: Add a field that genuine users never see. Hide it using JavaScript. If the field contains a value when the form is submitted, assume it was completed by a bot and…

#Dataverse #Dynamics 365 Customer Insights - Journey #Dynamics 365 Customer Insights Journey #Dynamics 365 Marketing #Microsoft Dynamics 365

Retrieve All One-to-Many Relationships and Cascade Delete Behavior for a Dataverse Table Using C#

While working on a Dynamics 365 Field Service cleanup, we needed to delete a large number of Work Order records. Before doing so, we wanted to understand exactly what would happen to the related records. Not every relationship is configured for Cascade Delete. Many use RemoveLink, which doesn’t delete the child records. Instead, Dataverse updates the lookup field to null by removing the…

#Dataverse #Dynamics 365 #Microsoft Dynamics 365 #Microsoft Dynamics CRM

Why SQL4CDS Record Counts May Not Match Advanced Find for Date Filters (Dataverse / Dynamics 365)

While validating some Dynamics 365 Field Service data recently, we came across an interesting scenario where SQL4CDS and Advanced Find returned different record counts even though the date filters appeared to be identical. At first glance it was surprising to see different record counts being returned despite using what appeared to be the same date range. After investigating further, we found…

#Dataverse #DateTime #Dynamics 365 #Microsoft Dynamics 365 #PowerApps #SQL4CDS #TimeZone #UserLocal

How We Successfully Removed the Resco Woodford Managed Solution from Dynamics 365 Field Service

Recently, we needed to remove the legacy Resco MobileCRM (Woodford) managed solution from a Dynamics 365 Field Service environment. Although the uninstall initially appeared straightforward, when we attempted to uninstall the Woodford solution, Dynamics 365 displayed a list of dependencies that needed to be addressed before. The dependencies included references from model-driven apps, site…

#Delete #Depedencies #Dynamics 365 #Dynamics 365 Field Service #Managed Solution #Microsoft Dynamics 365 #Resco

Unable to Delete Work Order Due to "The Time To Promised Must Be Later Than The Time From Promised" exception - Dynamics 365 Field Service

While attempting to delete a historical Dynamics 365 Field Service Work Order, we encountered the following error: Exception Message: The time to promised must be later than the time from promised. ErrorCode: -2147220891 HexErrorCode: 0x80040265 Error Details: {“errorCode”:2147746405,”message”:”The time to promised must be later than the time from…

#CRM #Dataverse #Dynamics 365 #Dynamics 365 Field Service #Microsoft Dynamics 365

Open a Power Automate Flow for Edit Without Fixing Broken Connections First

While reviewing Power Automate flows recently, we ran into an issue where we could not open a flow in edit mode When opening the flow, Power Automate displayed the “This flow will connect to” screen and requested that we fix one or more connections before proceeding. In our case, the flow contained an Office 365 Outlook connection reference that required attention. The problem was that we did…

#Cloud Flow #Flow #Power Automate

Dataverse Web API: Returning Record Data During Create Using Prefer: return=representation

When creating records using the Dataverse Web API, the default behavior is to return a successful response without including the record data in the response body. A standard create request does provide access to the newly created record’s GUID through the OData-EntityId response header. However, if we need additional column values from the newly created record, we would typically need to perform…

Testing the New RunJobForSandbox Option in Bulk Delete Jobs (Preview) – Dataverse / Dynamics 365

Microsoft recently introduced a preview feature for Dataverse Bulk Delete Jobs that provides additional control over bulk delete processing. One of the new options available when creating a bulk delete job through the API is RunJobForSandbox. According to the documentation, this option is intended to control sandbox processing during bulk delete operations, which could be particularly useful in…

#Bulk Delete Job #Bulk Deletion Job #CRM #Dataverse #Dynamics 365 #Microsoft Dynamics 365 #RunJobForSandbox

Using RetrieveDependenciesForDeleteRequest to find and delete hidden dependencies (Dataverse/ Dynamics 365)

Please refer to the post below, which provides a clear explanation of how RetrieveDependenciesForDeleteRequest works and how it can be used to identify dependencies. D365: Unable to delete entity having hidden dependency(with Canvas App)

#Dataverse #Dynamics 365 #Microsoft Dynamics 365

Troubleshooting Hidden Dependency Errors in Dynamics 365 and Dataverse

Recently, while cleaning up some old customizations in Dynamics 365, we came across an interesting dependency issue that was not immediately obvious from the user interface. What initially looked like a simple Business Process Flow deletion turned into a deeper investigation into how Dataverse manages published dependencies internally. While trying to delete a BPF, Dataverse returned the…

#Dataverse #Dependencies #Dynamics 365 #Microsoft Dynamics 365 #Missing Dependency

Capture UTM Parameters in Dynamics 365 Marketing Forms Using JavaScript (Dynamics 365 Customer Insights)

When running marketing campaigns, UTM parameters help us understand where our leads are coming from. They help us track whether a lead came from Google Ads, Facebook campaigns, email campaigns, or some other source. Recently while working with a Dynamics 365 Marketing form, we used a small JavaScript snippet to automatically capture UTM parameters from the URL and store them directly into…

#Dataverse #Dynamics 365 Customer Insights - Journey #Marketing #Microsoft Dynamics 365

Trending Blogs

Recently Viewed Blogs

Dynamics365