Really new to this, I'm trying to set the default view ("source view) in a lookup control based on a condition.
I tried the following :
fn-If(amount >= 250000, "role1", "role2")
But I get the error:
value with name "fn-If(amount >= 250000, "role1", "role2")" does not exist.
Solved! Go to Solution.
Hi @mdb74 ,
I would be interested to know more about the solution you are trying to build. Could you send me an email to email@example.com and let me know more about your form?
Found a solution for this? I'm having same problem, but can't find the clue.
So I want the lookup to filter on 2 columns, depending on the value of 2 differtent columns.
Our filters only work on a single property, not multiple. However NWC Forms does allow filtering on multiple properties on the Data Lookup control to Office365.