Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Getting the following InfoPath error: Only Positive Integers Allowed Error:

Followed following suggestion (well, my 2nd dropdown was already like below) and made sure it's like below. But still getting above error. Please suggest.

If you get an error that says Only Positive Integers Allowed, you're trying to save a string into a column that is expecting a number. Most likely the Sub Project drop down's value is set to a string but because the column is a lookup, it needs to be a number instead. To fix this error, right click on the Sub Project dropdown and choose Dropdown list properties. Then underneath Entries, change the Value from d:Title to d:ID. After you republish the form, the form should start saving properly.

share|improve this question
I have resolved the issue by fixing the "Set a field" action rule for the 1st drop down to store ID of the second drop down instead of title. Now it's all fine. I am posting the answer in the event someone else running into same issue. Thanks MB – Maria Burton Jan 27 '12 at 18:34
Does this question relate to SharePoint and InfoPath? If not you should ask it in a specific Infopath forum, since it will be considered off-topic for our site – Anders Rask Jan 28 '12 at 13:31
a bit late, but for the record: yes, this is an intersection of SharePoint and InfoPath. – Reacher Gilt Aug 17 '12 at 15:21

2 Answers

up vote 1 down vote accepted

I have resolved the issue by fixing the "Set a field" action rule for the 1st drop down to store ID of the second drop down instead of title. Now it's all fine. I am posting the answer in the event someone else running into same issue. Thanks

share|improve this answer

Also make sure the lookup column in sharepoint is not set to required. I was unable to solve this issue for awhile, but I finally noticed that removing the "required" setting on the column within sharepoint will prevent the 'only positive integers allowed' from appearing on your form!

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.