web

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

News and Announcements icon

Power Platform CommunityForums Power Apps countIf logic Multicho...

Power Apps

Answered

countIf logic Multichoice column

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi!

The column Perfil is a multichoice column and I want to count all the persons who have in the multichoice column "firmante"

Thanks a lot!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

For a multichoice column you can use the Choices function:
https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-choices

Was this reply helpful? Yes No
Verified answer

v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous

Could you please tell me:

Is firmante a option in multi-choice column Perfil?
Do you want to count how many items in the Perfil column select firmante?

I have made a test for your reference:

CountRows(Filter(YourDataSource,"firmante" in Concat(Perfil,Value&";")))

Best Regards,

Levi

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

thanks a lot! it works perfect!

Was this reply helpful? Yes No

Join the conversation