Take the 2-minute tour ×
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
add comment

3 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
add comment

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
add comment

Do NOT - I repeat - Do NOT create the column in List Settings. Create the fields IN INFOPATH, in your Main data source. When creating the new field, choose the plain Choice field type (do NOT choose a lookup-sourced choice field).

Make sure you've set up your external data connections.

After you've created the field, go into the control properties and configure your choices to pull from the external data connections.

This resolved all of my issues with integer errors, choices not being able to cascade, validation, etc.

share|improve this answer
add comment

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.