Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Query building issues

(0) ShareShare
ReportReport
Posted on by 128

Hi folks,

 

Working in Dataverse here. I need to retrieve a list of Contacts that either have no case record associated, OR only case records with status Resolved or Canceled.

 

I'm struggling to build this query, in part because the filter options in Dynamics do not offer the Or functionality across multiple tables. Currently I'm trying my luck with the Dataverse REST builder and the Fetch XML builder within XRM Toolbox, but seem to be getting stuck. this is my latest FetchXML try:

 

</filter>

<link-entity name="incident" alias="ab" link-type="inner" from="customerid" to="contactid">

<filter type="or">

<condition attribute="statecode" operator="eq" value="0"/>
<condition attribute="customerid" operator="null" entityname="ab"/>

</filter>
</link-entity>

This is if course not the complete XML. When running this in the Builder, I get an error implicating that I should remove the "entityname="ab"" but that results in another error.

 

Not sure how to proceed here - any advice would be greatly appreciated!

 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard