I am trying to design a form that has three search boxes based on my 'TicketGallery'. I have one search box working with the following:
Search(TestMaterialDetail, SearchBoxTestMaterial.Text, "Title") but I have added two more text input boxes and called them 'SearchBoxBatch' and 'SearchBoxStudyNumber' and I would like these to return the values based on the Sharepoint columns with the same name. However it does not seem to like various lookups - I have tried the following amoungst others but with no success (using both a comma and semi-colon in between the search options).
Search(TestMaterialDetail, SearchBoxTestMaterial. Text, "Title"), Search(TestMaterialDetail, SearchBoxBatch. Text, "Batch"); Search(TestMaterialDetail, SearchBoxStudyNumber. Text, "StudyNumber")
Does anyone know if numerous search options are available as a function and if so, the correct formula.
Solved! Go to Solution.
Just additional info.
I wrote blog about multiple search condition using Search() and Filter().
If you would encounter similar problem, please see above post 🙂
This all makes sense, But I'm very new to Powerapps and not sure what I should be clicked on when I enter the formula (or where to entre this formula).
I have attached an image so you can help me 🙂
Check out these cool Power Apps & vote on your favorite!
Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!