You’re offline. This is a read only version of the page.
22
I want to get the column "Total" in "Table1" to be the calculated sum of "Total" from "Column2", "Column3" and "Column4". So that "Total" in "Table1" is the full sum of the three other totals together. Is this possible? If so, how do I implement it?
Thank you
EDIT: It will also have to be where "ClientID" is the same in all tables.
Hi @naaatthh
Only if the relationships were as we discussed with the lookup columns to the other tables on the Table 1. Example is you could have a N:1 from Table 2 to Table 1 with a Lookup column for Table 2 record on Table 1. The calculated field could then reference through this relationship and pull a field from the other table. Same with others... You can not use a calculated field to pull values from other tables otherwise.
As @EricRegnier mentioned as well, you could keep the field as "not calculated" and then utilize Power Automate to pull the values from the other tables based on your own business logic and populate the value on table 1 but this is not real-time and would require the appropriate trigger conditions on anything that could affect the Table 1 value.
@EricRegnier @dpoggemann Thank you both for you reply!
Would these solutions also work if I were trying to add a total from three separate tables into Table 1?
Thanks
Hi @naaatthh,
As @dpoggemann said, not possible with out-of-the-box calculated columns if the other columns are not lookups on the calculated column's table. The other options are:
Hope this helps!
Hi @naaatthh
You say Sum of column2, column3, column4, are all of these in tables that are referenced as Lookup columns in Table 1? If so then you can reference through those lookups in calculated columns but if these are not lookup columns in Table1 to these other tables, then no you can not do this currently.
Note, PowerFX is coming soon which may open up this capability, not sure yet if it would meet your needs exactly. https://powerapps.microsoft.com/en-us/blog/power-fx-coming-to-model-driven-power-apps-dataverse-and-more/
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
19
#3
Michael E. Gernaey
15
Super User 2025 Season 1
Share
Report
All responses (
Answers (
