How to groupby based on link-entity attribute using fetchXml in portals?

(0) Share

Report

Posted on by SaiKrishnaGudluru

499

Hi All, we have any option to GROUPBY the records based on link-entity? I am working on a requirement where I need to group by the results based on the link entity attribute. Below is the Fetch XML I am using.

When I am using groupby="true" getting Liquid error: Exception has been thrown by the target of an invocation.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
 <entity name="PRIMARYENTITY">
 <attribute name="PRIMARYENTITYid" />
 <attribute name="PRIMARYENTITYNAME" />
 <link-entity name="SECONDARYENTITY" from="SECONDARYENTITYid" to="SECONDARYENTITY" link-type="inner" alias="ap">
 <attribute name="SECONDARYENTITY_name" groupby="true"/>
 <filter type="and">
 <condition attribute="SECONDARYENTITYid" operator="eq" uitype="SECONDARYENTITY" value="{2D1C78B9-237A-EC11-8D21-000D3A5BB4A6}" />
 </filter>
 </link-entity>
 </entity>
</fetch>

Categories:

Power Apps portals

I have the same question (0)

All responses (3)

Answers (0)

Fubar 8,352 Super User 2025 Season 2 on at

Like (0)

Report
Suspect the error is because FetchXML also needs aggregate=true to use groupby

<fetch distinct='false' mapping='logical' aggregate='true'>

https://docs.microsoft.com/en-us/power-apps/developer/data-platform/use-fetchxml-aggregation#group-by-with-linked-entity

Was this reply helpful? Yes No
SaiKrishnaGudluru 499 on at

Like (0)

Report

@Fubar Yeah, initially I tried "aggregate" too, but no luck. Receiving same error.

Was this reply helpful? Yes No
Fubar 8,352 Super User 2025 Season 2 on at

Like (0)

Report

I would double check the FetchXML by putting it into XrmToolBox to verify its valid FetchXML etc.

Was this reply helpful? Yes No