Unanswered

No results with filter

(0) Share

Report

Posted on by MDR26

Hello,

i have created a PowerApp with a searchbox. I've used the formula SortByColumns(Filter([@Namefile], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

I get no results if i try to search an item ? How can i solve this?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (0)

Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @MDR26 ,

Your formula indicates the presence of some text that needs to be found. If there's no text then it won't show All results.
If you need other values then use this else remove the added condition:
Sort( Filter( [@Namefile], (IsBlank(TextSearchBox1.Text) || StartsWith(Title, TextSearchBox1.Text)) ), Title, If(SortDescending1, SortOrder.Descending, SortOrder.Ascending) )
Hope this helps

Was this reply helpful? Yes No
MDR26 on at

Like (0)

Report
Copy link

Link copied!

@Ethan_R I tried this but still if a search a title the list is empty.

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @MDR26 ,

If you replace your datasource [@Namefile] to Namefile
Does this helps??
Make sure your datasource name is correct

Also, are you getting any error?

Was this reply helpful? Yes No
MDR26 on at

Like (0)

Report
Copy link

Link copied!

@Ethan_R
The datasource name is correct. I don't get an error.

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hmm @MDR26 ,

If everything is correct and you have data in the datasource.
Refresh the datasource within the App's data collection or Remove and re-add the datasource.
Once data is refreshed then it can show you data.

Try this once.

Was this reply helpful? Yes No
MDR26 on at

Like (0)

Report
Copy link

Link copied!

Still no respons

Was this reply helpful? Yes No
timl 36,634 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@MDR26 - what data source are you using?

Was this reply helpful? Yes No
MDR26 on at

Like (0)

Report
Copy link

Link copied!

@timl Sharepoint libary

Was this reply helpful? Yes No
timl 36,634 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@MDR26

If this is a SharePoint document library, 'Name' is the column that stores the document name. Perhaps you could try this instead.

SortByColumns(Filter([@Namefile], StartsWith(Name, TextSearchBox1.Text)), "Name", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

Was this reply helpful? Yes No
MDR26 on at

Like (0)

Report
Copy link

Link copied!

@timl If i change the title to the name of the column i get no items.

Was this reply helpful? Yes No