lookup filter using 2 fields in Nintex form 365

  • 28 June 2018
  • 1 reply
  • 38 views

Hi;

in Nintex 365 form, i need invalidate a control based on a filter/query on the list using 2 fields;

 

Ex : I need to check in the list if Email = current user(Email) and date = control-date, if true invalidate control-date.

 

lookup function only filter using 1 field;

 

How can i reach this result ?

 

Regards

Ahmed


1 reply

Userlevel 3
Badge +9
1) Create a hidden calculated field called EmailDate that is based on the formula:
=Email&"|"&Date

2) Create a form variable EmailDate with the value
[Form].[Email]+"|"+[Form].[Date]

3) For the List lookup:
In the When property, specify the hidden calculated field EmailDate
In the Equals value property, use the form variable EmailDate (created in step 2)

A little bit of overhead leveraging the hidden calculated field but effective and no maintenance required

Reply