web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter/Search Function...
Power Apps
Unanswered

Filter/Search Function SharePoint List

(0) ShareShare
ReportReport
Posted on by rafaelbenicio 61

Hi Everyone, 

 

I'm sorry for a possible duplicate post but none of the solutions I've found over here worked for me. I'm trying to have a simple search bar field that searches for some request types from my sharepoint list. Thanks for stopping by and trying to help me out. 

 

Here are some of the screenshoots so then you can have a better understanding of my case. Thanks! 

 

Overview from my applicationOverview from my application

 

Error Description on PowerAppsError Description on PowerAppsOverview from my applicationOverview from my applicationError Description on PowerAppsError Description on PowerApps

Categories:
Building Power Apps
I have the same question (0)
  • tchin-nin Profile Picture
    tchin-nin 779 on at

    Hi

     

    Your filter second argument must be a condition : 

     

    Filter(<DataSource>, TextSearchBox1.Text in Title1)

     

    Théo

  • rafaelbenicio Profile Picture
    rafaelbenicio 61 on at

    Hi @tchin-nin

     

    Thanks for posting but unfortunately your condition didn't work.

     

     Screen Shot 2018-10-02 at 5.51.20 PM.pngScreen Shot 2018-10-02 at 5.51.09 PM.png

    Screen Shot 2018-10-02 at 5.51.30 PM.png

    Screen Shot 2018-10-02 at 5.51.44 PM.png

  • tchin-nin Profile Picture
    tchin-nin 779 on at

    Hi,

    You have to put the formula I gave you into the Items property of the gallery. 

     

    The textbox default property is the default text value inside the textbox. 

    The Items property if a gallery define which items are displayed. So this is where you have to do the filter. 

     

    Théo

  • rafaelbenicio Profile Picture
    rafaelbenicio 61 on at

    Sorry @tchin-nin

     Are you talking about this? If yes, it didnt work. Screen Shot 2018-10-03 at 10.04.55 PM.png

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi @rafaelbenicio

    I would try this Filter('Leave Request', '<name of field in SharePoint list>' in TextSearchBox1.Text)..

     

    The current formula seems to be searching within the app when it needs to be searching the actual Sharepoint datasource.

     

    With that being said I would highly recommend you stay away from "in" when using SharePoint as it isnt delegable. More information on that here. My recommendation would be to download them into a collection perhaps using a filtered formula and then use the "in".. This should work much quicker.. 

     

    All the best!

  • tchin-nin Profile Picture
    tchin-nin 779 on at
    Hi,

    Downloading the data into a collection doesn't avoid the delegation issue since the local collection will only contains the first 500 items of the DataSource.

    Does your DataSource actually have a column named Title1 ? You have to filter against a column of your SharePoint list.

    Théo
  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    @tchin-nin yup you're right it isnt.. My apologies, @rafaelbenicio.. Forgot to mention that you should collect the data using a formula that is delegable..

     

    Thanks @tchin-nin!

  • tchin-nin Profile Picture
    tchin-nin 779 on at
    But you're right to talk about delegation for sure !
    This is a major issue when working with SharePoint, the only delegatable operator is "=" so the filtering options are limited. Also all complex column types (choices / lookup) aren't delegatable either.

    Théo
  • rafaelbenicio Profile Picture
    rafaelbenicio 61 on at

    oh I see! If I understoood correctly, it won't work since the field I'm trying to filter is a lookup field in Sharepoint. 

     

    Thanks! 

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at
    Hi
    Not necessarily to be honest. SharePoint has certain delegable types. "=" Is the best in my opinion, but since the lookup field is a complex field that consists of an ID and a VALUE it requires extra attributes.

    However if you would like to filter a lookup field it would most likely be something like
    Filter(SharePointList, SharePointLookupField.Value = SearchTextBlx1.Text)...Something to that extent.

    Hope it helps

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 549 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 225 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 224

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans