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.
Solved! Go to 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.
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.
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.
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.
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.
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.
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.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
199 | |
72 | |
50 | |
42 | |
30 |
User | Count |
---|---|
266 | |
121 | |
94 | |
90 | |
81 |