https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/118030.aspxMon, 08 Jan 2018 20:33:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118030ctoper110https://www.infopathdev.com:443/forums/thread/118030.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=118030I did just that and I created a rule to run when Submit is actioned to fill in a hex code for that field. We don't use it so it shouldn't be a problem. It submits just fine now. Thank you so so much Hilary as always you have been a great help. I promise to get out of your hair now. : ) Have a great day.https://www.infopathdev.com:443/forums/thread/118029.aspxMon, 08 Jan 2018 20:05:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118029Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118029.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=118029You'll want to take the now() function out of the rowstamp field. The only fields that will be submitted to the database are in /dfs:myFields/dfs:dataFields - the other fields that you've added don't seem to be required. I'd encourage you to drag the repeating group in the datafields onto your form to see what the values are after you run your query.https://www.infopathdev.com:443/forums/thread/118028.aspxMon, 08 Jan 2018 17:51:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118028ctoper110https://www.infopathdev.com:443/forums/thread/118028.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=118028I did actually see that, it's not being set in the form anywhere. But the reason I mention the empty field is because I did manage to submit the form twice but deleting that empty field (although for some reason it's not letting me do that anymore) also just to add some interger in there I put as default the now() function in that rowstamp field. And get the below error message which is also one I've seen on this form. The form cannot be submitted because it contains validation errors. Errors are marked with either a red asterisk (required fields) or a red, dashed border (invalid values). Field or group: frbny_bf_appdiscid Error: Only integers allowedhttps://www.infopathdev.com:443/forums/thread/118027.aspxMon, 08 Jan 2018 17:12:56 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118027Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118027.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=118027Actually - see the error message? It says in it what the issue is - it is with the rowstamp field (see attached screenshot). Is that being set in the form anywhere? You may need to check with your DBA on this ...https://www.infopathdev.com:443/forums/thread/118026.aspxMon, 08 Jan 2018 16:57:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118026ctoper110https://www.infopathdev.com:443/forums/thread/118026.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=118026Thank you very much for the clarification Hilary. Moving on from that (and I know this should be another post but I only ask here because I know you already have a copy of the form that I sent you) I'm getting the attached error when trying to submit. My guess is that for some reason when the form loads that list box's first line is blank. And it doesn't like that empty space when trying to submit. There is a space above Cisco that data can be placed. The data type for the field in the form is not integer but text. Any idea on how to get rid of that space? After this I promise to not bug you for a long while. : )https://www.infopathdev.com:443/forums/thread/118025.aspxMon, 08 Jan 2018 15:56:04 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118025Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118025.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=118025Contains or does not contain are used for things like checking a string for a substring. So - you could see if an instance of a field contained "abc" or "def" or "ABC" or "DEF".https://www.infopathdev.com:443/forums/thread/118012.aspxSat, 06 Jan 2018 05:44:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118012ctoper110https://www.infopathdev.com:443/forums/thread/118012.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=118012One last thing as I know you've been very helpful (as always) and need to move on. What Xpath formula can I write using the "does not contain" action? As always thank you very muchhttps://www.infopathdev.com:443/forums/thread/118008.aspxFri, 05 Jan 2018 22:08:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118008Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118008.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=118008Does not contain is not the same thing as equals.https://www.infopathdev.com:443/forums/thread/118007.aspxFri, 05 Jan 2018 21:15:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118007ctoper110https://www.infopathdev.com:443/forums/thread/118007.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=118007So I can't really do that as the column in that table numbers in the thousands. I really need to find a DBA to clean it up : ) But just a question if the second list box does work using all of those does not contain doesn't that also mean that the data does match up?https://www.infopathdev.com:443/forums/thread/118006.aspxFri, 05 Jan 2018 20:17:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118006Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118006.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=118006No - if they are the same, = should work. Sometimes I put the data I'm working on the form so I can see it. You may want to do that, drag the data from your list onto the form, and drag that display name from the data table onto the form - then try using conditional formatting to highlight rows in the SQL data that match or don't match. That can often help me find what I've got wrong in my filtering. :)https://www.infopathdev.com:443/forums/thread/118004.aspxFri, 05 Jan 2018 19:55:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118004ctoper110https://www.infopathdev.com:443/forums/thread/118004.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=118004Yes they are, actually. That make a difference in the expression now?https://www.infopathdev.com:443/forums/thread/118003.aspxFri, 05 Jan 2018 19:24:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118003Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118003.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=118003You 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?https://www.infopathdev.com:443/forums/thread/118002.aspxFri, 05 Jan 2018 19:08:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118002ctoper110https://www.infopathdev.com:443/forums/thread/118002.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=118002Unfortunately it did not. I see you removed Value at the start of the string. Can I ask what did you replace it with exactly?https://www.infopathdev.com:443/forums/thread/118001.aspxFri, 05 Jan 2018 19:00:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118001Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118001.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=118001I changed the filter on the third list box to be like the one in my sample. See if this works.https://www.infopathdev.com:443/forums/thread/118000.aspxFri, 05 Jan 2018 18:47:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118000ctoper110https://www.infopathdev.com:443/forums/thread/118000.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=118000I 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.