cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rob_G
Helper I
Helper I

PowerApps Sum 2 Columns of 2 diferent lists in sharepoint

Hi, I have 3 lists in sharepoint: test1, test2, test2
In the lists: test2 and test3, I have a calculated field, which contain values from other columns in each list.
Field name: "totalped1" for the list test2 -> the first record 60,000 has this value
Field name: "totalped2" for the test3 list -> the first record 60,000 has this value
I have a gallery in PowerApps where I want to add the values of both columns, I tried to do this formula: Sum ([@ test2], totalped1) + Sum ([@ test3], totalped2) but it does not add is not correct. It should be 120,000 and it tells me another value.

3 REPLIES 3
WarrenBelz
Super User
Super User

Hi @Rob_G ,

Beware of calculated SharePoint field when you do anything other than displaying them.

I suggest you simply do the same calculation in Power Apps using the same data columns.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks for the advice,
Sorry but I'm confused, I would like Share Point or PowerApps to do this:


List 2 (Field1 + Field2) = Total Fields List2
List 3 (Field3 + Field4) = Total Fields List3

List 1 = Total Fields List2 + Total Fields List3

How can I do the powerapps, if I have a gallery with the DB List1?

 

I have a field in list1 in which I want to do this.

Another thing I can think of is to use a formula in list1 and add each column of each list. Example:

 

field_list1 = list2, (value1 + value2) + list3, (value3 + value4)

 

PS: This is not a formula, it is just to illustrate what I wish I could do.

v-siky-msft
Community Support
Community Support

Hi @Rob_G ,

 

What is the relationship between List1 and List2&List3?  Because in general, there should be a common column among three lists as index to know which item to retrieve data for calculation.

For example: the common column is ID field,

 

The summary label in List1 Gallery should have the following formula:

LookUp(List2, ID=ThisItem.ID).'Total Fields List2' + LookUp(List3, ID=ThisItem.ID).'Total Fields List3'

 

In addition, the mistake for your try is that Sum() function is to sum the field value for all record in the list, rather than the first record you thought.

Hope this helps.

Sik

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (5,692)