Do NOT show certain items in Gallery from SharePoint

(0) Share

Report

Posted on by 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.

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.
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"

)

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@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 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank You Randy! It never crossed my mind to use the visible property. Worked Great.
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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