Unanswered

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

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

timl 36,328 Super User 2025 Season 2 on at

Like (0)

Report
Hi @stephenjcarr

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

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

Was this reply helpful? Yes No
stephenjcarr 138 on at

Like (0)

Report

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,

Was this reply helpful? Yes No
stephenjcarr 138 on at

Like (0)

Report

Never Mind @timl - Found the problem!

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

Was this reply helpful? Yes No