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

All responses (12)

Answers (0)

Sort by

Ethan_009 4,840 Moderator on at

Like
a
(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
MDR26 on at

Like
a
(0)

Report
Copy link

Link copied!

@Ethan_R I tried this but still if a search a title the list is empty.
Ethan_009 4,840 Moderator on at

Like
a
(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?
MDR26 on at

Like
a
(0)

Report
Copy link

Link copied!

@Ethan_R
The datasource name is correct. I don't get an error.
Ethan_009 4,840 Moderator on at

Like
a
(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.
MDR26 on at

Like
a
(0)

Report
Copy link

Link copied!

Still no respons
timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@MDR26 - what data source are you using?
MDR26 on at

Like
a
(0)

Report
Copy link

Link copied!

@timl Sharepoint libary
timl 37,287 Super User 2026 Season 2 on at

Like
a
(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))
MDR26 on at

Like
a
(0)

Report
Copy link

Link copied!

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