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")
The formula should be:
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
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.
If you are trying to do calculations on a scale I would suggest a PowerBI tile.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand