Answered

Building parent child schema in Dataverse for Team

(0) Share

Report

Posted on by smko

If this has been answered and fit exactly to my environment, please point me to the link. I been searching for weeks but unable to find a solution that based on dataverse for team. The scenario is building an expense report which will have approval flow etc. I know there are several videos for this including Reza Dorrani but those are not dataverse for team.

This is the parent table "TestHeader"

This is the child table "TestDetail"

All data shown are input manually for illustration purpose.

My question is how do I link whatever line items the user input into TestDetail through Power Apps to the one parent ID (HeaderKey), and the TotalCost column of TestHeader will aggregate the LineCost automatically.

All these must be done in Dataverse for Team, hence some functions wont work e.g. calculated/rollup field

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Ram Prakash Duraisamy 5,846 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @smko ,

Based on your scinario, i feel Rollup(Out of the box) in "Test Header" for TotalCost will work Properly.

if you think its not working

QueryExpression getTotalTestDetail = new QueryExpression("new_testdetail");//new_testdetail is logicalname
getTotalTestDetail.Columnset = new Columnset("cra18_linecost");
getTotalTestDetail.Criteria.AddCondition(new ConditionalExpression("new_ColHeader",ConditionalOperator.Equals,GuidofGetHeader);// new_colderhearder is the header name for header;
EntityCollection getValuesChild = service.RetireveMultiple(getTotalTestDetail);
int collectLineCost =0;
foreach(var loopgetValues in getValuesChild.Entites){
if(loopgetValues.Attributes.Contains("cra18_linecost"){
collectLineCost = collectLineCost + ((Money)loopgetValues.Attributes["cra18_linecost"]).Value;
}
}

Entity updateHeader = new Entity("cra18_lineheader");
updateHeader.Id = GuidofGetHeader;// new_colderhearder is the header name for header;
updateHeader["cra18_totalcost"] = collectLineCost;
service.Update(updateHeader);

Use plugin like above code to implement logic in Dataverse to achieve the same.

Was this reply helpful? Yes No
Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @smko,

You'll have to calculate with you canvas app. @rampprakash solution won't work in DV4T. Here's an exmaple:

CountRows(Gallery1.Selected.Cars)

Where Gallery1 is control mapped to the parent table (TestHeader in your case) and Cars is the child where the lookup column is (TestDetail in your case).

Hope this helps!

Was this reply helpful? Yes No