web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Service | Customer Service, Contact Center, Fie... / Using contain-values o...
Service | Customer Service, Contact Center, Fie...
Suggested Answer

Using contain-values operator for multi-select option set in outer-joined FetchXML makes it behave like an inner join.

(0) ShareShare
ReportReport
Posted on by DFA 100

I have tried to simplify the setup as much as possible.

I have two custom entities, tst_myFirstentity and tst_mySecondentity, with a 1-N relationship between them.
tst_mySecondentity contains a multi-select option set, called tst_multiselectoptionset, with the possible values of 865950000, 865950001 and 865950002.

There is one record in tst_myFirstentity which matches one record in tst_mySecondentity.
The one record in tst_mySecondentity has it’s tst_multiselectoptionset set to 865950000.

 

Using the eq-operator with link-type set to outer works as expected.
It returns every record in the first entity, no matter if the second entity matches or not.
If the second entity matches, then it is included in the result (not the case here):

pastedimage1648544546404v3.png


Using the contain-values operator with link-type set to outer does not seem to work as expected.
It only returns records from the first entity if the second entity matches (not the case here):
pastedimage1648544602629v4.png

Is this a known issue? And is there a workaround?

Thanks,
DFKA

I have the same question (0)
  • DFA Profile Picture
    DFA 100 on at

    I could generate all possible combinations and apply them using the in-operator on a or-filter.
    For the above example, 865950001 would become something like:

    pastedimage1648553970607v1.png


    But it seems that the whole purpose of the contain-values operator is to avoid this mess.

  • Suggested answer
    DavePinch Profile Picture
    DavePinch Microsoft Employee on at

    Hi DFA, this forum may not get a lot of visibility with FetchXML developers (although you can use FetchXML to pull Dynamics 365 Guides data from Dataverse). I would post your question on the Power Apps community:

    I did some searches for FetchXML to see if people are talking about it. The Microsoft Dataverse forum is a good start:

    Good luck DFA! You will need to re-post yourself as I cannot move your posting to another community.  For reference, here is FetchXML documentation:

  • DFA Profile Picture
    DFA 100 on at

    Thanks for your help,

    I have re-posted my question on the Power Apps community.

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 51 Super User 2026 Season 1

#1
Muhammad Shahzad Shafique Profile Picture

Muhammad Shahzad Sh... 51 Most Valuable Professional

#3
Nagaraju_Matta Profile Picture

Nagaraju_Matta 50

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans