Answered

Sum of columns in label text, based on data from two tables (SQL)

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Community, I am currently looking at a gallery. In this gallery I have a Title and a Subtitle. The Title has data from the column 'Initiative' from the datasource 'Table1' (SQL). However, I am using a datasource called 'Table2' (also SQL) for the subtitle, which is supposed to Sum up the column 'Realized Savings', for all values connected to the same value in the 'Initiatives' column. Not to make too much confusion, there is also a column called 'Initiatives' in "Table2", and the values are identical to those of "Table1", except for the frequency, since 'table1' is sort of one level up in my overall project. So, so far I've written the following code: Sum(Filter('[dbo].[Table2]';Realized_Savings='Initiative');Initiative), It is accepted but has a blue wiggely line under it. Any idé of how I can continue with this? Or if I'll have to do something else in my original data? Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
So the situation is:
You have two table, table1 and table 2, both has a column named to 'Initiative',

and within the Galley, the Title1 Label has been configured to 'Initiative' under Table1, and for the SubTitle, you would like to sum up the 'Realized Savings' from Table 2, for all the 'Initiative' column value equals to the one configured under the Title1 from Table1,

If this is what you would like to achieve, then please take a try to switch the formula as blow:

Sum(Filter('[dbo].[Table2]';Initiative=Title1.Text);Realized_Savings)

The column name for "Realized Savings" might be different from the above, please consider select the proper one from the Dropdown when writing the formula.

Let me know if that would work as expected.

Regards,

Michael

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Michael,

It worked exactly as I wanted. Thank you very much.

Was this reply helpful? Yes No