Answered

Adding a searchbox into canvas app

(0) Share

Report

Posted on by 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

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (1)

SebS 4,616 Moderator on at

Like (1)

Report
Hi@crazor123

Replace the code in Your data table property Items with the below. Make sure You replace in the code "DataSource" with the name of the SharePoint List that populating this Data table

Filter("DataSource", IsBlank(TextSearchBox1.Text) || IsEmpty(TextSearchBox1.Text) || StartsWith( Materiaal, TextSearchBox1.Text ) || StartsWith( 'Lokaal - verdiep_Kolom1', TextSearchBox1.Text ) || StartsWith( Locatie_Kolom1, TextSearchBox1.Text ) || StartsWith( 'Artikelnr. SAP_Kolom1', TextSearchBox1.Text ) )

This will search base on whatever user Start typing and it's Delegable so when your data will grow it will not cause any issue only limitation is when someon know only middle or end of whatever they looking for.

double check if all columns names are correct if not just correct them

Was this reply helpful? Yes No
crazor123 52 on at

Like (0)

Report

Hello @SebS ,

Thx for the help & code. I've checked the code but still it isnt working.
Am I adding it correctly? in the FX bar?

Friendly Regards

Was this reply helpful? Yes No
SebS 4,616 Moderator on at

Like (1)

Report
@crazor123

you missing ) at end

Filter("DataSource", IsBlank(TextSearchBox1.Text) || IsEmpty(TextSearchBox1.Text) || StartsWith( Materiaal, TextSearchBox1.Text ) || StartsWith( 'Lokaal - verdiep_Kolom1', TextSearchBox1.Text ) || StartsWith( Locatie_Kolom1, TextSearchBox1.Text ) || StartsWith( 'Artikelnr. SAP_Kolom1', TextSearchBox1.Text ) ) <----

and if You get an error please let me know what it say

Was this reply helpful? Yes No
SebS 4,616 Moderator on at

Like (1)

Report

@crazor123

Do your SharePoint List is called "datatabel" ?

Was this reply helpful? Yes No
crazor123 52 on at

Like (0)

Report

The Sharepoint list name is

The name in the app is:

I will try different names and see what comes up, i'll give u a thumb for the help already.
I need some more experiences in this stuff.

Thx for the help already and happy holidays

Was this reply helpful? Yes No
SebS 4,616 Moderator on at

Like (0)

Report
@crazor123

Please use the code below the name of Your Data Source is 'Inventaris SY7' at last that's what your Item property showing and that is what You need to use where I ppointed to "Data Source"

Try this code and make sure you copy everything

Filter('Inventaris SY7', IsBlank(TextSearchBox1.Text) || IsEmpty(TextSearchBox1.Text) || StartsWith( Materiaal, TextSearchBox1.Text ) || StartsWith( 'Lokaal - verdiep_Kolom1', TextSearchBox1.Text ) || StartsWith( Locatie_Kolom1, TextSearchBox1.Text ) || StartsWith( 'Artikelnr. SAP_Kolom1', TextSearchBox1.Text ) )

Was this reply helpful? Yes No
crazor123 52 on at

Like (0)

Report

I double checked everything, it keeps saying there is an error in the formula.
(Its in Dutch, try to modify the formula)

Was this reply helpful? Yes No
SebS 4,616 Moderator on at

Like (1)

Report

@crazor123

Try to put InventarisSY7 instead or show in what line the error happens, the only thing that can make an error there will be the wrong data source name or wrong column name columns that need to be named the same as in SharePoint when they were created.

in the moment when you start writing Inventories IntelliSense of formula bar will point out to right name for data source it's same for the columns when you think the name of the column is wrong start writing it names and you will see intelisense start pointing to the right one that will help you to correct any code with right names

Was this reply helpful? Yes No
crazor123 52 on at

Like (0)

Report

I'm going to make a ticket for the local IT department, can't get it to work, thankyou for your time and help, as soon as I hear from them i'll place the solution/correction here.

Grtz

Was this reply helpful? Yes No
SebS 4,616 Moderator on at

Like (1)

Report

@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

Was this reply helpful? Yes No