SharePoint Integration

Re: UpdateListItem SP

Hilary Stoupa — Tue, 27 Jul 2010 20:14:47 GMT

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.

Re: UpdateListItem SP

stuartward — Tue, 27 Jul 2010 19:48:52 GMT

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

Re: UpdateListItem SP

stuartward — Tue, 27 Jul 2010 02:26:37 GMT

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

Re: UpdateListItem SP

Hilary Stoupa — Mon, 24 May 2010 15:15:51 GMT

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!

Re: UpdateListItem SP

rmertz — Sat, 22 May 2010 02:57:04 GMT

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.

Re: UpdateListItem SP

rmertz — Sat, 22 May 2010 00:28:15 GMT

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

Re: UpdateListItem SP

Hilary Stoupa — Fri, 21 May 2010 21:30:02 GMT

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

Re: UpdateListItem SP

rmertz — Fri, 21 May 2010 21:14:15 GMT

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)

Re: UpdateListItem SP

Hilary Stoupa — Fri, 21 May 2010 20:30:05 GMT

That definitely shouldn't be happening. Are you showing your ID in your form, so you can compare it to your SharePoint list? You don't have any other rules that might be setting that field back to blank, do you?

Re: UpdateListItem SP

rmertz — Fri, 21 May 2010 20:18:13 GMT

ok. I get the ID of my list item.But if I change a field after the initial submission I get a new submission. I doesn't update the item.

Re: UpdateListItem SP

rmertz — Fri, 21 May 2010 20:08:34 GMT

Do I need a "receive" data connection from the SPlist as well?

Re: UpdateListItem SP

rmertz — Fri, 21 May 2010 19:54:56 GMT

Using the example above I get the following error.

"Failed to select node for Sharepoint List ID"

Re: UpdateListItem SP

Hilary Stoupa — Fri, 21 May 2010 19:50:26 GMT

Are you submitting repeating items? From your xpath, I'd guess "yes" -- is my:item the repeating group? If so, try my:ID. What you want to see is after submitting to your list, your ID should get populated with the ID number of the new SharePoint list item....

Re: UpdateListItem SP

rmertz — Fri, 21 May 2010 19:44:11 GMT

Yes I'm using qRules.

So just that I'm clear. I replace the parameter shown in your blog (/id=my:id) with the full Xpath to my specific ID (i.e. /my:RMADetail/my:RMAItems/my:item/my:ID).

Re: UpdateListItem SP

Hilary Stoupa — Fri, 21 May 2010 14:41:18 GMT

Are you using qRules? That is the product used in the blog post for submitting items to a SharePoint list. If you are using qRules, you can add the XPath to your Id field as a parameter for the rule command, so that it will get populated with the SharePoint Id field when the items are submitted to the list -- that provides a link which will allow you to update the list items from the form.