cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
peterstylias
Helper I
Helper I

Hide a record in a gallery

My datasource is an excel file.  I have records being displayed in a gallery.  Each record has a "Status" column either Open or Closed.   I want to hide record(s) in the gallery if the "Status" column value is "Closed".  Right now, this is what is on my Items property:

SortByColumns(
Search(
[@LogTable],
TextSearchBox1.Text,
"DetailedDescription",
"FunctionalArea",
"Submittedby",
"ShortTitle",
"Status"
),
"Submittedby",
If(
SortDescending1,
Descending,
Ascending
)
)

 

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Sorry for all the back and forth, I've been doing this freetext without building a test in PowerApps itself. I see another error in my code. Try this:

SortByColumns(
Search(
Filter([@LogTable],Status="Open"),
TextSearchBox1.Text,
"DetailedDescription",
"FunctionalArea",
"Submittedby",
"ShortTitle",
"Status"
)
,"Submittedby",
If(
SortDescending1,
Descending,
Ascending
)
)

View solution in original post

10 REPLIES 10
Anonymous
Not applicable

You'll just need to add a filter.

 

SortByColumns(
Filter(
Search(
[@LogTable],
TextSearchBox1.Text,
"DetailedDescription",
"FunctionalArea",
"Submittedby",
"ShortTitle",
"Status"
),
"Submittedby",
If(
SortDescending1,
Descending,
Ascending
)
,Status,"Open")
)

 

@Anonymous, did that and gave me bunch of errors.  Please see attached.

Anonymous
Not applicable

I see. The SortByColumns arguments got shifted when I was typing it out. Try this

SortByColumns(
Filter(
Search(
[@LogTable],
TextSearchBox1.Text,
"DetailedDescription",
"FunctionalArea",
"Submittedby",
"ShortTitle",
"Status"
)
,Status,"Open")
,"Submittedby",
If(
SortDescending1,
Descending,
Ascending
)
)

@Anonymous, no error now but gallery is blank and giving me a triangular exclamation Warning: This predicate is a literal value and does not reference the input table.

Anonymous
Not applicable

Maybe we need to flip the Search and Filter functions. Try this:

SortByColumns(
Search(
Filter([@LogTable],Status,"Open"),
TextSearchBox1.Text,
"DetailedDescription",
"FunctionalArea",
"Submittedby",
"ShortTitle",
"Status"
)
,"Submittedby",
If(
SortDescending1,
Descending,
Ascending
)
)

@Anonymous, still the same warning and still blank.

Anonymous
Not applicable

Sorry for all the back and forth, I've been doing this freetext without building a test in PowerApps itself. I see another error in my code. Try this:

SortByColumns(
Search(
Filter([@LogTable],Status="Open"),
TextSearchBox1.Text,
"DetailedDescription",
"FunctionalArea",
"Submittedby",
"ShortTitle",
"Status"
)
,"Submittedby",
If(
SortDescending1,
Descending,
Ascending
)
)

@Anonymous, that resolves all the errors now.  appreciate your time looking into this.

I would use this,

SortByColumns(
Search(
Filter([@LogTable],Status <> "Closed"),
TextSearchBox1.Text,
"DetailedDescription",
"FunctionalArea",
"Submittedby",
"ShortTitle",
"Status"
)
,"Submittedby",
If(
SortDescending1,
Descending,
Ascending
)
)

In case you have other statuses.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (5,040)