Answered

Subtotal of related values from Power apps tables

(0) Share

Report

Posted on by User23567

This should be the simplest task to accomplish but I just can't get it working and searching for solutions just seems to lead me down rabbit holes.

I have 2 related tables in powerapps - 'Details' and 'Line Items'. The primary key from 'Details' (Details ID) is a lookup required for all entries in 'Line Items'. Each 'Line Item' entry has a value.

Ideally, I want the 'Details' table to contain a 'Line Items Total' field but the powerapps table interface doesn't seem to accept the sum(filter(... formula that I think I should use.

Details Table

Details ID	Line Items Total (required formula column)
A	15
B	4
C	6

Line Items Table

Line Item Number	Detail ID (required lookup)	Line time value
001	A	10
002	A	5
003	B	4
004	C	1
005	C	2
006	C	3

I feel like there's a key aspect of this that I've missed as in an Access database this would have taken me about 5 minutes to accomplish through a query. I can't figure out what the equivalent of the query step is in the power platform ecosystem. I can't seem to access Power Query from the Power Apps interface I have.

Any help would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

NPPlatform 606 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @User23567 , are you working with Dataverse? And do you want this column to be added in Dataverse? If so, you'll need to add a roll-up column. Check out this video on how to do this: https://www.youtube.com/watch?v=GvdmsPEkCYg.

Edit: If you only want to use line items total in a Power App, you don't have to add it to your datasource. You can calculate it inside of your app. To do so, create a gallery that has the Details-table as its items. Add a label to this gallery with the following code:

Sum(
Filter(
'Line Items Table',
'Detail ID'.'Detail' = ThisItem.'Detail'
),
'Line Time value'
)

This will give you the sum of Line Time Value related to the row in your Gallery

Was this reply helpful? Yes No
User23567 6 on at

Like (1)

Report
Copy link

Link copied!

Thanks @NPPlatform! I followed the video you provided and it sorted me out.
You're the best 👏

Was this reply helpful? Yes No