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

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 Automate 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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 334 members 5,776 guests
Recent signins:
Please welcome our newest community members: