sum of field using different table

(0) Share

Report

Posted on by PriyaShetty

Hi I want to sumfor certain fields based on the value of other table.Kindly help.

Here is the table 1

AID KEY SUBKEY

1 fin est

2 fin rel

3 des sur

4 des init

Table 2:

AID num

1 3

2 4

3 6

4 7

here i want the sum of field "num" to be displayed in a text Label control based on the Key from table1. For eg for the key fin sum should be 7 and for des sum should be 13.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

eka24 20,925 on at

Like (1)

Report
Copy link

Link copied!

OnVisible or OnStart of the App, create a collection:
ClearCollect(JoinedT2,AddColumns(Tabel2,"Key",LookUp(Tabel1,AID=Tabel2[@AID],Key)))

Then assuming you will type "Fin" in TextInput2.

In TextInput3 default use this code:
Sum(Filter(JoinedT2,Key=TextInput2.Text),num)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

JayMagness 1,663 on at

Like (1)

Report
Copy link

Link copied!

Hi all,

Got on teams with the user and helped setup a SUM function and Filter

Sum(Filter('DB',DepartmentName=ThisItem.Department,HideDuplicateRecord=0))

All running well now.

Was this reply helpful? Yes No