Announcements
Hi
i have a couple columns that i need have serchable
code today:
SortByColumns(Filter(Helpdesk; StartsWith(Title; TextSearchBox1.Text)); "ID";TextSearchBox1.Text)); "Status"; " "column1" "column2" "column3"If(SortDescending1; Descending; Ascending))
but this doen t work iget a red cross
Regards
Tommy
If you want to search through all of those columns, you can use the following expression:
SortByColumns( Filter( Helpdesk; StartsWith(Title; TextSearchBox1.Text) Or StartsWith(ID"; TextSearchBox1.Text) Or StartsWith(Status; TextSearchBox1.Text) Or StartsWith(column1; TextSearchBox1.Text) Or StartsWith(column2; TextSearchBox1.Text) Or StartsWith(column3; TextSearchBox1.Text)); "ID"; If(SortDescending1; Descending; Ascending))
This will filter based on the text search box for any of the given columns, and the result of the filter will be sorted (in this case, based on the "ID" column, but you can change it to another column.
Hi CarlosFigueira
thanks for you help but seems i get an red cross here with tihs
SortByColumns(
Filter(
Helpdesk;
StartsWith(Title; TextSearchBox1.Text) Or
StartsWith(ID; TextSearchBox1.Text) Or
StartsWith(Status; TextSearchBox1.Text) Or
StartsWith(Butiksnamn; TextSearchBox1.Text) Or
StartsWith(Kontorsdator; TextSearchBox1.Text) Or
StartsWith(Skrivare; TextSearchBox1.Text));
"ID";
If(SortDescending1; Descending; Ascending)
best regards
Hi Tommy,
Are some columns lookup or choice types?
Hi Drrickryp
is just simple lookup columns
/tommy
Which ones?
Status
ID
Butiksnamn
Kontorsdator
Skrivare
is this loumns from my sharepoint list helpdesk
The problem is that Sharepoint lookup columns are actually tables with an ID and Value column. When you want to reference them, you need to use either the ID or Value property. I suggest the following:
SortByColumns( Filter( Helpdesk; TextSearchBox1.Text in Title || TextSearchBox1.Text in Status.Value || TextSearchBox1.Text in Butiksnamn.Value || TextSearchBox1.Text in Kontorsdator.Value || TextSearchBox1.Text in Skrivare.Value); "ID"; If(SortDescending1; Descending; Ascending)
Let me know if that works for you. In the example, I set the gallery Items property to Filter(Products, TextInput2.Text in Product_x0020_Name || TextInput2.Text in Category.Value) and as you can see, all the items in the gallery have either "be" in the Category or Product name. Category is a Sharepoint Lookup type field.
I believe that you could also use @CarlosFigueira's design but modified for the Lookup column types but I haven't tested this.
SortByColumns( Filter( Helpdesk; StartsWith(Title; TextSearchBox1.Text) Or StartsWith(ID.Value; TextSearchBox1.Text) Or StartsWith(Status.Value; TextSearchBox1.Text) Or StartsWith(Butiksnamn.Value; TextSearchBox1.Text) Or StartsWith(Kontorsdator.Value; TextSearchBox1.Text) Or StartsWith(Skrivare.Value; TextSearchBox1.Text)); "ID"; If(SortDescending1; Descending; Ascending)
hi Drrickkryp
here i s the results
What does the gallery look like without the filter? Just with the items of the gallery set to SortByColumns(HelpDesk;"ID"; If(SortDescending1; Descending; Ascending)).
If it looks good, try applying each filter one by one until you find out which ones give you an error.
Filter(SortByColumns(HelpDesk;"ID"; If(SortDescending1; Descending; Ascending));StartsWith(Title; TextSearchBox1.Text)) , then try Filter(SortByColumns(HelpDesk;"ID"; If(SortDescending1; Descending; Ascending));StartsWith(Status.Value; TextSearchBox1.Text)) etc.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 345 Most Valuable Professional
11manish 207 Super User 2026 Season 2
Mohsin Ali 177
