InfoPath Dev

Hi. I am trying to submit a file attachment to a SP 2010 list using the AttachToSharePointList command found in qRules. I am going step by step through the documentation on how to do this (http://www.infopathdev.com/files/folders/qrules/entry59157.aspx) but get the following error:

An error occurred adding the attachment: List does not exist. The page you selected contains a list that does not exist. It may have been deleted by another user.

 The list I have defined in the data connections exists. I have checked spelling and everything but continue to get this error.  Please help!

Please help!

Are you adding the attachment to an existing list item or using the command in conjunction with SubmitToSharePointList?

Hi Hilary,

I am attempting to use the command to insert a new item to a list. Do I need to use the SubmitToSharePointList command to first create an item in the list and then use the AttachToSharePointList command to add an attachment?

-Steven 

You can use the SubmitToSharePointList command and include parameters to include an attachment with your list item. What version of qRules are you using?

I am using Qrules version 4.0.

My InfoPath form saves data to multiple SP lists. There is a primary list that stores some basic information returned from the InfoPath form. In addition to this, I have a secondary list in which I want to save file attachments. The secondary list has a column that stores the ID value from the primary list so multiple file attachments can be mapped back to the primary list. The secondary list is using primary lists ID value in the way a foreign key would be used in a database to map data to a primary table.

When I submit my form, I have most of the data in my form being stored in the primary table and sent their via the SubmitToSharePointList command. From there, I am able to collect the SharePoint List ID from the primary list. I would like to take that ID and submit a repeating section of file attachments into the secondary list along with this ID. Should I use another SubmitToSharePointList command to submit the file attachments or am I on the right path with attempting to use the AttachToSharePointList command?

Well, let me clarify a few things first -

1. The AttachToSharePointList command, on its own, requires an existing list item.
2. You can include attachments with the SubmitToSharePointList command.
3. List items allow multiple attachments.

So, with that in mind, it seems like you would not need a secondary list for your attachments - why not just save them with your primary list item?

To include attachments with your SubmitToSharePointList command, you need to include the following parameters:

o dsname (optional): data source for AddAttachment Method (SharePoint Lists Web Service) – include if submitting attachments with your list items.

o xpath (optional): XPath to attachment field.

 If you are submitting repeating data to the list, the /xpath parameter needs to be relative to the repeating node (like the /id parameter).

Thank you for this suggestion. I think I am having trouble with the relative xpath I am using.  This is the xpath to my files (field2) is  /my:myFields/my:SupportDocumentation/my:group2/my:File_Attachment/my:field2). My form submits but no file attachments appear in the list. If /my:FileAttachment is the repeating node, would the relative xpath value be /my:field2?  

Is your mapping to group2? That is, are you submitting all the data in group2 to your list?

If so, the relative path would be my:File_Attachment/my:field2 - it would need to be relative to group2.

Hilary, you are my favorite person this morning! I finally have this working :)

 Thank you!

Hey, that's great! Glad you are up and running - have a great weekend.