I am trying to filter out items with a status of "Pending Approval" from showing on the Browse Gallery screen, becuase I only want items with Status other than "Pending Approval" to show. I already have another screen to display items with a Status of "Pending Approval" and the filter I have on that screen that works is:
Filter('Request Production Change', DisplayStatus = "Pending Approval")
Below is what I have in my Items section of the BrowseScreen. Where would I add that syntax in the below to accomplish that?
SortByColumns(Filter('Request Production Change', StartsWith(Title, TextSearchBox1.Text)), "ID", If(SortDescending1, Descending, Descending))

Report
All responses (
Answers (