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,
Solved! Go to 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
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:
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
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
Yeah I had the same idea to use Text() but unfortunately the issue persists:
By sample data do you mean this:
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
Hmm now it's created a new error:
not sure why it's saying it doesn't exist when it's clearly there.
Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.
Did you miss the call?? Check out the Power Apps Community Call here!
User | Count |
---|---|
255 | |
205 | |
76 | |
37 | |
31 |
User | Count |
---|---|
331 | |
214 | |
121 | |
71 | |
55 |