Hi Everyone,

I have a scenario where I am trying to create a Nintex form for O365 SharePoint List. There is a input field "Account" on my form (connected to List 1). The form can submit only if the value entered in "Account" field either doesn't exist in List 2 "Account" column or does exist in List 2 "Account" column but "Valid" is Yes. 

If the Account field does contain the value and "Valid" is set to No it should not submit and show an error to user that form cannot be submitted. 

List 2 is setup in a way it has 2 columns - Account (Single line of text) and Valid (Yes/No) fields.

Is this feasible with Nintex forms? Please help I am new with Nintex.