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:

General Questions

All responses (2)

Answers (1)

cheezy 148 on at

Like (1)

Report

Re: use dropdown to filter gallery based on sharepoint choice list

thanks as always

the syntax works fine when dropdown AllowEmptySelection set to true
Verified answer

WarrenBelz 146,679 Most Valuable Professional on at

Like (2)

Report
Re: use dropdown to filter gallery based on sharepoint choice list

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.