cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Browse Gallery filtering not working with choise field

Hello guys,

 

I have a power app that works in the search bar adding an ID and that part is working properly. However, i want to show as default (When the search box is blank) my logs status.

 

This is the formula that i am using for the searchbox:
SortByColumns(Filter([@'Queries'], 'ID'=Value( TextSearchBox1.Text)),"Title", If(SortDescending1, Descending, Ascending))

My column of status is called Status and is a choice variable with 3 options Open Solved or Inconclusive.

 

Thanks for any help

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
mdevaney
Super User
Super User

@Anonymous 
To show everything when the searchbox is blank use this code in the Items property of your gallery.

SortByColumns(
    Filter(
        [@'Queries'],
        TextSearchBox1.Text=Blank() Or 'ID'=Value(TextSearchBox1.Text)
    ),
    "Title",
    If(SortDescending1, Descending, Ascending)
)

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

1 REPLY 1
mdevaney
Super User
Super User

@Anonymous 
To show everything when the searchbox is blank use this code in the Items property of your gallery.

SortByColumns(
    Filter(
        [@'Queries'],
        TextSearchBox1.Text=Blank() Or 'ID'=Value(TextSearchBox1.Text)
    ),
    "Title",
    If(SortDescending1, Descending, Ascending)
)

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,988)