cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lewkir
Resolver I
Resolver I

Searching for managed metadata

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,

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

8 REPLIES 8
v-siky-msft
Community Support
Community Support

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

 

Hi Sik,

 

Thanks for the response.

 

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

 

Managed Metadata Issue 2.png

 

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

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

premium app apk

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")

Snipaste_2020-05-21_16-04-29.png

Sik

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

 

Managed Metadata Issue 4.png

 

By sample data do you mean this:

 

Managed Metadata Issue 3.png

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

View solution in original post

Hmm now it's created a new error:

 

Managed Metadata Issue 5.png

 

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

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

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,081)