Skip to main content
Community site session details

Community site session details

Session Id : xGLjZNhn7t0DxohuBfrm3b
Power Pages - Design & Build
Unanswered

Help with fetch XML join error "Sequence contains no matching element"

Like (1) ShareShare
ReportReport
Posted on 20 Jan 2023 08:33:00 by 111

Hi,

I have two Dataverse virtual tables. When I join these tables using fetchXML I see error on the page:

 

{
 "results":
 [
 Liquid error: Exception has been thrown by the target of an invocation.
 ]
}

 

 

and error on logs: "Sequence contains no matching element"

I have permissions to both tables and can get data from each of them separately.

 

{% fetchxml feed %}
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
 <entity name="lux_propproperties" >
 <attribute name="lux_propertyname" ></attribute>
 <attribute name="lux_mspropertyid" ></attribute>
 <link-entity name="lux_mktgid_sources" from="lux_propertyid" to="lux_mspropertyid" alias="id_sources2" link-type="outer">
 <attribute name="lux_name" ></attribute>
 </link-entity> 
 </entity>
</fetch>
{% endfetchxml %}
{
 "results":
 [
 {% for item in feed.results.entities %}
 {
 "Name":"{{ item.lux_propertyname }}",
 "lux_mspropertyid": "{{ item.lux_mspropertyid }}",
 "lux_name": "{{ item.lux_name }}",
 }{% unless forloop.last %}, {% endunless %}
 {% endfor %}
 ]
}

 

My join fields have simple text format with the same length and look like GUID.

 

I will appreciate if you could help find what's wrong.

  • CU-20081201-3 Profile Picture
    57 on 05 Jun 2024 at 14:36:34
    Re: Help with fetch XML join error "Sequence contains no matching element"

    We are facing the same issue with link type "not any".

    Any hint would be 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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
Lucas001 Profile Picture

Lucas001 60 Super User 2025 Season 2

#2
Fubar Profile Picture

Fubar 55 Super User 2025 Season 2

#3
surya narayanan Profile Picture

surya narayanan 35

Featured topics

Loading complete