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

Community site session details

Session Id : FPDUT2lLeYcB/vN011AiqV
Power Apps - Building Power Apps
Answered

.text error in search not accepted

Like (1) ShareShare
ReportReport
Posted on 15 Jul 2024 17:07:53 by 49

Hi, 

Where the .text in the search formula comes from? What do I have to do for it to be accepted?

Have tried 100 times, different ways and even replaced search by filter but nothing works. My gallery data goes blank and nothing happens. 

When I'm entering the formula,  the .text does not come up so, I have tried changing it to .Value, which shows less errors but still...

Could it be that data source table from sharepoint has fields with different types such as number, choice,  etc? Although my 3 selected fields are all text. Please help and thank you beforehand. 

  • Verified answer
    ANB Profile Picture
    7,162 Super User 2025 Season 2 on 15 Jul 2024 at 18:05:14
    Re: .text error in search not accepted

    @Kellyrsv I am glad that it helped you. Please make sure to accepted my suggestion as solution . This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

    Thanks,
    ANB


  • Verified answer
    Kellyrsv Profile Picture
    49 on 15 Jul 2024 at 18:02:05
    Re: .text error in search not accepted

    Thank you ANB, spot on, I'm using modern input control. It worked now so thanks heaps

  • Verified answer
    ANB Profile Picture
    7,162 Super User 2025 Season 2 on 15 Jul 2024 at 17:36:18
    Re: .text error in search not accepted

    HI @Kellyrsv , The Syntax of Search is :

    Search(Customers, SearchInput.Text, Name)

     

    Now depending upon whether you are using modern text input control then it will be .Value and if you are using classic control then the it will be .text.

     

    For Choice column the code will be little different:

     

    Search(
     AddColumns('My SharePoint List', "ChoiceValue", Choice.Value),
     SearchInput.Text,
     "ChoiceValue"
     )

     

    -----------------------------------------------------------------------------------------------------------------------------

    I hope this helps.

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

    Thanks,
    ANB


  • CodyO Profile Picture
    391 on 15 Jul 2024 at 17:30:48
    Re: .text error in search not accepted

    Hi @Kellyrsv, If I am understanding correctly, you are looking to be able to search in a gallery, is this correct?
    The way I have achieved this is by doing the following. 

    1. I created a gallery connected to my data source,
    2. I then created a text input called "ti_MaterialLookup_SearchBar"

    In my gallery Items field, I put the following. Notice that I am searching my data source, based off the text input. At the end of the input make sure you have .Text, then reference the column you are wanting to search.

    Search('Conex - Chevron', ti_MaterialLookup_SearchBar.Text, Title)


    I hope this 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

Quick Links

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Loading complete