Power Platform Community Forum Thread Details

Searching a gallery based on tags

Hi everyone,

We're building an How to buy app, which will show what the user would need to do when buying his/hers desired item.

Our items are in a SharePoint list, and are build such as a every column is a different layer from a taxonomy. So column one is area 1, column two is are 2 and column 3 is area 3. In area 1 we have the area on what to buy (for example external employees), in area 2 we have a second layer specifying what in the area you would want to buy (for example freelancer) and in area 3 another layer (the last one) which will specify the exact thing that you would want to buy (for example a IT employee).

However, an user could search for other terms then IT employee, for example ICT employee, external ICT work, etc. So we want to have an extra column, or another solution to add search tags to our taxonomy and to let the user of the app also search for those tags.

Does anyone of you know if this is possible, and if so, how?

Thanks in advance!

Categories:

Connecting to Data

General Questions

It is possible, but difficult. The issue is there is no native, delegable method to filter a list on a multiple-selection column in SharePoint from Power Apps. There is technically one way using a flexible height gallery where you add a text field like

Concat(ThisItem.MultiSelectField.Value, Value, ",")

And then rather than filtering by this field you change the Visible property to show or hide the tile. This video by Reza is an example.

The other way is more robust, but much harder to set-up. Use Power Automate to send an SharePoint HTTP query request. This allows you to make use of the native search capabilities of SharePoint, specifically, KQL. In addition to the managed metadata column that you're searching, restrict the search to a specific List or Library. Additional complexities are:

That the results returned from the HTTP request JSON will need a bunch of restructuring to get it into a format usable by Power Apps. I personally just return a list of item IDs back to the Power Apps.
The query will return only the top 10 results, so if you want more you'll need to run multiple HTTP requests to do the pagination in Power Automate.

It is possible, but it will take some doing.

Quick Links

Leaderboard