Hello. I have a form with cascading drop-downs. The data source for these are two separate SharePoint lists. Later in the form, there is a list box with two filters that utilize the selections in these drop-downs and compare them against a main SharePoint list that includes lookup columns to the two aforementioned lists.
Filter one points to a field where there is only one value in the SP column. This filter works fine. The second filter points to a SP column that allows multiple values. This filter only works for the very first value in the column. This is not what I want. I want it to go through all of the values in that column until it matches what the user selected in the drop-down.
----
(version 2 of same problem, written by a friend of mine):
In the xPath below, d:Strategy_x002d_Product refers to a lookup column in a SharePoint list. This lookup column allows multiple values. But only the first value is being returned in what should be a Strategy_x002d_Product array.
Is there any way to retrieve all values in the Strategy_x002d_Product lookup and compare them to the single value StrategyID?
/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Title[(../d:Strategy_x002d_Product = xdXDocument:get-DOM()/my:myFields/my:general/my:StrategyID)] Thank you in advance!