Filtering gallery results

(0) Share

Report

Posted on by sutekh

509

Morning!

I have a SharePoint list which has a view and also a checkbox. I want to filter a gallery so that it brings back filtered results. I understand that filtering by a SP view is problematic? What the best way to achieve this filtering? Thanks in advance

I have the same question (0)

All responses (20)

Answers (1)

eka24 20,921 on at

Like (0)

Report

Re: Filtering gallery results

Use:
Filter(SPList,ColumnName=Chexkbox1.Value)

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
sutekh 509 on at

Like (0)

Report

Re: Filtering gallery results

Thanks @eka24 , where would I put that filter?

Was this reply helpful? Yes No
sutekh 509 on at

Like (0)

Report

Re: Filtering gallery results

The formula box! Of course!

Was this reply helpful? Yes No
sutekh 509 on at

Like (0)

Report

Re: Filtering gallery results

@eka24as part of the Items yes?

Was this reply helpful? Yes No
eka24 20,921 on at

Like (0)

Report

Re: Filtering gallery results

Select the Gallery and put it on the Item Property

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
sutekh 509 on at

Like (0)

Report

Re: Filtering gallery results

Thanks @eka24 done that. This is what I've written and I'm getting an error. I'm doing something really dumb aren't I?

Was this reply helpful? Yes No
eka24 20,921 on at

Like (0)

Report

Re: Filtering gallery results

Change the Checkbox1 to the Actual name of your checkbox

Was this reply helpful? Yes No
sutekh 509 on at

Like (0)

Report

Re: Filtering gallery results

Thanks @eka24

My list is called Ideas_App_List and the column is the tick box called Ready_for_Triage so it wouldn't be 'Filter(Ideas_App_List,Ready_for_Triage=Ready_for_Triage.Value) ?

Was this reply helpful? Yes No
eka24 20,921 on at

Like (0)

Report

Re: Filtering gallery results

You must use somthing outside the gallery to filter. So you can insert a combobox on your screen and set the combobox item to: Ideas_App_List

Then change the Filter to:
Filter(Ideas_App_List,Ready_for_Triage=ComboboxName.Selected)
So whatever you select in the combobox will filter the Gallery

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
sutekh 509 on at

Like (0)

Report

Re: Filtering gallery results

Hi @eka24 first. Thanks for all your help today.

I've added a ComboBox called 'ComboBox2'.

I've typed in the formula:

Filter(Ideas_App_List,Ready_for_Triage=ComboBox2.Selected) and I'm getting an 'Invalid argument type' error?

Was this reply helpful? Yes No