sharepoint search function not working.

[sahim]

Good Morning. 

I am having a problem with the function. When i enter it. I cannot see the gallery. 

SortByColumns(StartsWith([@'List of Top Ducab Materials'],TextSearchBox1.Text, "Group Description","Material"),"Group Description" If(SortDescending1, Descending, Ascending))

My requirement is to be able to search with 3 functions. 

Group Description

Material Description

Material 

Also i want to link 2 galleries with each other. 

1st gallery, Group Description

2nd gallery; list of materials in group

Then details. 

How to configure it. 

Thanks. for your help. 

[KrishnaV]

Hi @sahim ,

Try the below:

SortByColumns(Filter( datasource, StartsWith( textSearchBox1.text, "Group Description" ) || StartsWith( textSearchBox1.text, "Material") || StartsWith( textSearchBox1.text, "Material Description" )),If(SortDescending1, Descending, Ascending))

 
I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

[sahim]

Hi,

I tried this 

SortByColumns(Filter([@'List of Top Ducab Materials'], StartsWith('Material Description', TextSearchBox1_1.Text)), "Title", If(SortDescending1, Descending, Ascending))

It is working, but i cannot search. 

[KrishnaV]

Hi @sahim ,

What do you mean by I can't search? could you please elaborate more?

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

[sahim]

The gallery has Title, Subtitle and Body, 

SortByColumns(Filter([@'List of Top Ducab Materials'], StartsWith('Material Description', TextSearchBox1_1.Text)), "Title", If(SortDescending1, Descending, Ascending))

With this code above, The data from sharepoint is showing in the gallery.

But when i try to search (see screenshot)

This is a valid "material"

But the search result is not showing. 

Thanks for your help. 

[sahim]

Just to elaborate. 

The items function is:

SortByColumns(Filter([@'List of Top Ducab Materials'], StartsWith('Material Description',TextSearchBox1.Text)), "Material", If(SortDescending1,Ascending,Descending))

The gallery has 3 inputs.

Group Description - text

Material - numbers only.

Material Description -text

My requirement is to be able to search within all 3 inputs of gallery to narrow down the result. 

I need help to write the code that can search for all functions. 

Thanks. 

[KrishnaV · Accepted solution]

Hi @sahim,
try this:

SortByColumns(Filter([@SampleList], StartsWith('Group Desciption', TextSearchBox1.Text)|| StartsWith(Text(Material),TextSearchBox1.Text) || StartsWith('Material Description',TextSearchBox1.Text)), "Material", If(SortDescending1, Descending, Ascending))

I have tested this and working as expected.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.