Adding a searchbox into canvas app

[crazor123]

Hello all,

I've read some articles about my subject, but i can't figure it out. 
I've added a TextSearchBox1 at the upper left (menu) -> If someone typ's here, I want the table to show his request.

The Datatable name is -> (it's in Dutch)

Columnnames are:
Materiaal
Lokaal - verdiep_Kolom1
Locatie_Kolom1
Artikelnr. SAP_Kolom1

Can someone assist me to get this working?

Friendly Regars

[SebS]

@crazor123 

Is there any error? I think it must have something to do with your column names can you do screen of your SharePoint column headers

Below table with 3 column search the same code

[SebS]

@crazor123 

I noticed the cause of the language before, I did not see You actually place the names of columns direct from data Table names, and You can't filter them I think this should work but when you provide me with a screen of Your column headers from SharePoint there will be no more issues

Filter('Inventaris SY7',

IsBlank(TextSearchBox1.Text) || IsEmpty(TextSearchBox1.Text) || 
        StartsWith(
            Title,
            TextSearchBox1.Text
        ) ||
        StartsWith(
            'Lokaal - verdiep',
            TextSearchBox1.Text
        ) ||
                StartsWith(
            Locatie,
            TextSearchBox1.Text
        ) ||
                        StartsWith(
            'Artikelnr.SAP',
            TextSearchBox1.Text
        )
)

so the reason it's failing is due to wrong column names in StartWith() functions

[crazor123]

Here is a Snip from my sharepoint list:

Here is the snip of the canvas itself:

I've watched your video and added the code to table FX, and now i have this.
(I edited the names below) i'll try a bit more, hopefully i can get it to work.

[SebS · Accepted solution]

@crazor123 

Make sure You remove _Kolom1 from all column names. You should not use names from the Data table. The columns what You are filtering are SharePoint columns.

Also, one of the columns Should be a Title column so remind Yourself which column you renamed from Title to something else. Power Apps will use the original name of the column, so If you renamed the Title, You still need to refer to it as Title. I would assume  Materiaal is the Orginal Title column, so in the code, you need to place their Title and rest remove _Kolom1

[crazor123]

Hi all,

I've managed to get my app working with the code from Sebs,
Filter(
'Inventaris SY7';
IsBlank(TextSearchBox1.Text) || IsEmpty(TextSearchBox1.Text) || StartsWith(
Title;
TextSearchBox1.Text
) || StartsWith(
Verdiep;
TextSearchBox1.Text
) || StartsWith(
Locatie;
TextSearchBox1.Text
) || StartsWith(
Artikelnr;
TextSearchBox1.Text
)
)

The minor frustration here is that it only shows the records that starts with my search, it doesnt show records that contains these words, is there a way around this?

Greetz