Searching for managed metadata

[Lewkir]

I have a gallery displaying sharepoint list items. I am trying to search it based on the title field, a text column, and a managed metadata field.

Search works fine on the first two columns but when I input the 3rd I get the error:

 

My code takes the format:

Search('SourceList',Searchbox.Text,"Title","TextField","ManagedMetadataField")

as you can see in the photo, the error says expects text type, but mousing over the metadata column it says it is of the type text so I do not see the issue.

Is PowerApps simply unable to search on metadata columns?

Thanks,

[v-siky-msft]

Hi @Lewkir ,

Search function only support Text type column, Tags is only shown as Text, but it still managed metadata type column.

To achieve your need, please try this, add a new column to store the label to Managed metadata value. and search by that.

Search(AddColumns('SourceList',"NewColumn",Tags.Label),SearchboxSS.Text,"Title","Area","NewColumn")

Hope this helps.

Sik

[Lewkir]

Hi Sik,

Thanks for the response.

I'm afraid I'm still getting the same error:

It's still saying the "NewTag" field is text too.

[premiumappapk33]

thanks dear for sporting me, i also provide services on website with free of cost

premium app apk

[v-siky-msft]

Hi @Lewkir ,

That's weird, since the code work well on my side.  Please share the sample data of Tags Label.

Could you please try this?

Search(AddColumns('SourceList',"NewColumn",Text(Tags.Label)),SearchboxSS.Text,"Title","Area","NewColumn")

Sik

[Lewkir]

Yeah I had the same idea to use Text() but unfortunately the issue persists:

By sample data do you mean this:

[v-siky-msft · Accepted solution]

Hi @Lewkir ,

Yes, so the Tags column allows multiple selections?

If so, please try this, concatenate multiple selections to a string.

Search(AddColumns('SourceList',"NewColumn",Concat(Tags,Label)),SearchboxSS.Text,"Title","Area","NewColumn")

Hope this helps.

Sik

[Lewkir]

Hmm now it's created a new error:

not sure why it's saying it doesn't exist when it's clearly there.

[Lewkir]

Hi, I deleted "New Tag" and put it back and now it works. Thanks for all your help.