web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Gallery with Mu...

Power Apps

Unanswered

Filter Gallery with Multiselect Choice Column in Sharepoint

(0) Share

Report

Report

Posted on by haurox

14

Hi all,

I have a SharePoint list(Demo List) with a Column - Countries which is a multi select Choice column. In powerapps, I have a gallery with items that have country next to it. I want to filter the gallery in a manner that only those items should be visible to the users whose country is the same as the user using the powerapp.

The code I am using right now is Filter('Demo List', Country.Value = Office365Users.Myprofile().Country) but the error I am getting is that it is incompatible comparison. I understand it is because the choice column is a multi select.

Can anyone please help me on this?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @haurox ,

Probably this is what you are after - note this is not Delegable

Filter( 'Demo List', Office365Users.Myprofile().Country in Country.Value )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No

Join the conversation