Unanswered

jOIN IN TWO TABLE

(1) Share

Report

Posted on by Giovanni1

Hi, I need your help... I have to calculate the total, but only of the sales movements, therefore excluding the other movements. I have two tables: TESDOCUM where I have all the document types and the value of each of them, but I only need to take the sales and to do this I should do a join with the TIPODOCU table, in which I could do the join with the Code column and the Tipoprotoc of the TESDOCUM table, but I need to filter through TIPODOCU only those that have VE in the column, to then calculate the sale. I also attach a part of the code, but this part is missing. Sum( Filter( TESDOCUM; DATAPROTOC = Data_1.Text And MAGAZZINO = ThisItem.MAGAZZINO ); USR_TOTDOC ) I hope for your help. Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

anandm08 1,936 Super User 2024 Season 2 on at

Like (2)

Report
Copy link

Link copied!
hi @Giovanni1 ,
you can use this code:
Sum( Filter( TESDOCUM, DATAPROTOC = Data_1.Text And MAGAZZINO = ThisItem.MAGAZZINO And TIPOPROTOC in Filter(TIPODOCU, CAUSALE = "VE").CODICE ), USR_TOTDOC )

Was this reply helpful? Yes No
Giovanni1 on at

Like (1)

Report
Copy link

Link copied!

I have this message

Was this reply helpful? Yes No
anandm08 1,936 Super User 2024 Season 2 on at

Like (1)

Report
Copy link

Link copied!

@Giovanni1 can't understand the warning message not in english.

Was this reply helpful? Yes No
Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hey @Giovanni1 ,

try this:
//In a Button or onChange OnVisible ClearCollect(colCODICE; Filter(TIPODOCU; CAUSALE = "VE").CODICE);; // Sum( Filter( TESDOCUM; DATAPROTOC = Data_1.Text And MAGAZZINO = ThisItem.MAGAZZINO And TIPOPROTOC in colCODICE // MAybe you'll need to add a .Value ); USR_TOTDOC )
The error that you've got was a Delegation warning. This is a Workaround to this warning. It will still appear but it will not falsify your results like this.

Was this reply helpful? Yes No
Giovanni1 on at

Like (1)

Report
Copy link

Link copied!

Unfortunately, even with this attempt the message is the same. Does not display any results

Was this reply helpful? Yes No
Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
The message will always display.

could you check if there is Data inside the created Collection :
colCODICE

Was this reply helpful? Yes No
Giovanni1 on at

Like (1)

Report
Copy link

Link copied!

yes the data is present

Was this reply helpful? Yes No