InfoPath Dev

I have a GL account sharepoint list in a combobox/repeating table. The GL accounts in combobox are retrieved based on Users location. If a GL account is not in combobox, user can manually key in GL account. I need to validate this manually entered GL account. I have a secondary data source of the full GL account list. I am trying to filter the full GL account list with the manually entered GL account, then compare to see if the GL account is valid. I got it to work when a static value was used for filtering but it just wont work if I specifiy the entered value for filtering. Any suggestions how to get this to work? THANKS MUCH.

What does the validation rule look like? Change the first drop down to "the expression" to get the XPath.

 Hi Hilary,

Here is validation rule:

current()/../my:VxGL != xdxDocument:GetDOM("VISA GL# Validation")/dfs:myFields/dfs:datafields/d:SharePointListItem_RW/d:GL_x0023_[.=current()/../my:VxGL]

 

"VxGL" is value entered in combo box.

"VISA GL# Validation"  is secondary data source - I am trying to filter this using the VxGL.

Thanks and much appreciated.

 

 

 

Hmmm - I wonder if instead you want:

not(xdxDocument:GetDOM("VISA GL# Validation")/dfs:myFields/dfs:datafields/d:SharePointListItem_RW[d:GL_x0023_=current()/../my:VxGL])

So, the validation rule fires if there is no row where the GL_x0023_ field matches the VxGL field - but what field is this rule currently on? Not VxGL?

Rule is on VxGL. 

Yes, I think I need "NOT" instead.

That was why initially I used "not equal"  but I guess no rows found is not considered as not equal.

Is there a way to go around this?

THANKS Again. 

 

If the rule is on VxGL, I'd think this:

not(xdxDocument:GetDOM("VISA GL# Validation")/dfs:myFields/dfs:datafields/d:SharePointListItem_RW[d:GL_x0023_=current()])

Since current() refers to the node you are on - which is VxGL.

Hi Hilary,

I tried to publish form with the rule on VxGL and received the following error (Screen shots below).

I changed "NOT"  to "current() !="  and no error message but that's not what we want.  Any suggestions?

THANKS. 

 

 

 

Thank You.  It is working now that I created a new form.

Not sure what went wrong with the old one.