Gallery Filter (contains)

(0) Share

Report

Posted on by da1vea

185

Hi all,

I am filtering a Gallery using the following:

If(
 IsBlank(txtSearch.Text),
 Filter(
 Jobs,
 Status.Value = galleryFilter.Text
 ),
 Filter(
 Jobs,
 //Status.Value = galleryFilter.Text &&
 (StartsWith(Title, txtSearch.Text) ||
 StartsWith(Contact, txtSearch.Text) ||
 StartsWith(Address, txtSearch.Text) ||
 StartsWith(AddressStreet, txtSearch.Text))
 )
)

So basically the gallery has a default filter based on the value in "galleryFilter". Then if text in entered into "txtSearch" then the second filter rule kicks in. The problem I am facing though is I would like to search the SharePoint list columns with any text not just the starting text.

So for example I would like to search for "extension" in Title or "Johnson" in Contact or maybe "abc.net" in Email

I don't believe there is a "contains" but that is effectively what I am after

Thanks,
David

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report
Hi @da1vea ,

You did not state your data source, so this may have Delegation issues

Filter( Jobs, Status.Value = galleryFilter.Text && ( Len(txtSearch.Text) = 0 || txtSearch.Text in Title ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
da1vea 185 on at

Like (0)

Report
Thanks @WarrenBelz ,

I did specify my source as a SharePoint list? So thanks for pointing me in the right direction, this is what I ended up with

If( IsBlank(txtSearch.Text), Filter( Jobs, Status.Value = galleryFilter.Text ), Filter( Jobs, Len(txtSearch.Text) = 0 || txtSearch.Text in Title || txtSearch.Text in Contact || txtSearch.Text in Address || txtSearch.Text in AddressStreet || txtSearch.Text in Email ) )

Thanks,
David

Was this reply helpful? Yes No
WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report
Hi @da1vea ,

Spotted that now (SharePoint) - you can get a bit more Delegation control with

With( { _Data: Filter( Jobs, Status.Value = galleryFilter.Text ) }, Search( _Data, txtSearch.Text, Title, Contact, Address, AddressStreet, EMail ) )

Depending on your location, you may need quotes "" around the fields at the bottom.

Was this reply helpful? Yes No