Announcements
Hello,
I am trying to calculate a sum total of 100+ columns with a power flow.
Is there another way to calculate without listing out all columns in the formula?
Thanks,
Jvang
You can easily calculate the sum of a column, but there is no way to address the individual fields in a row other than by name. So you'll need to access each column by name. In Excel you could create a formula in the sheet that would do it, but in SharePoint you will need to do the columns separately.
Do you have control over the table? It would be easier to have a column e.g. Title, and a value column. Then create a new row in place of each of your columns. You could then filter and use the sum of the values. You could store the results in a separate table that cross references the same Title.
e.g.
Table 1
Table 2
Hello, @Pstork1 ,
If I make a sum column in excel, would the formula for that column still be in tact for that?
If so, would making a power app from the sharepoint page have issues due to power apps not liking formulas from excel?
Hello @Anonymous,
I do have full control of the table, I will give this a try and get back to you.
Thank,
The entire data table in SharePoint would need to be in Excel to use the formula. You can't create just an Excel formula on data that is inside SharePoint.
@Anonymous ,
If I followed that table build, I would have a lot of rows on one part number due to the different locations that part number could be in. So, one part number can be in 100+ places and another part number could be in another place. I can be done; however, it would take much longer to do so.
In this case I suspect what you need to do is transfer this project to a real relational database, like SQL or Dataverse. You need to break this up into a parent table for the part and a related child table for the locations. SharePoint won't do that relationship well. But a real database will. Then the child table locations can be by row, which will make it easy to total them.
@Pstork1,
Alright, thank you for the help, very much appreciated.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 329 Most Valuable Professional
11manish 209 Super User 2026 Season 2
Mohsin Ali 179
