web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Sum if dropdown value ...

Power Apps

Answered

Sum if dropdown value in SharePoint list

(0) Share

Report

Report

Posted on by KhrystinaM

158

Hello,

I am trying to write a formula that says, "If department = X then sum total steps. Right now, I have the total steps for all departments/associates, but I would like to break it down by department and by associate. How could I accomplish this?

Thank you,

Khrystina

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

AARON_C 2,235 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @KhrystinaM

You need to filter your Sum function. Try this:

Sum(Filter('Fitness Tracker', 'Department Name' = 'Name of dropdown control'.Selected.Value), Steps)

Please tick Accept as solution if the answer is useful.

Thanks,

@AARON_C

Was this reply helpful? Yes No
KhrystinaM 158 on at

Like (0)

Report
Copy link

Link copied!

@AARON_C, that worked. Thank you so much for your help! Wondering if you can help me with another question. I am trying to create an associate dropdown field, but the Associate field name is not in my allowed selection. The field in SharePoint is a Person or Group field. Can I not use that type of field for dropdowns? Associate Name is not in the list below.

Was this reply helpful? Yes No

Join the conversation