Hi,
Greetings!
I have a dropdown which uses a collection.
The collection has "none" as the first value and values from Dynamics 365 Fin & Ops.
Let's assume that the values in the collection 'LegalEntityList' are {"none","a1a","abc","def","xyz"}.
These values could vary.
Maybe, in the first scenario if the values were {"none","mmm","def","xyz"} the dropdown would not be set to "abc" since this value is not present in the list.
The second time, the list could be {"none","abc","def","xyz"}, so the dropdown would be set to "abc" because "abc" is present in the list of values, and upon clicking the lookup button all the four values would be listed/ shown, and not just "abc".
I want the value "abc" selected if it is present in the list ("abc" is hardcoded).
I tried numerous suggestions over the internet but nothing seems to work.
What should be the formula and where should I set it to achieve this?
With best regards,
Abhinay