Using Union function to remove duplicates – Power Automate / Dataverse
Published on:
Learn moreRelated posts
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 earli...
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 go...
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...
Implementing Cloudflare Turnstile for Dynamics 365 Customer Insights – Journeys Real-Time Marketing Forms
Check the previous posts for more details – In one of our recent projects, we implemented Cloudflare Turnstile (Invisible) for a Dynamic...
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 Ma...
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 Jav...
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 bo...
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...
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 returne...
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 t...