Do NOT show certain items in Gallery from SharePoint

[mchaney]

Hello

I managed to build this app by watching countless YouTube videos. However my skills are limited and I’m trying to do the following. Really could use your help.

I need to add code that will NOT display specific items in the gallery.

1. The first item is a text field from SharePoint that will always be Green OK. If Green OK on SharePoint do not display in the Gallery.
2. Status is a choice field on SharePoint.  If Status is CLOSED do not display in the Gallery.

I’ve tried several ways but I crash the gallery. Any help is truly appreciated.

Gallery ITEMS code is as follows. This currently works to generate the gallery (see attachment)

Search (

Filter ('ESW Repair Tracker ETT',

(Ownership.Value = cbRepairFilter.Selected.Value Or If(cbRepairFilter.Selected.Value = "- Select -",

true,false)) 

And (Status.Value = cbStatusFilter.Selected.Value Or If(cbStatusFilter.Selected.Value = "- Select -",true,false))),

txtNameFilter.Text,

    "Title"

)

[RandyHayes · Accepted solution]

@mchaney 

Set the Visible property of your Datacard in your form to resolve this.

Example, on your Status Datacard Visible property:

ThisItem.Status.Value <> "Closed"

I hope this is helpful for you.

[mchaney]

Thank You Randy!   It never crossed my mind to use the visible property. Worked Great. 

[v-xiaochen-msft]

Hi @mchaney ,

Glad to see your problem have been solved !

You could mark @RandyHayes 's reply as a solution to close this case.

Best Regards,

Wearsky