Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

No results with filter

Posted on by

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

  • MDR26 Profile Picture
    MDR26 on at
    Re: No results with filter

    Yes then I see the items

  • timl Profile Picture
    timl 32,058 on at
    Re: No results with filter

    @MDR26 - to confirm that the data source is returning data, if you leave out the call to filter, do you see any results?

    SortByColumns([@Namefile], "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))
  • MDR26 Profile Picture
    MDR26 on at
    Re: No results with filter

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

  • timl Profile Picture
    timl 32,058 on at
    Re: No results with filter

    @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 Profile Picture
    MDR26 on at
    Re: No results with filter

    @timl Sharepoint libary

     

  • timl Profile Picture
    timl 32,058 on at
    Re: No results with filter

    @MDR26 - what data source are you using?

  • MDR26 Profile Picture
    MDR26 on at
    Re: No results with filter

    Still no respons 

    MDR26_0-1687860059872.png

     

  • Ethan_009 Profile Picture
    Ethan_009 4,840 on at
    Re: No results with filter

    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 Profile Picture
    MDR26 on at
    Re: No results with filter

    @Ethan_R 

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

  • Ethan_009 Profile Picture
    Ethan_009 4,840 on at
    Re: No results with filter

    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?

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.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard