InfoPath Dev

Hi,

I have configured the InfoPath textbox control to accept user input (Unique Employee ID) and

1. Check for typed user input against SharePoint list and pull corresponding Job Title, Pay grade and other information - It fetches values when it matches and populates other textbox controls per configuration.

2. When the typed Employee ID does not find a match (because the typed user input is wrong) in the backend SharePoint list, I need infopath to throw an error message.

I tried configuring the Employee ID text box with a rule. The rule (with 2 conditions) checks and (should) provides an error message when

1. Employee id is NOT blank AND (typed) Employee ID does NOT find a match with Employee ID in Sharepoint list

The problem is, InfoPath is showing the Red outline (indicating error) around the Employee ID textbox control  irrespective of whether it finds a match or otherwise.

Thanks in advance. Please let me know if additional information is required. 

Thanks

 So - sounds like your custom validation is incorrect? What does that look like? You can attach a screenshot under the Options tab.

Hi Hilary,

Thanks for your email. 

I have attached the validation here. Please let me know if that is what you had asked for.

Thanks

 Can you change the first drop down in that condition to "the expression" and then copy and paste the resulting expression in a reply?

Thanks Hilary.

I did as you had mentioned. And here is the expression - xdXDocument:GetDOM("Employee Tracker")/dfs:myFields/dfs:dataFields/dfs:Employee_Tracker/@AIM_ID != .

 Please let me know if additional information is required.

Thanks in advance.

Thanks

Try this instead:

xdXDocument:GetDOM("Employee Tracker")/dfs:myFields/dfs:dataFields/dfs:Employee_Tracker/@AIM_ID != current()

Thanks Hilary.

I tried that now and it is still the same. It is showing red borders irrespective of whether the typed value matches or not.

Thanks

 One more try -

not(xdXDocument:GetDOM("Employee Tracker")/dfs:myFields/dfs:dataFields/dfs:Employee_Tracker[@AIM_ID = current()])

AWESOME!!!!!

Thanks. I tried now and it worked. Thanks a bunch Hilary!!!