web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter using multi sel...

Power Apps

Answered

Filter using multi select column

(0) Share

Report

Report

Posted on by arobles

17

I'm having trouble filtering records by filtering based in a multiselect column.

I have a Sharepoint list that has two columns (title, Departs). Departs is a multiselect column and I need to filter records that have a certain value in Departs.

For example List1 contains:

Record 1 title=one;Departs=HR, Legal

Record 2 title=two;Departs=HR,Admin

Record 3 title=3;Departs=Legal, HR

I'm using Filter(List1;"Admin" in Depparts);;

But gives error "Invalid schema. Expected a single column table."

How can I create a gallery containing the searched record?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @arobles ,

Please try this.

Filter(List1;"Admin" in Depparts.Value)

Best regards,

Rimmon
arobles 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Many Thanks.
Now it's working

Join the conversation