General

Re: Year Old Form - No Changes - Suddenly Can't Submit New Forms

Hilary Stoupa — Tue, 28 Jul 2015 17:37:52 GMT

I wonder if an old version was cached locally (since InfoPath caches filler forms). I'm just glad it is working correctly again. :)

Re: Year Old Form - No Changes - Suddenly Can't Submit New Forms

Jen B — Tue, 28 Jul 2015 17:34:38 GMT

HAHAHAHAHA!! SUCCESS!!

Hilary, I can't thank you enough for your help. I don't know why the form was still not submitting after I removed the rule to set that people picker field YESTERDAY.. and why it decided to focus its wrath on the ONE field... but NOW it worked. OH finicky infopath forms!! You vex me so.

Although not tied together at all... in ANY WAY. Once I changed the rule on the button to set the three options on the people picker to a specific name, it didn't give a hoot about the darn dropdown field it so vehemently hated before.

Why it didn't throw an error over a year ago when it was first set up that way?? Sigh. Thank you Hilary!

Re: Year Old Form - No Changes - Suddenly Can't Submit New Forms

Hilary Stoupa — Tue, 28 Jul 2015 17:34:27 GMT

It is just the only time I've run into that specific validation error - when a people picker control is being populated incorrectly. :)

Re: Year Old Form - No Changes - Suddenly Can't Submit New Forms

Jen B — Tue, 28 Jul 2015 17:24:14 GMT

Perhaps I was lying and somehow they are relating to each other. I just removed the option to set the name and it now let me submit with the BA2 field as is (even though, when I tried that yesterday, without messing with the other fields, it didn't).

I'm going to test re-adding and setting all three options and see what happens...

Stay tuned.

Re: Year Old Form - No Changes - Suddenly Can't Submit New Forms

Jen B — Tue, 28 Jul 2015 17:15:52 GMT

Hi Hilary,

I'm using logic to set a people picker, but it isn't related to the field causing the issue. They don't have any connection at all. THere's a supervisor field that is partially filled in on a button click if a certain role is using the form. It just enters a name and then the user clicks the checkbox to confirm it. I thought it might be the issue initially, but after removing the rule to set the name, it still had errors occurring.

The list that the three fields pull from uses the sharepoint people picker option to find individuals and then I use the Account ID as Display Name the value and display for the field. What's obnoxious is that it is just fine in the other two dropdowns (and about 20 others I've done this with in another form).

How is it that I can completely remove the BA2 dropdown field, rename it, and still have the same issue ONLY when I link it to the external list... that the other two fields use without error?

I looked at the two other items you linked to, but my form doesn't have the same set up as those did. (I wish it did, as I would have an answer)

Re: Year Old Form - No Changes - Suddenly Can't Submit New Forms

Jen B — Tue, 28 Jul 2015 17:10:19 GMT

Yeah, it was by choice. The list it pulls from has a people picker field that I'm using for account ID as the value. Since it wasn't working in the BA2 field, I grabbed the text field with the MS ID to see if it would play nicer than the people picker.
No luck.

Re: Year Old Form - No Changes - Suddenly Can't Submit New Forms

Jen B — Tue, 28 Jul 2015 16:35:19 GMT

FYI - I just opened the manifest file in notepad to see if I could find a reference to #text or just #. I'm finding nothing.

Re: Year Old Form - No Changes - Suddenly Can't Submit New Forms

Hilary Stoupa — Tue, 28 Jul 2015 16:33:18 GMT

http://www.infopathdev.com/forums/p/18483/64566.aspx

https://social.msdn.microsoft.com/Forums/en-US/9fa89823-0d0c-4cce-aa2e-f7d4ed13de0b/infopath-form-validation-error-on-submit-to-a-sharepoint-library?forum=sharepointcustomizationlegacy

Both of these threads discuss the same validation error - I don't see any rules on the IPBA2 field, but are you using any logic to set values in a people picker control?

Re: Year Old Form - No Changes - Suddenly Can't Submit New Forms

Hilary Stoupa — Tue, 28 Jul 2015 16:29:49 GMT

The drop down is set up differently for IPBA2 - did you notice that? For the others you are using for display and value fields from the person or group column. For IPBA2, the value is from "Title" - is that intentional? The validation error on #text is weird, for some reason I think I've seen that before. I'm going to go take a look online.

Re: Year Old Form - No Changes - Suddenly Can't Submit New Forms

Jen B — Tue, 28 Jul 2015 16:24:01 GMT

Trying this one again. This is the error after trying to submit when the dropdown is connected to the external list.

Re: Year Old Form - No Changes - Suddenly Can't Submit New Forms

Jen B — Tue, 28 Jul 2015 16:22:50 GMT

Error after ctrl+shift+o (Attached)

For some reason it won't let me add the other file. The error upon submit is the generic validation error:

"Some rules were not applied"

Details: InfoPath cannot submit the 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).

Re: Year Old Form - No Changes - Suddenly Can't Submit New Forms

Jen B — Tue, 28 Jul 2015 16:19:52 GMT

Happily! I've attached a copy of the form I'm using to test. The Supporting BA 2 (IPBA2) is the problem child. It is currently set to pull from the data source like the other two.

The error I'm getting on submit is "Rules were not applied" and the details of missing validation. I did the ctrl+shift+o (thank you so much for that!) and got the detail of "a problem with the form's design..." "a field or group #text. Error: No exact match was found" I'll attach the two error message on another post as it appears I can only attach one thing on this one.

Re: Year Old Form - No Changes - Suddenly Can't Submit New Forms

Hilary Stoupa — Tue, 28 Jul 2015 15:59:09 GMT

Can I see your form? You can attach it under the Options tab in a reply.

What is the full validation error?

Re: Year Old Form - No Changes - Suddenly Can't Submit New Forms

Jen B — Tue, 28 Jul 2015 15:49:34 GMT

I was just jumping on to say that I found the solution in the FIELD properties rather than CONTROL properties. It had set the default. Apparently, it was getting to be a long day and I wasn't thinking clearly.

Back on the original problem, I’ve narrowed the issue down to 1 of 3 dropdown fields in the form (Lead BA, BA 1, BA 2) which have always connected to and external list. Lead BA and BA 1 are connected to the external list and working just fine. BA 2 is the problem. When I connect that field to the external list, I get the validation error when trying to submit.

Here’s what I know/have done:

· If I don’t use the external list to populate the BA2 dropdown, and just use choices I enter manually, the dropdown works fine.

· If I connect BA 2 to the external list, I get the validation error. (All settings are the same as the other dropdowns)

· I deleted the field completely and republished to remove it from the sharepoint site. Then recreated the field (same name), connected to external list, published the field. Got the same error when trying to submit.

· I deleted the field AGAIN, removed it from the sharepoint site then recreated the field (new name), connected to external list, DID NOT publish the field. Got the same error on submit. If I remove the external connection, add dropdown options manually, I can magically submit.
I’ve confirmed all dropdown fields have the data type of Text (string), so it isn’t a problem with that.

I don’t know where else to look or anything else to try.

Any ideas?

I can’t figure out how two other identical fields work fine and the third isn’t.

Re: Year Old Form - No Changes - Suddenly Can't Submit New Forms

Hilary Stoupa — Tue, 28 Jul 2015 14:33:01 GMT

Perhaps the default value of the field is set to the choice you keep seeing? In the data source task pane (Fields), right click the field and select properties. Does the field have a default value?