custom list form - only positive integer allowed in dropdown

I have created a custom list form in InfoPath, and successfully deployed it to a sharepoint list. it's contains several text boxes, and dropdown lists. the dropdown lists pull data from a separate sharepoint list. one dropdown is retrieving a column that has alpha-numeric character (A-F), and gives a validation error "only positive integers allowed". I have double checked that no validations have been enabled.

Cheers,
Brendan only positive integer
brendanlefavreAsked:
Who is Participating?
 
ezskolConnect With a Mentor Commented:
You're trying to save a string into a column that is expecting a number.

To fix this error, right click on that dropdown field 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.
0
 
brendanlefavreAuthor Commented:
the suggested solution solved the problem. I also was able to solve the issue by changing the column type.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.