-
CMD_Pulldown is a SharePoint list that is being used for the values of a handful of columns (that have no relationship as list items). Formerly, it was being used for Country and Sales Org, but I have since created separate lists in order to tackle the cascading drop-down function. Yes the values are the same between these two columns ...
-
We can use the ID from the main data source sales org to look up the text in the Sales Org 1 data source for the comparison. So, no, you don't have to use XML or contains. That's why I'm asking if the text value in the list that is used for the CMD_Pulldown is equal to the text value displayed in the sales org dropdown.
-
From my initial post:
"Please note that I am unable to use "=" (instead of "contains") and "Type text..." here for the value, since this is a drop-down value and it is being seen as an integer I believe (ID?). With an operator of "=", I only have these options: "Type a number...", ...
-
What about these rules on the use default sales org values selection? I see the rules are using "contains" - but it looks like if I have the sales org, I can get the values from the CMD_Pulldown data source. Does the sales org in that data source match the name of the selected sales org? Or do we have to use contains here?
-
That is exactly right.
-
Cool. In the data connection Sales Orgs1, is SOCountryLook a lookup to your countries list?
-
Country4. Screenshot attached.
EDIT: So, that might be relevant. In this current state, the 3-tier cascaded drop-down is utilizing three secondary connections - one for RA_Sales_Region, one for Country (containing Region as a lookup for filtering), and one for Sales Org (containing Country as a lookup for filtering).
-
I don't have an on prem SharePoint 2016 server to test with, unfortunately. The other post you referenced mentions an anon access issue at the end of the thread, not sure if that applies (or, indeed, if that thread applies at all).
-
What is the field name for the country field in question? I see a number of labels on the form with the word "Country" and want to make sure I'm looking in the right place. If the data source for the sales org dropdown contains the country, we should be able to set that with a single rule, just using XPath to get the correct sales ...
-
Hey Hilary,
Thanks for responding :)
I have attached the form in question. Please note that in order to simplify my post before, I claimed "State" was the third tier of the cascading drop-down. In actuality it is SalesOrg. I just didn't want to go into explaining what that is, but it is a field specific to ...