Forum Discussion
Filter Managed Metadata Lookup Field
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.
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.
I did (and still have) have that Infinite error loop but hope to have gottan around it by adding a second condition of: The Conact Type Field does not equal the new text field that gets updated bt the flow. If it does, that means the flow already performed the function at some other time. The infinite loop warning is still there but I dont understand all the uncessesary code just to accompish this. If it goes into an infinite loop, great, hope it blows up.
Like I said, this is nutes but thanks again for your help when no one else answered even msft.