Populating form data from SharePoint List Views

re: Populating form data from SharePoint List Views

wmhogg007 — Tue, 23 Jan 2007 01:00:48 GMT

Hi,

It may be just my browser, but it appears that the URL examples seem to be truncated. Could you re-post the full URLs in the comments section?

Thanks,

William H

re: Populating form data from SharePoint List Views

infopath — Tue, 23 Jan 2007 01:45:17 GMT

Sure:

1) http://contoso/sites/sales/_vti_bin/owssvr.dll?Cmd=Display&List={GUID}&XMLDATA=TRUE

2) http://contoso/sites/sales/_vti_bin/owssvr.dll?Cmd=Display&List={115BC7B7-0A82-403E-9327-F3C73E6D37F3}&XMLDATA=TRUE&FilterField1=xd__x007b_52AE1EF8_x002d_28E7_x002d_4CE4_x002d_AE23_x002d_54E23E80DDB5_x007d_&FilterValue1=Approved

re: Populating form data from SharePoint List Views

raymedia — Mon, 29 Jan 2007 09:39:49 GMT

Hi there. Thank you so much for the tips. It worked for me really well..until I convert the view page to XSLT Data View in FP.

I had to convert it so I could use the grouping filter in FP.

ie) a and (b or c).

When I open the *.iqv file, it launched the excel but then give a alert saying "Unable to open"

I thought it may caused by typo but when I tired again..before and after convert the webpart, it clearly does not like that.

Could you please advise me on this matter?

re: Populating form data from SharePoint List Views

sudhir.kesharwani — Mon, 28 May 2007 14:17:55 GMT

Hi,

Superb article, it gave me answers for most of the doubts that i had in my mind :)

I just want to know if we can dynamically alter URL for secondary data source.

Say i want to create filter based on the values selected in another field of my infopath form...

is it possible ....

Regards,

Sudhir Kesharwani

re: Populating form data from SharePoint List Views

smckeon — Fri, 07 Sep 2007 05:45:16 GMT

That’s great! And you can get a preview of the filter just by popping it into a URL and check it out. Except.. How do you handle special Characters? I have a SP list with a column that looks up into another list. That’s the field I want to filter. So my filter string looks like this:

&FilterField1=Customer&FilterValue1=3;#New England Bio Labs

This above filter doesn’t work. I suspect that it’s because of the ID and delimiter at the beginning ie: “3;#”.

Any suggestions?

re: Populating form data from SharePoint List Views

dtr18c — Wed, 03 Oct 2007 20:05:52 GMT

http://contoso/sites/sales/_vti_bin/owssvr.dll?Cmd=Display&List={115BC7B7-0A82-403E-9327-F3C73E6D37F3}&XMLDATA=TRUE&FilterField1=xd__x007b_52AE1EF8_x002d_28E7_x002d_4CE4_x002d

How might I apply an XSL style transformation on the returned xml?

re: Populating form data from SharePoint List Views

sumedha — Mon, 17 Dec 2007 13:36:00 GMT

Sorry for asking such basic question but I need exactly what has been mentioned in this article. I have created the url and the data connection but I dont know how to show it on the form. Could anyone please ellaborate on this.

thanks!!

re: Populating form data from SharePoint List Views

sumedha — Mon, 17 Dec 2007 13:49:29 GMT

the url I am using is

http://mossvpc:1586/_vti_bin/owssvr.dll?Cmd=Display&List=%7BD66DCB51%2D80B0%2D43AB%2DB80B%2DCD7D23E63B09%7D&View=%7B6D0CEF69%2DF899%2D40D0%2D86B2%2D6E01CC7D9CA1%7D&XMLDATA=TRUE

I hv extracted it the same way as given above

re: Populating form data from SharePoint List Views

c10 — Fri, 16 May 2008 23:23:05 GMT

Is there a limit on the number of elements a share point list can have?

I have a list with around 300 items (rows) and 4 columns but when i try to use this list to bind to drop down column i get only about 100 returned.

Is there a way to oversome this?

re: Populating form data from SharePoint List Views

infopath — Fri, 16 May 2008 23:35:48 GMT

Hi c10,

Is there a limit on the number of elements in a SharePoint list? There may be - but you may want to post that question to a SharePoint blog.

However, the behavior you are seeing in InfoPath is expected. The items that are returned in a data connection are based on the default View in SharePoint. Each view in SharePoint, by defauly, limits the number of items to display to 100 - hence you only get 100 items returned.

To workaround this:

- Navigate to your SharePoint list

- From the View dropdown choose Modify this view

- Scroll to the bottom and expand the "Item Limit" section

- Change 100 to something larger than what you would expect this list to store (i.e. 500, 1000, etc.)

I hope this helps!

Scott

re: Populating form data from SharePoint List Views

wsmallwood — Thu, 12 Jun 2008 18:39:59 GMT

Hi, I am very new with Infopath, so I apologize for the simplicity of the question. I am using this code to essentially create a sharepoint/infopath based mail merge. It is working GREAT, except I can't move to the next record. Any suggestions?

Thanks in advance!

Wendy

re: Populating form data from SharePoint List Views

mattmw24 — Fri, 01 Aug 2008 02:16:31 GMT

Can I put a variable in the URL - i.e. a field in the InfoPath form? That way the filtered value in the URL is populated by a choice the user makes on the form? I'm trying to populate a repeating table from a SP list that only includes the items in the list for what they select. So if the list contains detail for all projects, when they choose a project on the form, the repeating table is populated with only the detail for the project chosen. I've seen examples using custom code, but I don't have VS tools for Office and I thought this would be possible out of the box. Am I wrong?

Thanks,

Matt

re: Populating form data from SharePoint List Views

kristina.fitzgerald — Thu, 28 Aug 2008 21:09:37 GMT

Hello,

I'm experiencing a weird behavior with the way the data connection is reading the XML file in my drop down controls. When I attempt to set the "Entries" field to "z:row", I am prompted with the error "You must select a repeating group or field."

I have another form where I followed the same directions you outlined above, but I generated a resource file, and the "z:row" field is indeed a repeating field and works just fine.

Is there a reason why this data connection is pulling the "z:row" field as a non-repeating? Am I missing a step? Thanks in advance - K

re: Populating form data from SharePoint List Views

jhillppc — Mon, 09 Feb 2009 21:50:36 GMT

Hello - looks like it's been a little while since others have posted, but thought I would ask anyway. We're trying to include a multi-line column from a list into an Infopath form. I successfully generated the url as shown above, and the url does return xml data in a browser. The url looks something like this: http://oursite.com/ocio/cis/gitmeet/_vti_bin/owssvr.dll?Cmd=Display&List={7B30642C-A7E2-44AF-95C2-4AFF5E13461B}&XMLDATA=TRUE

However, when trying to create a Receive data connection in Infopath, the wizard will not accept the url -- "unable to connect to the sharepoint site."

Thanks.

re: Populating form data from SharePoint List Views

infopath — Tue, 10 Feb 2009 00:22:10 GMT

Hi jhillppc,

Are you able to connect to a list (on the same site) that does not contain a multi-line column? I don't believe this is an issue with that column type as I can connect in InfoPath and display the multi-line data without issue so something else may be occurring.

Are you familiar with the network tracing tool Fiddler? You can get it here (http://www.fiddler2.com/fiddler2/version.asp - click the Install Fiddler2 link) and then you can start this while trying to create the connection. This is a network tracing tool but it only traces HTTP traffic. Maybe what you see in this trace will point you in the direction of the issue.

Scott

re: Populating form data from SharePoint List Views

jhillppc — Thu, 12 Feb 2009 00:07:56 GMT

Hi, Scott - thanks for the reply. I will try Fiddl'ing.

Jan

re: Populating form data from SharePoint List Views

jhillppc — Fri, 13 Feb 2009 01:18:35 GMT

Scott - I was able to successfully create the data connection to the list with the URL, but the multi-line field is still missing. I tried your suggestion of setting up a data connection to another list with multi-line columns, and bingo, those columns are selectable.

Another one of those mysteries. Thanks for the Fiddler link--it pointed out to me that while http: worked in IE, I needed https in Infopath. Duh. But still no multi-line column from the list I need--all the other columns are there, waiting to be selected. Sigh.

Thanks again for the tips.

Jan

re: Populating form data from SharePoint List Views

infopath — Fri, 13 Feb 2009 01:25:08 GMT

Hi Jan,

Anything different (property wise) with the multi-line column in the list that fails?

Scott

re: Populating form data from SharePoint List Views

jhillppc — Fri, 13 Feb 2009 16:36:58 GMT

Happy Friday, Scott - the multi-line column that I was able to retrieve is set to plain text, 5 lines. The missing column is set to rich text, 15 lines. So, I added a new multi-line column, went to Infopath and created the data connection, selected the new column, and voila, it appears as it should. Set the field in the Infopath form to wrap, and all is well. Finally. Don't know why it took so long to think of that option, but at least we have a solution.

The "failing" column was chosen from existing site columns, All Groups, as there are no options to change it to another information type (single line, choice, number, etc).

Thanks again for your guidance.

Take care,

Jan

re: Populating form data from SharePoint List Views

MiniSvlad — Wed, 18 Mar 2009 23:22:03 GMT

Good article... I've created my data connection into a list, but the field that I want to display in my InfoPath dropdown is a calculated field in the list. It won't give me the option to show that field.

re: Populating form data from SharePoint List Views

jccarvalho — Wed, 15 Apr 2009 11:57:06 GMT

Hi,

good article.

I've created my data connection, and works fine, but, in a calculated field display "string;# " in the begging of the field. How i can remove this? thanks

re: Populating form data from SharePoint List Views

infopath — Wed, 15 Apr 2009 18:27:24 GMT

Hi jccarvalho,

This can be done but you will need to hand-modify the transform (the XSL file) for the View where you are using that connection.

Before you try these steps with your XSN, please make a back up copy of your XSN!! :)

NOTE: These steps assume you are using the data connection as the source for a dropdown box.

1) Create a new, blank XSN

- Add the data connection to your list

- Add a dropdown box to the View

- For the "Entries" property of the dropdown, select the "z:row" node from the data connection

- For the Value and Display Name properties, select your calculated column

- Save the XSN as: Test.XSN

2) Create a new folder on your Desktop called: TestXSNSourceFiles

3) With Test.XSN open in Design View, from the File menu choose Save As Source Files and save these to the new folder, TestXSNSourceFiles

4) In the TestXSNSourceFiles folder, open "View1.xsl" with Notepad

5) You need to now locate the XSL for the dropdown box - it will lool similar to this (NOTE: my calculated column is called: calcDate and you see it here as: ows_calcDate.)

<xsl:attribute name="value">

<xsl:value-of select="my:field1" />

</xsl:attribute>

<xsl:choose>

<xsl:when test="function-available('xdXDocument:GetDOM')">

<xsl:variable name="val" select="my:field1" />

<xsl:if test="not(xdXDocument:GetDOM("MyList")/xml/rs:data/z:row[@ows_calcDate=$val] or $val='')">

<xsl:attribute name="value">

<xsl:value-of select="$val" />

</xsl:attribute>

<xsl:value-of select="$val" />

</option>

</xsl:if>

<xsl:for-each select="xdXDocument:GetDOM("MyList")/xml/rs:data/z:row">

<xsl:attribute name="value">

<xsl:value-of select="@ows_calcDate" />

</xsl:attribute>

<xsl:if test="$val=@ows_calcDate">

<xsl:attribute name="selected">selected</xsl:attribute>

</xsl:if>

<xsl:value-of select="@ows_calcDate" />

</option>

</xsl:for-each>

</xsl:when>

<xsl:otherwise>

<xsl:value-of select="my:field1" />

</option>

</xsl:otherwise>

</xsl:choose>

</select>

6) There are 4 places in this snippet where you need to implement the "substring-after" function on the calculated field. In short what this function will do is return everything "after" the "string;#" part of the returned column:

<xsl:attribute name="value">

<xsl:value-of select="my:field1" />

</xsl:attribute>

<xsl:choose>

<xsl:when test="function-available('xdXDocument:GetDOM')">

<xsl:variable name="val" select="my:field1" />

<xsl:if test="not(xdXDocument:GetDOM("MyList")/xml/rs:data/z:row[substring-after(@ows_calcDate, "#")=$val] or $val='')">

<xsl:attribute name="value">

<xsl:value-of select="$val" />

</xsl:attribute>

<xsl:value-of select="$val" />

</option>

</xsl:if>

<xsl:for-each select="xdXDocument:GetDOM("MyList")/xml/rs:data/z:row">

<xsl:attribute name="value">

<xsl:value-of select="substring-after(@ows_calcDate, "#")" />

</xsl:attribute>

<xsl:if test="$val=substring-after(@ows_calcDate, "#")">

<xsl:attribute name="selected">selected</xsl:attribute>

</xsl:if>

<xsl:value-of select="substring-after(@ows_calcDate, "#")" />

</option>

</xsl:for-each>

</xsl:when>

<xsl:otherwise>

<xsl:value-of select="my:field1" />

</option>

</xsl:otherwise>

</xsl:choose>

</select>

7) Once you have made the changes described above, save and close your Notepad file.

8) Right-click on manifest.xsf in the folder and choose Design

9) From the File menu choose Save As and re-save this as your Test.xsn

10) Preview the form - result: your calculated field should only show the actual values!

As you can imagine, any errors in the changes you make in the XSL could cause your form to no longer open - hence my guidance on having a backup copy! :)

I hope this helps!

Scott

re: Populating form data from SharePoint List Views

jccarvalho — Wed, 15 Apr 2009 19:07:04 GMT

Hi Scott,

thank's for your quick responde. I'll try.

João

re: Populating form data from SharePoint List Views

jccarvalho — Thu, 16 Apr 2009 00:23:52 GMT

Hi Scott,

many thanks. it's works very well.

regards,

João

re: Populating form data from SharePoint List Views

gp28 — Mon, 20 Apr 2009 15:59:09 GMT

Hi.

I'm relatively new to Infopath and Sharepoint and the example described above is exactly what I am trying to achieve.

I can filter the fields and return the xml to a drop down list ok. From the filtered fields I am populating a repeating table.

My problem is the text being returned contains html tags, <div> text </div> or 1,#Name.

I also don't really understand your statement in the example:

"Note: be sure to remove the “ows_” from the beginning of the FilterField ID." or how to achieve this.

Any help would be welcome. Thankyou

GrahamP

re: Populating form data from SharePoint List Views

doubleH — Tue, 21 Apr 2009 19:18:19 GMT

This is a great post! I can't find the "Modify settings and columns" area. Does this apply to WSS?

re: Populating form data from SharePoint List Views

infopath — Tue, 21 Apr 2009 23:06:21 GMT

Grahamp - what are the data types of those columns in SharePoint?

doubleH - "Modify Settings and Columns" was the terminolgy used with SharePoint 2003. In 2007, simply navigate to your list and from the "Settings" menu choose "List Settings."

Scott

re: Populating form data from SharePoint List Views

doubleH — Wed, 22 Apr 2009 16:30:43 GMT

Thanks Scott. Here is the URL I am trying to use...

http://lynx/_vit_bin/owssvr.dll?/?Cmd=Display&List={%7B609688A9%2D3FBA%2D4FA6%2DAF27%2D695DF7422F40%7D}&XMLDATA=TRUE

I am getting an error...

The following file(s) have been blocked by the administrator: /_vit_bin/owssvr.dll

Any ideas on how to correct ?

re: Populating form data from SharePoint List Views

infopath — Wed, 22 Apr 2009 20:22:16 GMT

Hi doubleH,

Hmmm...I have never seen this error before when using this sample. You may want to post this to a SharePoint blog to see if they can offer any suggestions as to where to look to identify the cause of the error.

Scott

re: Populating form data from SharePoint List Views

gp28 — Sun, 26 Apr 2009 10:37:26 GMT

Hi Scott

I'm using rich text and lookup data types. I've changed the rich text to plain text and that seems to work fine, however I need to use the lookup value in sharepoint and can't change this.

Is there a way around using the lookup and returning the value which is a name in this case without the 1,# prefixing the name.

Thanks

Grahamp

re: Populating form data from SharePoint List Views

infopath — Mon, 27 Apr 2009 15:38:02 GMT

Hi Grahamp,

Yes - you will need to hand-modify the View (the XSL file) that contains the control (i.e. the dropdown) that is showing the values.

Take a look at the steps I provided to jccarvalho on Wednesday, April 15, 2009 11:27 - these are the same steps you will need to complete.

Scott

re: Populating form data from SharePoint List Views

adayuen — Thu, 11 Jun 2009 13:13:20 GMT

How to connect to a XML file or SharePoint list sized at around 5500 records in browser-enabled Infopath form 2007

Dear All,

I have a data file which contains around 5500 records of user data. I created two data connections -one to very huge XML file and another to very huge SharePoint list. However both can't work in Browser form due to server timeout or what ever make the server can't response. Once I cut it 1/4 in size of records then it wokrs hence I guess this is due to too many records.

I am wondering if there is anyway to connect to a single database file size @5500 records in browser-enabled InfoPath form? I don't have the SQL server.

Please help!

Regards,

Ada

re: Populating form data from SharePoint List Views

gp28 — Thu, 25 Jun 2009 09:36:50 GMT

Hi Scott

My previous posts are all working fine. Thanks a lot for the help.

Would you know how I can populate a drop down box from a sharepoint list, or even a built in list, to return "active" hyperlinks. Or use a graphic, like a GO button once the item is selected from the drop down list.

I only have 2 or 3 links per item which are intended to link to a procedure, form or word document which are all sitting in sharepoint library. Thanks

Grahamp

re: Populating form data from SharePoint List Views

infopath — Thu, 25 Jun 2009 15:13:44 GMT

Hi Grahamp,

Here is something I just tested that, I think, is close to what you are asking:

- Created a list that contains a column of type "Hyperlink"

- Added some items to the list where the hyperlink column points to different documents on my site

- Added a Receive data connection from my InfoPath Form Template to this list and I am able to get the hyperlink column

- Added a Dropdown Listbox control to the template, set the source to this data connection and then set the "Value" property for the dropdown to the hyperlink column and set the "Display" property to the Title column

Now, when I select an item from the dropdown listbox what is being stored is the hyperlink to the document. What you cannot do "out of the box" is once an item is selected, automatically navigate to the selected link. You could use code for this or you could simply add a "hyperlink" control next to the dropdown listbox so once an item is selected, the hyerplink control will show the address and allow the user to click on the link.

In testing this I found that the data connection retrieves both the "address" and "description" properties for the hyperlink. In my case, I left both of these as the URL so in the hyperlink control on the form template, instead of just pointing it to my field (i.e. field1) I needed to use the following expression so it would only display one URL:

substring-before(my:field1, ",")

I hope this helps!

Scott

re: Populating form data from SharePoint List Views

gp28 — Fri, 26 Jun 2009 01:16:41 GMT

Thanks Scott

The receive data connection works fine and the title of the document is displayed in the drop down box.

I added the hyperlink control and edited it to select the data source (my:field1). With or without the substring the value returned is always, http://address/ and will not activate the hyperlink.

Any ideas?

Grahamp

re: Populating form data from SharePoint List Views

gp28 — Fri, 26 Jun 2009 11:32:10 GMT

Scott

Update to my last post

All works fine if I simply insert a hyperlink control using text. The problem occurs if I insert a graphic and then apply the hyperlink to read the field1 data source. The link simply reverts back to read the address field which is not populated. Thanks

Grahamp

re: Populating form data from SharePoint List Views

infopath — Fri, 26 Jun 2009 14:56:30 GMT

Hi Grahamp,

What do you mean by "insert a graphic?" Can you provide me the steps you are following?

Thanks,

Scott

re: Populating form data from SharePoint List Views

gp28 — Fri, 26 Jun 2009 23:54:59 GMT

Hi Scott

Sorry, I wasn't very clear.

I'm using an image of a "GO" button in a cell next to the drop down list. The image is simply pasted into the cell and then I apply a hyperlink to the image that reads the value in the drop down list.

Users select from the list and then the GO image to get the document.

Hope this explains it better. Thanks

Grahamp

re: Populating form data from SharePoint List Views

infopath — Sat, 27 Jun 2009 00:32:55 GMT

Hi Grahamp,

Hmmm...this is working for me. Here is what I have:

- Data connection to my SharePoint list where I have a "hyperlink" field defined where each one points to documents on my site

- Dropdown box that uses this data connection as its source. I have the "Value" property set to my hyperlink field and the "Display" property to the Title field

- I copied and pasted an image to my form template and set the hyperlink as follows:

- Link to: Datasouce: substring-before(my:field1, ",")

- Display: This was auto-set to "<< Selection in document>>"

Now, what may be key here is what is being returned from your list. Drag the node that the dropdown box is bound to your View again but this time as a text box. Preview the form and make a selection - is the correct URL being returned? Again, in my case I was getting the URL returned twice as: URL, URL - this is why I needed to use the "substring" function.

Scott

re: Populating form data from SharePoint List Views

gp28 — Sat, 27 Jun 2009 03:15:01 GMT

Scott

I checked the links and all are being returned correctly. Exactly as you described above I pasted an image and set the hyperlink to the Datasource.

However before previewing I rechecked the hyperlink and find the "Link to: value has changed and the Adress is now selected displaying "http://address" with the Datasource greyed out.

Totally confused?

Grahamp

re: Populating form data from SharePoint List Views

infopath — Sat, 27 Jun 2009 03:28:34 GMT

Hi Grahamp,

Well on the positive side...at least we know why the link does not work! :)

Let's look at something else: are you using the method described in this post to retrieve the fields from your list? If so, I was not - I was just using a standard SharePoint list data connection so I may need to try this method to see if there is any difference in the result. Also - how did you create the hyperlink column in SharePoint? Was it just adding a hyperlink column to your library or was it a site column? Can you provide me with a sample URL that you have in one of those fields?

Scott

re: Populating form data from SharePoint List Views

gp28 — Sat, 27 Jun 2009 04:29:07 GMT

Scott

Again like you I am using a standard Sharepoint list data connection, but will be using the method described in this post to filter the data when all is running.

In the Drop down list box properties I have tried all 3 methods of linking the data source in the "List box entries" section all with the same result. The drop down works well and the correct data is returned. If I insert a hyperlink anywhere on the form view using the "Data source" as my:field1 and the "Display" as text all works perfectly well.

Using an image and adding a hyperlink with a data source is where it falls apart.

I have created a Links library in Sharepoint to handle the data required to be filtered and returned to various types of forms.

Would you please look at entering the links manually in the drop down box, then paste and hyperlink an image to the drop down to see if you get the same result. Somehow I can't believe this is a Sharepoint issue.

There's a 12 hour time difference between us so I'll follow with a sample url later if still required.

Many thanks Scott

Grahamp

re: Populating form data from SharePoint List Views

gp28 — Sat, 27 Jun 2009 04:49:19 GMT

Scott

FYI I managed to find this link describing the same problem

http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.infopath&tid=bb848d55-6ce1-4605-99bf-6a3ced937e31&cat=&lang=&cr=&sloc=&p=1

Grahamp

re: Populating form data from SharePoint List Views

infopath — Mon, 29 Jun 2009 15:19:20 GMT

Hi Grahamp,

I read the post you found and have tried hard-coding the URL's in the dropdown as well as first hard-coding the hyperlink on the image and then switching back to binding the hyperlink to "field1" and in all cases, this is just working for me.

I am still concerned though over the way you are phrasing what you asked me to do: "Would you please look at entering the links manually in the drop down box, then paste and hyperlink an image to the drop down to see if you get the same result".

For this request, here is what I did:

- Changed my dropdown box to "Enter list box entries manually"

- I then entered two URL's to two different documents on my server. I set the "value" to the URL and the "Display" to some dummy text (here are my URL's: http://myservername/FileAttachments/SomeTextFile.txt and http://myservername/FileAttachments/SomeWordDoc.docx)

- I had already pasted an image to my form in the following manner:

- Navigated to C:\WINDOWS\Web

- Right-clicked on the "exclam.gif" file and chose Copy

- Right-clicked in my layout table cell and chose Paste (I have a layout table on my View with 1 row and 2 columns. The first column has the dropdown and then second column contains this pasted image)

- I right-clicked on the image and chose Hyperlink

- In the "Link To" option I chose Data Source and selected my "field1" and clicked OK

I then Preview the form, select either option from the dropdown, click my image and the appropriate document opens.

Is there anything here that is different than what you are doing?

Scott

re: Populating form data from SharePoint List Views

gp28 — Mon, 29 Jun 2009 16:17:18 GMT

Hi Scott

Aaaha it works but don't ask me why!

The only thing that we are doing differently is that I am selecting Insert > Picture> From File and you are copying and pasting.

Infopath will not let me paste a copied image from the clipboard onto the view, all options to cut, copy and paste are greyed out.

When I copy an image already in my view and paste it into the required cell it works fine.

So the operative word here is "paste" Any ideas why?

Grahamp

re: Populating form data from SharePoint List Views

infopath — Mon, 29 Jun 2009 16:28:37 GMT

Hi Grahamp,

Very odd - I just tried the same method: Insert | Picture | From File and it still works fine.

I have not seen an issue before where you could not paste an image into an InfoPath View while in Design View. I hate to ask this question (especially on a public forum <g>) but does the same behavior occur if you reboot, which will clear your clipboard?

At any rate, there is something to be said for "if it's not broken, don't fix it" <g> now that it is working! :)

Scott

re: Populating form data from SharePoint List Views

gp28 — Tue, 30 Jun 2009 12:05:11 GMT

Hi Scott

I was wondering if I should feel embarrased, but no the problem remains. I think enough said and I'll just work around it.

Many thanks for your help. Now back to reality!

I have a sharepoint list with 7 columns plus an ID col. I am using the method described in this post to populate a repeating table with information contained in 3 of the columns.

2 other columns plus the ID are used to filter the list information into the appropriate form. All works well.

Information for the remaining 2 list columns is to be entered by the user in the form and submitted back to the sharepoint list to close the loop and allow reporting of the action taken.

I have read your article on submitting to a sharepoint list but am having problems modifying the process to suit my application. Any help would be appreciated.

Grahamp

re: Populating form data from SharePoint List Views

infopath — Tue, 30 Jun 2009 15:28:19 GMT

Hi Grahamp,

Sorry I was not able to fully help on the hyperlink...obviously something is still different in our scenarios but not sure what.

In regard to submitting to a SharePoint list, you will need to review all the comments as well in that post. Typically custom code is used to do anything other than an "add" and in my post there is sample code to perform an update and delete. (In fact, I think the sample code handles all options: add, update and delete.)

The reason code is used is you need to know which list item you want to update or delete and this is done by the SharePoint ID for the specific list item. Granted you may be able to get what you need without code but this is one of those scenarios where, personally, I feel it is easier to use code to do what you need.

If you have any additional questions on updating a SharePoint list, please be sure to post them on that blog.

Scott

re: Populating form data from SharePoint List Views

Louie1 — Sun, 19 Jul 2009 03:29:54 GMT

Is there a way to wrap text in an infopath drop down box? The pox is populate by a SharePoint list.

thanks, Lou

re: Populating form data from SharePoint List Views

jboling — Thu, 13 Aug 2009 21:47:17 GMT

@ kristina.fitzgerald (Thursday, August 28, 2008 2:09 PM):

I had the same problem, and am disappointed with the solution. Infopath would not recognize my source view's data row as a repeating entry until I had more than one entry in the view. That is very lame if you ask me.

---------------------------------------------------------------------------

Original post:

Hello,

I have another form where I followed the same directions you outlined above, but I generated a resource file, and the "z:row" field is indeed a repeating field and works just fine.

Is there a reason why this data connection is pulling the "z:row" field as a non-repeating? Am I missing a step? Thanks in advance - K

re: Populating form data from SharePoint List Views

RandySt — Mon, 16 Nov 2009 22:00:39 GMT

Thank you for all of the great information so far. I have been able to set up that connection and retrieve data that I have populated into a drop down list. At this point, I am trying to create a rule to auto-populate other fields in my form based off of the selected value in the drop down list. I past instances where I create a normal connection to Sharepoint, I would use a rule similar to...

Field: hoursCharged

Value: @hoursCharged[@projectID=projectID]

This worked fine but when I try the same type of formula in the value field using an XML connector ti will not work. Any suggestions?

re: Populating form data from SharePoint List Views

wizardntexas — Sun, 27 Dec 2009 21:07:09 GMT

Do you know of a way?

user opens form, populates fields, infopath dropdowns are selected,form submitted. How do you take the information from this form and subtract it from the list used in the dropdown. So the next user will not have access to the items the previous user selected? Or for a lack of a better term checked out but not to be confused with checking forms in or out from sharepoint. I find nothing but limitations with these collaborating tools? Infopath and sharepoint?

please advise?