Answered

Searching for managed metadata

(0) Share

Report

Posted on by 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:

Managed Metadata Issue.png

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,

Managed Metadata ...

I have the same question (0)

All responses (8)

Answers (1)

v-siky-msft on at

Like (0)

Report
Re: Searching for managed metadata

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

Was this reply helpful? Yes No
Lewkir on at

Like (0)

Report

Re: Searching for managed metadata

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.

Was this reply helpful? Yes No
premiumappapk33 2 on at

Like (0)

Report

Re: Searching for managed metadata

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

Was this reply helpful? Yes No
v-siky-msft on at

Like (0)

Report
Re: Searching for managed metadata

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

Was this reply helpful? Yes No
Lewkir on at

Like (0)

Report

Re: Searching for managed metadata

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

By sample data do you mean this:

Was this reply helpful? Yes No
Verified answer

v-siky-msft on at

Like (1)

Report
Re: Searching for managed metadata

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

Was this reply helpful? Yes No
Lewkir on at

Like (0)

Report

Re: Searching for managed metadata

Hmm now it's created a new error:

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

Was this reply helpful? Yes No
Lewkir on at

Like (0)

Report

Re: Searching for managed metadata

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

Was this reply helpful? Yes No