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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Nested Linking of enti...
Power Apps
Unanswered

Nested Linking of entities on DataSet

(0) ShareShare
ReportReport
Posted on by 5

Hi everyone! 

 

Is it possible to add nested linking of entities on Dataset?
Currently I can link entities using 

context.parameters.sampleDataset.linking.addLinkedEntity(...)

It's possible with fetchXml to add link-entity within a link-entity, is it possible with dataSet addLinkedEntity ?

I have the same question (0)
  • AnqiChen Profile Picture
    Microsoft Employee on at

    Yes, you could, we are writing samples, here is the sample:

    // code snippet
    var expression = {
    name: "account",
    from: "accountid",
    to: "parentcustomerid",
    linkType:"inner",
    alias:"anyuniquealaisname ",
    };

    context.parameters.dataSetGrid.linking.addLinkedEntity(expression);
    context.parameters.dataSetGrid.addColumn("new_additional_attributename", "anyuniquealaisname "); // anyuniquealaisname same as above
    context.parameters.dataSetGrid.refresh();

     

    If u need to get value of those linked entity columns, u could check the column name from

    context.parameters.datasetGrid.columns,

    then use

    context.parameters.datasetGrid.records[recordId].getValue(<colum_name_u_want>)

     

    Feel free to let us know your concern

  • JoCas Profile Picture
    34 on at

    Hi @AnqiChen! I think by the word nested he means implementing a fetchXml of something like this on a bounded dataset filter

    <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
     <entity name="entity_a">
     <attribute name="name" />
     <link-entity name="entity_ab" from="entity_aid" to="entity_aid" link-type="inner" alias="ac">
     <link-entity name="entity_b" from="entity_bid" to="entity_bid" link-type="inner" alias="ad">
     <filter type="and">
     <condition attribute="attr" operator="in">
     <value uiname="aa" uitype="entity_b">{56D33AE2-7906-EA11-A811-000D3A793530}</value>
     <value uiname="bb" uitype="entity_b">{976F38C2-EB01-EA11-A811-000D3A7972C1}</value>
     <value uiname="cc" uitype="entity_b">{2F03710B-EC01-EA11-A811-000D3A7972C1}</value>
     </condition>
     </filter>
     </link-entity>
     </link-entity>
     </entity>
    </fetch>

    as you can see, I'm not filtering on a first level linked entity but on a 2nd level and possible N-levels. 
    Is this currently possible with filtering on bounded pcf datasets?

    Thank you very much
    Cheers!

     

  • ScottDurow Profile Picture
    1,039 on at
    Nested links are not possible - you can only add a single relationship from the root entity - think of it as the same as filtering on grid columns.
  • lpetzoldt Profile Picture
    7 on at

    I think @ScottDurow is right about this, but support for nested linking should really be included in an update. It prevents many meaningful queries that would allow for more rich filtering and presentation.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 638

#2
Haque Profile Picture

Haque 317

#3
WarrenBelz Profile Picture

WarrenBelz 315 Most Valuable Professional

Last 30 days Overall leaderboard