Forum Discussion
Solved
Filter Managed Metadata Lookup Field
Good day. I have a simple Contacts list with a managed metadata field "Contact Type". I also have a Contacts list site column lookup field to be used for a variety of purposes in other lists, ...
There is no standard functionality that supports this, however you can achieve this with a functional workaround.
If you create a column in your Contacts list “Publisher contacts” you can fill this column with a Power Automate flow with the condition that the field will only be filled if the label of your managed metadata field equals that of “Publisher” in your case.
The lookup site column should be edited to use the “Publisher contacts” column as a dropdown and this will result in a dropdown with only these fields. By default a lookup column hides all the empty fields in a dropdown and the “Publisher contacts” column is only filled in by our flow then the managed metadata matches the condition.
I hope this helps your case.
With all the experts around, no one has any insight into this conundrum?