Only Positive Integers Allowed - InfoPath Form 2010/SharePoint List

Question

Hi,

I am currently having an issue where a specific lookup field in one of my SharePoint List Forms is erroring out and is saying "Only Positive Integers Allowed". I have looked through different forums to try and find a solution to this, but have not had any luck.

Within the SharePoint List Form there is a List Filter that deploys the project title to the project title field. After the project title is filled in the field is highlighted by a red checkered box, and "Only Positive Integers Allowed" appears.

The project title field is not a required field, but it is a lookup. I have gone to InfoPath and have checked the settings there as well:

The field's value is set as d:ID rather then d:title.

Cannot be blank is unchecked and the form publishes successfully.

I read that a quick fix to this would be by going to the Main Data Connection > dataFields and selecting the proper field, once there deselect "Value". However, when I went to the Default Values section to complete this there wasn't a Value field to deselect.

Any help would be greatly appreciated!

Thanks,

Greg

---

Greg Baker

Answer 1

In the "fields" pane on the right, open up your field that the drop-down uses.  What type of field is it?  Text? Number? Integer?  I think you probably need to change the field type.

---

Laura Rogers
Rackspace: SharePoint Consulting
Blog: http://www.wonderlaura.com
Twitter: WonderLaura
Books:Beginning SharePoint 2010: Building Business Solutions with SharePoint
Using InfoPath 2010 with Microsoft SharePoint 2010 Step by Step

Answer 2

Hi Laura,

It is Lookup field that is set up as a Drop-Down List.

---

Greg Baker

Answer 3

Look at the actual field type in the list of fields on the right, not the type of control.  Look at the properties of the field in the list of fields.

---

Laura Rogers
Rackspace: SharePoint Consulting
Blog: http://www.wonderlaura.com
Twitter: WonderLaura
Books:Beginning SharePoint 2010: Building Business Solutions with SharePoint
Using InfoPath 2010 with Microsoft SharePoint 2010 Step by Step

Answer 4

Here is a screenshot of the properties.

Hope this helps.

---

Greg Baker

Answer 5

Hi,

When set a lookup field value, you need to set an ID to the field not the actual value it displays.  

Thanks,

Entan Ming

---

Entan Ming
TechNet Community Support

Answer 6

Hi Entan,

I believe the value is already set as ID which is why I am still having issues.

Any suggestions? I keep getting the same error.

Thanks,

Greg

---

Greg Baker

Answer 7

hi,

Is your list form part of your workflow task form or a new item form?

can u try to map both the value and display name to ID and check if the error is still there.. I guess the field is expectivng an interger but u r maping it to some other value. i look up field internally looks for an ID to map with the value..

Answer 8

If your form is a sharepoint list form, you're only supposed to edit the list of choices in the column settings in the list setting screen.  If you edited it in the form, or in both places, maybe that's the problem. 

1. Go to list settings, click that column, and make sure the choices are correct.
2. Edit the form in InfoPath, and remove the drop-down box, and then drag the field onto the form all over again, so that it's new/clean.

See if that fixes it.

---

Laura Rogers
Rackspace: SharePoint Consulting
Blog: http://www.wonderlaura.com
Twitter: WonderLaura
Books:Beginning SharePoint 2010: Building Business Solutions with SharePoint
Using InfoPath 2010 with Microsoft SharePoint 2010 Step by Step

Answer 9

I appreciate your assistance with this, but it looks like this project has been scrapped. I was never able to have it work out, so I am not sure if it was a bug or something.

Thanks,

Greg

---

Greg Baker

Answer 10

Infopath cannot process lookups properly. Like Yes'No fields or required fields.

InfoPath should never be used on SharePoint due to it's incompatability with SharePoint. 

Use designer if available.  If not, just use SP out of the box.  InfoPath is a complete piece of junk when coupled with SharePoint.

Answer 11

Hey JD,

Just to add some more insight to the lack of communication between InfoPath / SharePoint. I just had an issue where adding new data into my datasheet view caused my IE to crash. It appears that this happened because I had a people picker field that allowed for multiple selections. I created a new list and instead of using an InfoPath form, used the SharePoint form, and then put in the same people picker field allowing multiple selections. This time it worked and IE did not crash.

---

Greg Baker