Answered

Filter a Gallery by "Does Not Contain" or "Not Like"

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a Gallery that is connected to a Sharepoint List, and it is filtering based on what is entered into TextInput1 text box. So far the Items property of the gallery is set to :

Sort(Filter('Computer Tracker',StartsWith(Owner_x0020_First_x0020_Name,TextInput1.Text)||StartsWith(Owner_x0020_Last_x0020_Name,TextInput1.Text)),ID,Descending)

This is working fine, but I also need to hide gallery entries whose Owner_x0020_First_x0020_Name field is "Discarded". The options I have tried have not worked. Can someone help with this formula?

Thanks,

Andy

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

CarlosFigueira Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
You can try the formula below:
SortByColumns( Filter( 'Computer Tracker', Owner_x0020_First_x0020_Name <> "Discarded", StartsWith(Owner_x0020_First_x0020_Name, TextInput1.Text) || StartsWith(Owner_x0020_Last_x0020_Name,TextInput1.Text)), ID, Descending)
In a Filter expression, you can pass multiple conditions, and it will only return those items that match all of the conditions.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks! That helped.

Was this reply helpful? Yes No