Unanswered

How to display only active items in a gallery

(0) Share

Report

Posted on by Spawn10

301

I have a gallery that I am using to display data that's in a SharePoint list. I was also able to add a search box to my gallery, so that I am able to search the content within the gallery. These seem to be working just fine. In the items of my gallery, I have this logic....

Search([@myList], SearchInput.Text, "Title", "Title")

The SharePoint list has a Yes/No column that is used to flag if an item is active or not. How do I filter this to only display items that are still active, without losing my search functionality?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,032 Most Valuable Professional on at

Like (1)

Report
Hi @Spawn10 ,

Firstly you do not need Title in there twice and assuming your Yes/No column is called Active

Search( Filter( [@myList], Active ), SearchInput.Text, "Title" )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Spawn10 301 on at

Like (0)

Report

Thanks a million....I definitely got my wires crossed on that logic.

Was this reply helpful? Yes No