Loading...

Using Union function to remove duplicates – Power Automate / Dataverse

Using Union function to remove duplicates – Power Automate / Dataverse
We recently got the below error in one of our cloud flows, the requirement was to fetch the distinct work orders that have notes with attachments associated with them. A resource of type ‘Microsoft.Dynamics.CRM.annotation’ was found in a resource set that otherwise has entries of type Microsoft.Dynamics.CRM.msdyn_workorder’. In OData, all entries in a resource set … Continue reading "Using Union function to remove duplicates – Power Automate / Dataverse"

Published on:

Learn more
Nishant Rana's Weblog – Everything related to Microsoft .NET Technology
Nishant Rana's Weblog – Everything related to Microsoft .NET Technology

Everything related to Microsoft .NET Technology

Share post:

Related posts

Power Automate: Office 365 Outlook - When a new event is created Trigger

The "When a new event is created" trigger monitors your Outlook calendar in Power Automate. Learn about UTC gotchas, duplicate triggers, and t...

1 day ago

Microsoft 365 & Power Platform Community Call – April 9th, 2026 – Screenshot Summary

Call Highlights   SharePoint Quicklinks: Primary PnP Website: https://aka.ms/m365pnp Documentation & Guidance SharePoint Dev Videos I...

2 days ago

[REDACTED] message when turning on a Power Automate flow

We all like useful error messages. How about the [REDACTED] Message when you turn on a flow? In this post you will find the steps to fix this ...

2 days ago

Power Automate: Do Until Action

The "Do Until" action loops in Power Automate until a condition is met. Learn its limits, why it always runs once, and how to avoid runaway lo...

2 days ago

Use Inventory to find your Power Automate flow?

How often do you want to find a flow, but you can’t remember which environment you created the flow in? It can be quite a

2 days ago

Power Platform Monitor Alerts Are Now Generally Available

We are excited to announce that Power Platform Monitor alerts for apps, agents, and flows are now generally available! Monitor alerts meet the...

3 days ago

Power Platform Monitor Alerts Are Now Generally Available

We are excited to announce that Power Platform Monitor alerts for apps, agents, and flows are now generally available! Monitor alerts meet the...

3 days ago

Power Automate: reverse Function

Learn how to use the Power Automate reverse function to flip the order of items in an array. Includes examples with strings, objects, and sort...

3 days ago

Microsoft 365 & Power Platform Call (Microsoft Speakers) – April 7th, 2026 – Screenshot Summary

Call Highlights   SharePoint Quicklinks: Primary PnP Website: https://aka.ms/m365pnp Documentation & Guidance SharePoint Dev Videos Issues...

4 days ago

Why you need the question mark operator in Power Automate expressions

Learn why the question mark operator in Power Automate prevents runtime errors when accessing properties that might not exist, and how to use ...

4 days ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy