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.
The Search should be in the Items field, not the default field.
Does this look right or no? Thank you for your help.
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.
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")
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")))
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.