Power Platform Community Forum Thread Details

Hello,

I have a data table displaying sharepoint list content, specifically: a) a title column; and b) metadata information (labeled 'Tags'). The metadata includes parent-child hierarchies.

I want to build a function to search and filter for the tags whilst keeping parent-child hierarchies intact.

When displaying the table on the canvas the Tags column initially only returned [object Object, ...]. I understand this is due to the column containing an array of values.

I therefore used this formula in order to split out the individual values:

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

The problem I have is that a lot of additional unknown text is being added to the column with this formula, see screen below:

screen table.png

The words in the Tags column are what I want to return (e.g. "Global, "AML", Germany", "Checklist") and all the content after | is not expected to appear.

Any advice on how to resolve this? Is the concat option suboptimal for my desired output?

Thanks

Categories:

Building Power Apps