AnsweredAssumed Answered

Forms: Get list column based multiple dropdowns

Question asked by mlysgaard on Apr 30, 2018
Latest reply on May 13, 2018 by emha

Hi, I simply cannot get my head around this one....

I have a SharePoint list with the following structure:

Col_A      Text

Col_B      Int (1-5)

Col_C      Text (fixed value ei. A, B, C, D, E)

 

Now on my form I got three dropdowns:

DD1: Values 1-5 (related to col_B)

DD2: Values A-E (related to col_C)

 

And here is the challenge

DD3: Should display values from Col_A WHERE Col_B >= DD1 AND Col_C = DD2

 

How do I do this? ListLookup control only filters by one column.... was thinking of using some jQuery to query my list.

Outcomes