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 Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,887)