Power Platform Community Forum Thread Details

I'm trying to wrap my brain around how to access data in not directly related tables in model driven apps.

For example, I have 5 tables:

Projects
Project Tasks (N:1 to Projects)
Project Task Line Items (N:1 to Project Tasks)

Task Card (N:1 to Project Tasks)
Task Card Line Items (N:1 to Task Card)

Project Task Line Items stores the line items required in a task, and the quantity required for that task to be completed.

The Task Card Line Items stores the line items completed by someone when filling out a task card.

When creating a view or form for Project Task Line Items, I'm struggling to figure out a way to access the sum of the quantity column in Task Card Line Items in a model driven app. Its relatively simple in a canvas app where you get full access to powerfx. I can't use a formula column from what I can see because the filter function is not available, and you can't access indirectly related tables. What I'm trying to understand is how do I do the following in a model driven app, or dataverse directly:

If the "Task Card Line Item's" "Task Card's" "Project Task" matches my "Project Task", sum the quantity column of the matching "Task Card Line Items" and update the value of my quantity remaining column in "Project Task Line Items" to the value of the sum.

I'm only new to model driven apps / dataverse, and I'm starting to get a feel that you need to plan around doing everything a specific way for it to all work out.

Categories:

Microsoft Dataverse with Power Apps