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.
That being said, typically another required microsoft hack or workaround to cover off the shortcomings or their tech. Many other collaborative frameworks out there have this functionality standard as it should be. Afterall, we're going into 2022 and they're still requiring users to have to go through this agony and how many years has managed metadata and lookups in general been around? I've been using it since 2013 so that tells you something.
Now I have to spend days trying figure out how to make this work in automate. It's not like we users have anything else to do with our time but have it centre around msft hacks and workarounds.
Thanks again for your input Pol at least you know something that msfty apparently doesnt. No one in their support told me this. SURPRISE!!!!!!!
Ya I think this is a bit too much BS over and over again. Time to move on to a platform that lives in the now.
Cheers Pol, hsappy holidays
"Update item: :"Actions in this flow may result in an infinite trigger loop........."
Excellent!!! Aye yi yi yi yi. Things would be much simpler if we could just add something similar to "END FLOW"!!! But....................
Yet more research just to perform a simple little filtering of a dropdown!!!
Carl_Williams it is indeed a warning that Power Automate gives when making the flow. However if you make it a double condition that also checks if the "Publisher contacts" column needs to be different from the Title then it won't loop because there won't be a modification in the no branch.
So the flow seems to work:
- Condition1: Contact Type (managed metadata field) = Publisher
- Condition2: Provided that: That "Publisher" text field doesn't alread equal the "Full Name" field
Otherwise, update the new "Publisher" text field with the name of the person/company in the "Full Name" field. Perfect.
However. I'm still getting the infinite trigger warning. ??
- Athough, duhhhh, I am duplicating the Publisher field with the word Publicher. It needs to be the las name or title field.
Aye yi yi yi yi.
I'll try this again tomorrow. This is as much msft malarkey I can take in one day.
Cheers