Unanswered

Multiple Text Searches in One Gallery

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Pstork1 68,858 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
amemartinez 57 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
amemartinez 57 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Pstork1 68,858 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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")

Was this reply helpful? Yes No
amemartinez 57 on at

Like (0)

Report
Copy link

Link copied!

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")))

Was this reply helpful? Yes No
Pstork1 68,858 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No