Help with Table Formulas

(0) Share

Report

Posted on by BenGillard

120

is it possible have a formula so that my forth data table show DataTable1 x DataTable2 X DataTable3

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

mdevaney 29,989 Moderator on at

Like (0)

Report
@BenGillard

Yes, it is possible. Can you please copy the code from the Items property of each Data Table and paste here in the thread? I can use this information to help you build the combined Table.

I assume the first 3 tables have the same datasource so what we are going to do is combine all of the Items properties in such a way that the 4th Data Table displays all the results. The code will likely look something like this...

Filter( your_datasource_name, (your conditions from Table1 here) Or (your conditions from Table2 here) Or (your conditions from Table3 here) )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
BenGillard 120 on at

Like (0)

Report

Hi, thank you very much for your help:

3 different sources but all have same column headers.

Table 1: Filter(Table1,Column1 = Dropdown1.SelectedText.Value)

Table 2: Filter(Table2,Column1 = Dropdown1_1.SelectedText.Value)

Table 3: Filter(Table3,Column1 = Dropdown1_2.SelectedText.Value)

So I would like table 4 to be : Table1*Table2*Table3.

Hope that makes sense. Thanks again

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@BenGillard
To confirm: you want to see the numbers multiples in Table4?

I think I misread the question earlier but I can still help do this with the info provided.

Was this reply helpful? Yes No