Skip to main content

Notifications

Community site session details

Community site session details

Session Id : OXZbLHhqKhrhkqrifyKCtI
Power Apps - Building Power Apps
Unanswered

Multiple Text Searches in One Gallery

Like (0) ShareShare
ReportReport
Posted on 14 Jun 2022 14:54:44 by 57

Good Morning, I need to text search on one text field and then I need to text search on a 2nd text field using the results of the 1st search and finally I need to text search on a 3rd text field using the results of the 2nd results.

I am very new to PowerApps, as in this is my first time creating a PowerApps.

A YouTuber said I need to stitch multiple functions together. Example filter (filter( but I have no idea how to do this. Are there any good videos that show you how to do what I need to do? I desperately need help, my project is due in 2 weeks, and this is my biggest hurdle. 

Thank you.

  • Pstork1 Profile Picture
    65,369 Most Valuable Professional on 14 Jun 2022 at 21:14:42
    Re: Multiple Text Searches in One Gallery

    The Search should be in the Items field, not the default field.

  • amemartinez Profile Picture
    57 on 14 Jun 2022 at 18:46:02
    Re: Multiple Text Searches in One Gallery

    Does this look right or no? Thank you for your help.

  • amemartinez Profile Picture
    57 on 14 Jun 2022 at 18:42:10
    Re: Multiple Text Searches in One Gallery

    So I did that but there is a red squiggly line under the whole formula now and all of my data from my data cards has been removed. For the Gallery under advanced the formula is in the Items field where just the data source used to be in there. Do I move the data source to the default field and leave the formula in the items field? Why is the red squiggly under the formula? I am using a fairly large (but less than 2000 entries) SharePoint List as my data source.  Gosh I feel like I am so close.

  • Pstork1 Profile Picture
    65,369 Most Valuable Professional on 14 Jun 2022 at 17:48:47
    Re: Multiple Text Searches in One Gallery

    It will look like that, but your closing parentheses are in the wrong place. Formatting was added to make it more readable.

    Search( 
     Search(
     Search(TransportationProviders,txtStateFilter.Text,"State"),
     TransportationProviders,txtCountyFilter.Text,"County"),
    TransportationProviders,txtZipCodeFilter.Text,"ZIP")

     

  • amemartinez Profile Picture
    57 on 14 Jun 2022 at 15:50:57
    Re: Multiple Text Searches in One Gallery

    Would it look something like this? Although this formula is not working. I am trying to search on State, then from those results search on County and then from those results search on Zip to get my results. This is what I used I thought it would work but it is not. TransportationProviders is my sharepoint data source.

    Search(Search(Search(TransportationProviders,txtStateFilter.Text,"State",TransportationProviders,txtCountyFilter.Text,"County",TransportationProviders,txtZipCodeFilter.Text,"ZIP")))

  • Pstork1 Profile Picture
    65,369 Most Valuable Professional on 14 Jun 2022 at 15:12:58
    Re: Multiple Text Searches in One Gallery

    You can nest Search() inside other Searches. The only thing to be careful of is that Search isn't delegable in some of the data sources. So if your innermost Search() is on a large data set you might not get all the results you are looking for.

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

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

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

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,369 Most Valuable Professional

Leaderboard
Loading started
Loading complete