Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Multiple Text Searches in One Gallery

(0) ShareShare
ReportReport
Posted on 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
    Pstork1 64,839 on at
    Re: Multiple Text Searches in One Gallery

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

  • amemartinez Profile Picture
    amemartinez 57 on at
    Re: Multiple Text Searches in One Gallery

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

  • amemartinez Profile Picture
    amemartinez 57 on at
    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
    Pstork1 64,839 on at
    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
    amemartinez 57 on at
    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
    Pstork1 64,839 on at
    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard