Power Platform Community Forum Thread Details

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

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.

Categories:

Design & build

Quick Links