Skip to main content
Community site session details

Community site session details

Session Id : 5eY+hAZbqzViawVtbBQkqZ
Power Apps - Building Power Apps
Answered

Help with Filter and SUM function in PowerApps

Like (0) ShareShare
ReportReport
Posted on 30 Nov 2022 07:36:48 by

Good day

 

I have a SQL table called "ZHA_IND", with a column name called "GSART".  Under column GSART I have records that contain "33L", "33A","33B","33I","33K","33D" and "33C") which I want to filter on.  After filtering, I want to SUM all the extracted items under the "EXPOSURE" column).  I have a variable declared for the record called varBPRecord.  This is my formula (but I know it is totally wrong and it also gives me a Delegation error):

 

Sum(Filter(ZHA_IND,varBPRecord.GSART="33L",varBPRecord.GSART="33A",varBPRecord.GSART="33B", varBPRecord.GSART="33I",varBPRecord.GSART="33K",varBPRecord.GSART="33D",varBPRecord.GSART="33C"),ThisItem.EXPOSURE)

 

Can you please assist me with the correct formula?  I am just totally braindead this morning 

 

Thank you kindly

Categories:
  • janineb Profile Picture
    on 30 Nov 2022 at 08:44:28
    Re: Help with Filter and SUM function in PowerApps

    Thank you - as always you have solved my problem.  Much appreciated

  • Verified answer
    WarrenBelz Profile Picture
    148,799 Most Valuable Professional on 30 Nov 2022 at 07:43:35
    Re: Help with Filter and SUM function in PowerApps

    Hi @janineb ,

    I am not an SQL user, but this structure should work and solve your Delegation issue providing the top filter returns record numbers less than your Delegation limit

    With(
     (
     wList:
     Filter(
     ZHA_IND,
     varBPRecord.GSART="33L" ||
     varBPRecord.GSART="33A" ||
     varBPRecord.GSART="33B" || 
     varBPRecord.GSART="33I" ||
     varBPRecord.GSART="33K" ||
     varBPRecord.GSART="33D" ||
     varBPRecord.GSART="33C"
     )
     },
     Sum(
     wList,
     EXPOSURE
     )
    )

     

    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.

    Visit my blog Practical Power Apps

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.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1