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 / Accessing data from no...
Power Apps
Suggested Answer

Accessing data from not directly related tables

(2) ShareShare
ReportReport
Posted on by 4

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.

I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,960 Moderator on at
    HI,
     
    1) you could create a flow that triggers when the main one (task card line items) is created or modified, unless its a different column
    Then in the flow, you will have THAT items ID
     
    Use that to find the other parts.
     
    Do the Sum and then update
     
    2) you could create a plugin to do the work any time something is created or update (again like #1)
     
    Personally I cannot stand the normal workflow engine, so I would do 1 or 2 above.
     
     

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!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 103

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
wolenberg_ Profile Picture

wolenberg_ 67 Super User 2026 Season 1

Last 30 days Overall leaderboard