Unanswered

Multiple Text Searches in One Gallery

Like (0) Share

Report

Posted on 14 Jun 2022 14:54:44 by amemartinez

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.

Categories:

Using Apps Using Formulas

All responses (6)

Answers (0)

Pstork1 65,369 Most Valuable Professional on 14 Jun 2022 at 21:14:42

Like (0)

Report

Re: Multiple Text Searches in One Gallery

The Search should be in the Items field, not the default field.
amemartinez 57 on 14 Jun 2022 at 18:46:02

Like (0)

Report

Re: Multiple Text Searches in One Gallery

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

Capture.JPG
amemartinez 57 on 14 Jun 2022 at 18:42:10

Like (0)

Report

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 65,369 Most Valuable Professional on 14 Jun 2022 at 17:48:47

Like (0)

Report
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 57 on 14 Jun 2022 at 15:50:57

Like (0)

Report

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 65,369 Most Valuable Professional on 14 Jun 2022 at 15:12:58

Like (1)

Report

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.