Unanswered

Would like to search using contains instead of StartWith()

(0) Share

Report

Posted on by NAV1

Would like to change Startwith to contain but cant figure out the formula. Here's what I have

SortByColumns(Filter([@'Issue tracker'],StartsWith('Issue description', TextSearchBox1.Text)), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

mmollet 3,187 on at

Like (0)

Report
Copy link

Link copied!

You could try the In function but this will cause you delegation issues.

Was this reply helpful? Yes No
NAV1 7 on at

Like (0)

Report
Copy link

Link copied!

I've tried the In function but it doesnt allow me to search anything. For exmaple with this SortByColumns(Filter([@'Issue tracker'],StartsWith('Issue description', TextSearchBox1.Text)), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending)) it shows the following
When I try the In function SortByColumns(Filter([@'Issue tracker'],In('Issue description', TextSearchBox1.Text)), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending)) it shows the following the inputs disappear and gives me an error

Was this reply helpful? Yes No
mmollet 3,187 on at

Like (0)

Report
Copy link

Link copied!

It is used in a slightly different way that most funcitons. This is used in the same was And/Or is used. So to see if Textinput1.Text is in User().FullName this would be the code:
If(Textinput1.Text In User().FullName, true, false) <- correct
rather than...
If(In(Textinput1.Text, User().FullName), true, false)<- incorrect

Was this reply helpful? Yes No
NAV1 7 on at

Like (0)

Report
Copy link

Link copied!

I need to look up in Issue Description so would this be the formula?
SortByColumns(Filter([@'Issue tracker'],If( TextSearchBox1.Text in User().Incident Description,true,false)), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

Was this reply helpful? Yes No
NAV1 7 on at

Like (0)

Report
Copy link

Link copied!

I need to look up in Issue Description so would this be the formula?
SortByColumns(Filter([@'Issue tracker'],If( TextSearchBox1.Text in User().Incident Description,true,false)), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

Was this reply helpful? Yes No
mmollet 3,187 on at

Like (0)

Report
Copy link

Link copied!

Yes, however, I believe 'in' will have to be capitalized as well for syntax. Other than that I think that should work. I am not able to test it myself atm.

Was this reply helpful? Yes No