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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Search Gallery Using S...
Power Apps
Unanswered

Search Gallery Using SharePoint Lists as Data Source

(0) ShareShare
ReportReport
Posted on by 12

Can anyone help me with this formula - Search('PT78 Contacts', TextInput1.Text, "Company Name:")

The column I'm trying to search in my sharepoint list is labeled "Company Name:"

Categories:
I have the same question (0)
  • Verified answer
    Rajkumar_M Profile Picture
    3,741 Super User 2025 Season 2 on at

    Hi @Jaggerv 

     

    In PowerApps, the Search function is used to find records in a table that contain a string in one of their columns. The syntax is

    Search(source, text, column1 [, column2, … ]).

     

    In your case, you're searching in the 'PT78 Contacts' table, looking for TextInput1.Text in the "Company Name:" column. However, SharePoint columns often have internal names that are different from their display names. The internal name is set when the column is first created and can't be changed.

     

    If your formula isn't working, it's likely that "Company Name:" isn't the internal name of the column. You need to use the internal name of the column in your formula.

     

    To find the internal name of a SharePoint column, go to the List Settings, then click on the column name. In the URL, the internal name is displayed after 'Field='.

     

    Once you have the internal name, replace "Company Name:" with the internal name in your formula. For example, if the internal name is "CompanyName", your formula would be:

     

    Search('PT78 Contacts', TextInput1.Text, "CompanyName")


    Please replace "CompanyName" with the actual internal name of your column.

     

    Thanks!

     

    If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

  • Jaggerv Profile Picture
    12 on at

    That worked. Thanks for your help I appreciate it!

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard