Filter By Exact Number

(0) Share

Report

Posted on by GiZmO

Hello All

I am displaying a SharePoint list in PowerApps. I have created two search boxes to filter the results.

The StartsWith function works great for the Title, however the filter results for Row_x0020_Number doesnt work for us.

If we filter "3" the results also show "31", "32" and so on.. If we search "3" we only want to display 3 not the others.

SortByColumns(Filter('tree import', StartsWith(Title, TextSearchBox1.Text)&& StartsWith(Row_x0020_Number, TextSearchBox1_1.Text)), "Title", If(SortDescending1, Descending, Ascending))

Any help would be appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

wyotim 2,545 on at

Like
a
(2)

Report
Copy link

Link copied!
I think the issue is in the StartsWith that you are using to compare Row_x0020_Number and TextSearchBox1_1.Text, which I believe is why you are getting items that start with 3.

Maybe try:

SortByColumns( Filter( 'tree import', StartsWith(Title, TextSearchBox1.Text) && Row_x0020_Number = Value(TextSearchBox1_1.Text) ), "Title", If(SortDescending1, Descending, Ascending) )

Was this reply helpful? Yes No
GiZmO 26 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you very much. That worked for me

Was this reply helpful? Yes No
wyotim 2,545 on at

Like
a
(0)

Report
Copy link

Link copied!

Happy to help out!

Was this reply helpful? Yes No