InfoPath Dev

After I submit I get the normal success message and I can see the List Field ID. If I close the form and reopen it to edit, the List Field ID is gone. It seems like it makes the initial submission but doesn't call back the submitted list items.

Under my submit rules I only have two items

    1. Submit using data connection: Main Submit  (SP Library)

    2. SubmitToSharePointList /submit=ShPSubmit /mapping=mapping /id=my:ID (SP List)

The list items are in your main data source, right? And the ID field you are setting is in your main data source?

i promoted the SPList fields in my SPLibrary  i think this is the problem

That was the issue. The promoted fields in the SPLibrary were overriding the values from the SPList.

One last question. Is it necessary to have the ID field present in the form or only the datasource?

Thank you for your help.

Only in the datasource -- you don't need to display it in the form. Glad you got it sorted, and thanks for posting the issue!

Thank you for creating this demo. I have followed the instructions exactly, but the list items in SharePoint are not being updated, they are being duplicated each time the form is submitted. I am relatively new to InfoPath, so if there were any other steps necessary to accomplish the id field being populated by SharePoint that were not mentioned in your demo, could you please provide them? When I created the id field, I specified it as an Integer. I have read through the thread above, and the one person solved their problem by "promoted the SPList fields in my SPLibrary", but unfortunately, I don't know what that means. I would appreciate any help you could provide. If there is any additional information I can provide or screenshots that would help troubleshoot my issue, please let me know and I'll post them right away. Thanks, Stuart

Just wanted to follow-up that I was able to find the issue. In going through the demo, I had set the id field to be an Integer. Turns out, that was the problem. Setting the id to be a text field solved the problem. Now the id number populates within the form and when information is changed and the form is re-submitted, it is updated in SharePoint rather than creating new items. Thanks, Stuart

Hi -- thanks for updating, and sorry I missed your original post.

So you know for next time, if you create a new thread, we are more likely to see it. Also, did you notice the "Errors" node in the QdabraRules data source? That can help with trouble shooting -- it will return any errors.