cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Craig77
Level: Powered On

Sumifs in Powerapps

Guys,

 

How do I do a Sumifs in Power apps

 

I want to be able to do the following:

 

Sum of column Days, where column Name = Name=User().FullName

 

So in Excel it would be something like  =SUMIFS(H:H, A:A, "Craig Jenkins")

 

 

4 REPLIES 4
Community Support Team
Community Support Team

Re: Sumifs in Powerapps

Hi @Craig77,

 

The formula should be:

Sum(Filter(Table1,Name=User().FullName),Days)

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Craig77
Level: Powered On

Re: Sumifs in Powerapps

Amazing thank you so much

Craig77
Level: Powered On

Re: Sumifs in Powerapps

Hi Mona,

 

Sorry to repost on this.  I have set this up now using a Sharepoint List rather than an Excel Spreadsheet.  The list is called Leave Request.  I am trying to recreated the formula as well as adding something else to it but I can't seem to get this to calculate correctly. 

 

SP List is Named 'Leave Request'

Columns involved are named 'Full Name', 'Status' , 'Leave Type' and 'Days' in the SP List

 

So I'm trying pull through from the SP LIst, the number of Days where Full Name = User, Status = Approved, Leave type = Holiday

 

PA.JPG

 

 

SP LIsts.JPG

 

 

Highlighted
Anonymous
Not applicable

Re: Sumifs in Powerapps

Hi there,

 

The Filter formula used has a function in it (User()), which will cause a delegation issue if im not mistaken, for sharepoint that means it will only return 500 records, you can up this to 2000, however you're going to have a problem doing a sumifs if all the records are not returned.

 

One option is to try and send off the user name as a variable, but this is not going to get around the number of records returned.

 

updateContext({UserName:User().FullName});
Sum(Filter(Table1,Name=UserName),Days)

If you are trying to do calculations on a scale I would suggest a PowerBI tile.

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,801)