cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JoshuaRobert
Level: Powered On

Nested Linking of entities on DataSet

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 ?

4 REPLIES 4
Power Apps Staff AnqiChen
Power Apps Staff

Re: Nested Linking of entities on DataSet

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
Level: Powered On

Re: Nested Linking of entities on DataSet

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
Level 8

Re: Nested Linking of entities on DataSet

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
Level: Power Up

Re: Nested Linking of entities on DataSet

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.

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Users online (9,302)