cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Search with multiple keywords

Hi,

 

I've created a nice knowledge management application where people can find there answer very quickly. Now because of the fact the knowledge within in the database is growing and growing there was some feedback from the users if it is possible to search on multiple words like "Holiday", "Procedure" So that you will find for examplewithin the database: "here you can find when you can go on a holiday. Please click on the procedure.. etc."

 

So that the above keywords will also give results even if it is not in order.

 

Hope some can help me with this? 

 

I know btw That there was an article where there was a solution with i thought to create columns etc. But I can't find this articile anymore.

 

 

12 REPLIES 12

I am not sure, I haven't tried it. If it is, I think it's going to be slow.
If not, you can retrieve the data of the sharepoint list using Flow. How many records does the list have? 
You can try it.

CalfordMath
Advocate V
Advocate V

I created a workaround to search for ALL keywords but not necessarily consecutively found.  I only searched in a single column, but you could modify the code for multiple columns I'm sure.  I answered in reply to a different question, but I think it applies here too, so I will just link to it:

 

https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/Searching-with-multiple-key-words/m-...

rahuldubey21
New Member

To make this all work I updated the search button OnSelect code to include the following code:

ClearCollect(
    colWords,
    Split(
        TextInput1.Text,
        " "
    )
);

 

ClearCollect(
    colResults,
    Distinct(
        Ungroup(
            ForAll(
                colWords,
                Filter(
                    Actions,
                    colWords[@Result] in Title
                )
            ),
            "Value"
        ),
        {
            Title: Title,
            Description: Description,
            Connector: Connector
        }
    )
)

In above you can change content between {} with field names of your List:

{ Title: Title, Description: Description, Connector: Connector }

And Items property on the Gallery is set to:

colResults.Result

This is the post url where i found this solution:

5 steps to implement word based search in Power Apps (sharepains.com)

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,900)