web

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

News and Announcements icon

Power Platform CommunityForums Power Apps filter/count CDS multi...

Power Apps

Answered

filter/count CDS multiple selection field with specific word included or not

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am trying to filter/count CDS multiple selection field.

I would like to filter/count specific is included in multiple selection fields or not.

This is how I tried but not working.

Could someone advise me how to solve this?

😥

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to filter or countrows based on a multiple choice column?
1)Filter:

set the data table's Items:

Filter( AddColumns(store,"subs",Concat(store_category_sub,Value&",")), "jew" in subs )

2)CountRows:

CountRows( Filter( AddColumns(store,"subs",Concat(store_category_sub,Value&",")), "jew" in subs ) )

Best regards,

Was this reply helpful? Yes No

Join the conversation