Using Union function to remove duplicates – Power Automate / Dataverse

The article discusses an error encountered in a cloud flow while trying to fetch distinct work orders with notes and attachments. The error message indicates a mismatch in resource types. The solution is to rewrite the Fetch XML query without using aggregation and then use the Union function to remove duplicates. The article provides an example of how to use the Union function to achieve this. The Union function is used to combine two arrays and remove any duplicate values. The article concludes by mentioning that more information on Fetch XML queries can be found in the provided link.

Article 13m Nishant Rana's Weblog

---

Login now to access my digest by 365.Training

Login