Answered

Count values in column if person matches

(0) Share

Report

Posted on by stephenjcarr

138

I'm making a holiday request tool and would like to add a way for the user to see the total number of holidays they have taken.

I have a label on my power app which shows the current logged in user:

Label 5.Text = Office365Users.MyProfileV2().displayName

My app is linked with a sharepoint list titled "Holiday Request Tool." I would like to add another label to my app, which looks through the sharepoint entries to find all entries which match the Label5 in the "EID" column, then adds together all of the values in the "Number Of Days" column. Screenshot attached of my Sharepoint list. The screenshot shows 2 requests from the same person for 6 days and 8 days holiday, so I would like the label in my app to return 14.

Can anyone help me do this please?

Thanks, Screenshot 2023-06-23 at 20.01.58.png

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @stephenjcarr

This should give you the result that you're looking for:

Sum(Filter('Holiday Request Tool', EID=Label5.Text), 'Number Of Days' )
stephenjcarr 138 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @timl thanks for your reply!

This code doesnt give me any errors (other than a delegation warning), but the label is still blank. Do you have any ideas why this might be?

Thanks,
stephenjcarr 138 on at

Like
a
(0)

Report
Copy link

Link copied!

Never Mind @timl - Found the problem!

Sum(Filter('Holiday Request Tool',
EID.DisplayName=Label5.Text),
'Number Of Days'
)
Thanks again!