Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Searching for managed metadata

(0) ShareShare
ReportReport
Posted on by

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,

  • Lewkir Profile Picture
    Lewkir on at
    Re: Searching for managed metadata
    Hi, I deleted "New Tag" and put it back and now it works. Thanks for all your help.
  • Lewkir Profile Picture
    Lewkir on at
    Re: Searching for managed metadata

    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.

  • Verified answer
    v-siky-msft Profile Picture
    v-siky-msft on at
    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

  • Lewkir Profile Picture
    Lewkir on at
    Re: Searching for managed metadata

    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

  • v-siky-msft Profile Picture
    v-siky-msft on at
    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")

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

    Sik

  • premiumappapk33 Profile Picture
    premiumappapk33 2 on at
    Re: Searching for managed metadata

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

    premium app apk

  • Lewkir Profile Picture
    Lewkir on at
    Re: Searching for managed metadata

    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.

  • v-siky-msft Profile Picture
    v-siky-msft on at
    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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard