-
I have a form that is using people/group picker, it works great when used in the form. But when the form is submitted to email the field is blank. I have a text field that populates the display name when "check name" is selected and the text field works great when submitted to email. The problem is the business doesn't ...
-
Yes they are, actually. That make a difference in the expression now?
-
You were using does not contain. I changed that to = and then wrapped the XPath expression in a not() - you'll note that's what my sample does. Are the names between the SQL table and the SharePoint list exactly the same, including case?
-
Unfortunately it did not. I see you removed Value at the start of the string. Can I ask what did you replace it with exactly?
-
I changed the filter on the third list box to be like the one in my sample. See if this works.
-
I have the listbox in there three times. The second one is the one I put my filters in and the third one is the one being compared to the SP list with the Xpath Expression you gave me.
-
-
Any chance you can attach a copy of your form to a reply under the Options tab?
-
OK so I created my XPath Expression using your example and not getting any errors on that. But it's not filtering. I apologize as I'm unfamilar with this form and am trying to reverse engineer what was done. So it looks like what they're doing is using a udcx file to get the info from the SQL table. Next there's a text box that is ...
-
Okay. So here's what I'd do. I'd add a data connection to the list. Then you can use a simple XPath expression for your filter. I'm attaching a simple sample form - save the linked file locally, right click and select design to open in design mode. All my data in the sample come from XML file data connections - that's easier ...