I am trying to set up a Browse Gallery, which is tied to a SharePoint List. The list contains a glossary of codes and their definitions. In the list, there is one column that is set up as a multi-select/combo box where you select which teams are eligible to use the code. This column is called, "Relevant Functions."
Because I need to be able to filter the list based on people selecting the team (i.e., function) that they are in, I am trying to include the field in the Browse Gallery. However, when I put in the code "ThisItem.'Relevant Functions' it gives me an error, stating that the "formula uses scope, which is not presently supported for evaluation. (Data type: Table)". I also get a note that says, "Expected Text value."
I have tried using:
Ideally, I would like this to be hidden so that people don't see it in the gallery listing, but it is available to search on.
I'm running out of ideas to try and solve this problem. If you have any ideas on how to solve, I would love to hear them!
Thank you very much!!! It worked! Now I just have to get my darn filters to work right XD
Hi @Aylanna ,
This will get you a Text value you can put in a Label
Concat(
ThisItem.'Relevant Functions',
Value,
", "
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2