Dropdowns in combination with Search with IN (contains)

[ArtHavenShelter]

Hi, 
I have the following script for my PowerApp. Problem is that I'd rather not use Startswith but In or something with contains if thats available. The filter is based on a search field where you can either search for "Auteur" or "Title". The filter and search function also makes use of 2 dropdownboxes. 

I am new to Powerapps and don't know what to do. Below script I figured out with other video's but can't find the solution for this one. Please assist! Thanks. 

Filter('De bieb',
    (StartsWith
            (Auteur,
            Zoeken.Text
            ) || StartsWith(
                Title, 
                Zoeken.Text
    )) && (Doelgroep.Value = Dropdown1.Selected.Value || Dropdown1.Selected.Value = Blank())
     && (Categorie.Value = Dropdown2.Selected.Value || Dropdown2.Selected.Value = Blank())
)

[HenriDesmet59]

Hello @ArtHavenShelter ,

For the search part you can use the "Search" function. 

You can put in around your Filter, who will be the DataSource, and then you can tell the Search which column to search : 

Search(
Filter(....)
,TextBox.text,"Auteur","Title")

Tell me if It's works 🙂

Henri

[ArtHavenShelter]

Thanks! Will try this out. I assume this way you can search parts of the text?

Kind regards!

[HenriDesmet59]

Sorry, but what did you mean with "part of the text" ?

[EdViegas]

Yes.. but consider that function Search is not delegable in SharePoint. 

SharePoint - Connectors | Microsoft Docs

[ArtHavenShelter]

Hi, just tried the following:

Filter('De bieb',
    (Search(
        Filter('De bieb'),Zoeken.Text,Auteur,Title)
    )) && (Doelgroep.Value = Dropdown1.Selected.Value || Dropdown1.Selected.Value = Blank())
     && (Categorie.Value = Dropdown2.Selected.Value || Dropdown2.Selected.Value = Blank())
)

ending up with nothing to show but red crosses 🙂 

Sure I am doing something wrong or forgetting something important.

[ArtHavenShelter]

Sorry, my screen did not update.
So if you have an Author named: P.J. Dickenson Roland. It would be great if I can search on nson, land, Rol, P.J.

[ArtHavenShelter]

it's a small db so I think it will work out.

[HenriDesmet59]

Try putting the search outside the filter : 

Search(
Filter(....)
,TextBox.text,"Auteur","Title")

The filter will be the datasource, and put your 2 combobox filter inside it 

[ArtHavenShelter]

I think you mean this? It didn't work out. Again, I am new into this. So thanks for your patience.

Search(
Filter('De bieb',
        (Doelgroep.Value = Dropdown1.Selected.Value || Dropdown1.Selected.Value = Blank())
     && (Categorie.Value = Dropdown2.Selected.Value || Dropdown2.Selected.Value = Blank())
)
,Zoekveld.text,"Auteur","Title"
)