use dropdown to filter gallery based on sharepoint choice list

(1) Share

Report

Posted on by cheezy

148

Struggling to get this to work.

I have a gallery displaying sharepoint records . One of the columns in sharepoint is a multiselection column called Responsibility.

I dont have the Responsibility field displayed in the gallery (not necessary) but the Responsibility multiselections selections are visible when detail/edit form displays.

i would like to filter the gallery using a dropdown(default value would be blank so all records returned), so then user could select one Responsibility choice only and display the relevant records in the gallery.

any advice appreciated thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,632 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Hi @cheezy ,

The syntax would be

Filter( ListName, Len(ddName.Selected.Value) = 0 || ddName.Selected.Value in Responsibility )

Note that this is not Delegable.

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.

Was this reply helpful? Yes No
cheezy 148 on at

Like (1)

Report
Copy link

Link copied!

thanks as always

the syntax works fine when dropdown AllowEmptySelection set to true

Was this reply helpful? Yes No