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,

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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
Copy link

Link copied!

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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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
Copy link

Link copied!

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

Was this reply helpful? Yes No