Hi, I'm building an app that will eventually be a searchable databse of undergraduate theses. At the moment I'm using the template provided by powerapps which is actually very similar to the style of databse I had envisaged.
I'm having an issue with the search box. Ideally I would like to be able to enter multiple search terms seperated by a comma or even just a space which returns all cases that contain these terms. The search function I have come up with based on information in these forums is:
"Year", If(SortDescending1, Descending, Ascending))
When I enter a term like "biofilm" in the box it searches the columns "Abstract","Author","Supervisor(s)" and "Project Title" and returns any case containing the word biofilm in these 4 columns.
This is great but ideally I would like to be able to enter multiple search terms in the text box, for example "biofilm", "Smith", "ecotoxicology" to return any cases which contain these three words. Is this possible to do in Powerapps? At the moment if I enter multiple terms and the words aren't consecutive then the search returns a blank. So for example if I enter "john" "smith", projects by john smith are returned; however if I enter "smith" "ecotoxicology" then there is no cases returned.
I have 2 columns key words and questions. I am using the code:
If(IsBlank(TextInput2.Text), Questions, Search(Search(Questions,
First(TrimEnds(Split(TextInput2.Text, ","))).Result, "crff8_keywords", "crff8_question"),
Last(FirstN(TrimEnds(Split(TextInput2.Text, ",")), 2)).Result, "crff8_keywords", "crff8_question"))
However if i search by Agile, Sharepoint this is not working. It stops working after i put "," between the keywords.
Hi You can use the following Approach to meet your requirement with Split function in powerapps:
found >= CountRows(
This is brilliant, @CalfordMath -- just what I needed. Tweaked it a bit to work with a multi-select ComboBox and worked a treat... Thanks very much for sharing!
Hi @CalfordMath ,
can i check is there any way to filter multiple nonconsecutive keywords with the results highlighted? Thank you.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.
The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.
We are excited to announce a new way to share your ideas for Power Apps!