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 / search box in gallery ...
Power Apps
Unanswered

search box in gallery for sharepoint list with search columns

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

Hi, everybody

I have a problem creating a formula for a search box, I have columns that in the sharepoint list are search options in another list,

the search columns in the sharepoint list are 2 where one goes the code and this calls information of the name of the item

DanielGT89_0-1642605953880.png

I have seen that in the app it appears as ID and with value, but I cannot find the indicated formula so that when I want to search the text box for the name of the item

DanielGT89_1-1642606586826.png

DanielGT89_2-1642606605976.png

How can I make a search formula in a gallery for data in sharepoint search columns?

 

 

Categories:
Building Power Apps
I have the same question (0)
  • StalinPonnusamy Profile Picture
    StalinPonnusamy Super User 2024 Season 1 on at

    Hi @Anonymous 

     

    I assume you have text control to search. So set the Items property of the gallery to

    Filter(SPList,StartsWith(ColumnName,TextSearch.Text)

    I see you have a column name with space. 

    1. You need to find the correct name of the field
      1. Go to List Settings on the Sharepoint list
      2. Click the column
      3. On the address bar find the actual name
      4. StalinPonnusamy_0-1642610041015.png

         

    2. In general, we need to add "_x0020_" for space like Nombre_x0020_Material


    Thanks,
    Stalin - Learn To Illuminate

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

    hi, at the moment with all that I have tried I get an error

    • Invalid Argument Type (Record). Expecting a Text Value instead.

    DanielGT89_0-1642616454448.png

    I can't find the option to organize so that it shows me the items when I write in the text box

     

    column name

    DanielGT89_1-1642616869081.png

     

    tks

  • StalinPonnusamy Profile Picture
    StalinPonnusamy Super User 2024 Season 1 on at

    Hi @Anonymous 

     

    Looks like the column you are trying to search is not a string or text field. I assume it is a number field. Startwith works only with Text or string field type, so we need to convert the number field to text like below.

    Filter(
 AddColumns(IssueTracker, "NewID",Text(ID,"####")),
 StartsWith(
 NewID,
 TextSearchBox1.Text
 )
)

     

    In this example ID is a number or integer.

     

    Let me know if it;s different field type.


    Thanks,
    Stalin - Learn To Illuminate

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

    hi

    It was not possible

    I looked for a way to create a collection since it shows me the ID and Value of each one, of the income, but it was not possible

    I think that since I have more records it does not allow me

     

    tks

  • StalinPonnusamy Profile Picture
    StalinPonnusamy Super User 2024 Season 1 on at

    Hi @Anonymous 

     

    I want to make sure, we are not converting any field (to text) on the real data source. We need to convert to text only the fields that need to be searched on the fly (ad-hoc) while searching.

     

    Set the items property of the gallery to

    Filter(
 AddColumns(IssueTracker, "NewID",Text(ID,"####")),
 StartsWith(
 NewID,
 TextSearchBox1.Text
 )
)

    In the above example, We are filtering the gallery based on a search on a number field. AddColumns means adding columns while filtering.


    Thanks,
    Stalin - Learn To Illuminate

  • StalinPonnusamy Profile Picture
    StalinPonnusamy Super User 2024 Season 1 on at

    Hi @Anonymous 


    Please let us know if anything needs on your post. We can help with this.

    Please mark the post as Solved If I have answered your question.
    Please give it a Thumbs Up if you find the suggestion helpful

    Thanks,
    Stalin - Learn To Illuminate

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

    Hi, I can't find the way to do it

    I think that with the sharepoint list, its search columns and the amount of data it is not possible

    tks

     

  • StalinPonnusamy Profile Picture
    StalinPonnusamy Super User 2024 Season 1 on at

    Hi @Anonymous 

     

    Make sure to set items property of the gallery should be like this. Did you try this? Please share the output. I can guide you.

    Filter(
 AddColumns([@Ubicacion], "NewCodigo",Text(Codigo_x003a_Texto_x0020_breve_x,"####")),
 StartsWith(
 NewCodigo,
 TextSearchBox1.Text
 )
)

     


    Thanks,
    Stalin - Learn To Illuminate

  • StalinPonnusamy Profile Picture
    StalinPonnusamy Super User 2024 Season 1 on at

    Hi @Anonymous 


    Please let us know if anything needs on your post. We can help with this.

    Please mark the post as Solved If I have answered your question.
    Please give it a Thumbs Up if you find the suggestion helpful

    Thanks,
    Stalin - Learn To Illuminate

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 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

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