-
When you click Reply there should be an options tab - see screenshot. If you change the first dropdown in each of your conditions to "the expression" the full XPath will display. Can you paste that into a reply?
-
Looks like you may also need to match on country, right? Because the payment terms seem to differ according to country and sales org. However, for matching on just sales org, your XPath looks right.... Are you always getting Net 30? Or whatever the first item in the list is?
-
Yup - as long as you have a way to relate the sales org. If your list stores the text value, you just have to have the additional filter to get that text from the secondary data source leveraging the ID that is currently stored in the main data source. The XPath looks hairy, but it is just matter of adding a filter and selecting the filter values ...
-
I was just wondering if there were values in there that correspond to the fields you want to set. I've taken some guesses. Here's a copy of your form, save it locally, right click and preview and we'll see if I've made any correct guesses. I can't test my changes in preview because I don't have access to your site, of ...
-
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.
-
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?
-
Cool. In the data connection Sales Orgs1, is SOCountryLook a lookup to your countries list?
-
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 ...
-
Any chance you can attach a copy of your form to a reply under the options tab? I have an easier time seeing what's going on if I have an actual form to look at. :-)