Help with Gallery Filtering

(0) Share

Report

Posted on by TomWright

I have the below code:

SortByColumns(Search('To Do List', TextSearchBox1.Text, "Title"), "ID", If(SortDescending1, Descending, Ascending))

I need the gallery not to display results from the sharepoint data sorce that comply with the status "Completed" Ive read a few other posts but struggling to mix the code in with mine. Tom

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

CarlosFigueira Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
You would use the Filter function in this scenario:
SortByColumns( Filter( Search('To Do List', TextSearchBox1.Text, "Title"), Completed = false), "ID", If(SortDescending1, Descending, Ascending))
Expressions in PowerApps can be nested, so in the example above you're filtering the result of the Search operation based on the condition that you want.

Was this reply helpful? Yes No
TomWright 9 on at

Like (0)

Report
Copy link

Link copied!

Hi Carlos,

Is it possible to only show items in the gallery were completed is false, before the search is run

Was this reply helpful? Yes No
CarlosFigueira Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Sure, both Search and Filter functions "filter" the rows that are returned by the data source, without changing its "shape", so their order can be flipped, and the results should be the same:
SortByColumns( Search( Filter('To Do List', Completed = false), TextSearchBox1.Text, "Title"), "ID", If(SortDescending1, Descending, Ascending))

Was this reply helpful? Yes No
TomWright 9 on at

Like (0)

Report
Copy link

Link copied!

Thanks, altough how does it know what colum to look in for the "Completed status"? This is the sharepoint form
No results are being retunred?

Thank you for your help, its much appreciated

Was this reply helpful? Yes No
Verified answer

CarlosFigueira Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Ah, if your sharepoint column is named "Status", and (it seems to be) of type choice, then the expression should reference that column name, something along the lines of
SortByColumns( Search( Filter('To Do List', Status.Value <> "Completed"), TextSearchBox1.Text, "Title"), "ID", If(SortDescending1, Descending, Ascending))

Was this reply helpful? Yes No