Nov 20 2021 11:24 AM
Good day.
Thanks
Nov 21 2021 01:44 PM
Nov 24 2021 02:21 AM
SolutionThere 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.
Nov 24 2021 11:24 AM
Nov 24 2021 11:53 AM
Nov 24 2021 12:24 PM
Nov 24 2021 12:25 PM
@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.
Nov 24 2021 12:45 PM
Yes I thought I did it correctly, it is running successfully but still the warning
Nov 24 2021 12:47 PM
Nov 26 2021 12:33 PM
So the flow seems to work:
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. ??
Nov 24 2021 02:21 AM
SolutionThere 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.