Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / March 2007

Tip: Looking for answers? Try searching our database.

Tip on populating SharePoint list with InfoPath form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bob Zmuda - 09 Mar 2007 05:48 GMT
I have a SharePoint list that I wanted to populate with data from an InfoPath
form. Originally, I used the previously suggested method of CAML and VB or C#
code (detailed at
http://enterprise-solutions.swits.net/infopath2007/article.php?t=programmaticall
y-add-item-sharepoint-calendar-infopath&c=infopath2007

and
http://www.infopathdev.com/howto/tutorials/default.aspx?i=7bc880f391b84ea9b3b45c
6fbecc07c6
).
This method, however, proved to be unnecessarily cumbersome. I've found what
I consider to be a superior method: SharePoint workflows. You can create and
update SharePoint list items using this method:

1.) Create a SharePoint form library.
2.) Create an InfoPath form with whatever fields you want to send to a
SharePoint list.
3.) Configure a button to submit the form to the previously created form
library.
4.) Publish the form to the library, making sure to map to columns whatever
fields you want to send to the list.
5.) Open the library in SharePoint Designer and create a new workflow.
6.) Set the workflow to run on new items.
7.) Configure the first step in the workflow to create a list item.
8.) Map the fields from the current item, your InfoPath form, to the
appropriate SharePoint list.

Now all you need to do is fill out the form and click the submit button. The
fields you mapped in the workflow will automatically populate the list. I
apologize if this has already been pointed out.
Zhang Haiguang - 10 Mar 2007 15:57 GMT
Thank You!

>I have a SharePoint list that I wanted to populate with data from an
>InfoPath
[quoted text clipped - 28 lines]
> fields you mapped in the workflow will automatically populate the list. I
> apologize if this has already been pointed out.
Anders J - 10 Mar 2007 22:24 GMT
Thanks for sharing

Anders

>I have a SharePoint list that I wanted to populate with data from an
>InfoPath
[quoted text clipped - 28 lines]
> fields you mapped in the workflow will automatically populate the list. I
> apologize if this has already been pointed out.
S.Y.M. Wong-A-Ton - 19 Mar 2007 08:53 GMT
Thanks for the great tip! I haven't tried it out yet, but it looks promising,
at least for MOSS 2007.
---
S.Y.M. Wong-A-Ton

> I have a SharePoint list that I wanted to populate with data from an InfoPath
> form. Originally, I used the previously suggested method of CAML and VB or C#
[quoted text clipped - 22 lines]
> fields you mapped in the workflow will automatically populate the list. I
> apologize if this has already been pointed out.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.