.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

How to prevent automatic update from sharepoint list on Infopath 2007 form

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :SharePoint
Hi there, I've got an Infopath 2007 form on MOSS 2007. I have a custom list in sharepoint and the infopath form has a data connection to that list to receive data. Is there any way to prevent automatic update on the values in the form that is received from the list. I'd like the new form to have updated info received from the list. However, the old/existing forms that were created should have the data that were available at the time when the form was created. Let me know if this is not clear and I'll try to explain more. Thanks,Pman http://www.pmansLab.com/

View Complete Post

More Related Resource Links

update SharePoint list with data from infopath form using the Command Prompt or similar


i have a InfoPath form that is updating a SharePoint list when it is submitted. Now i added some extra Fields to the Sharepoint List. All these new Fields are empty till I open the InfoPath form and hit the submit buttion again.

Is there a way to update all the empty fields from the old entrys I made.

My first Idea was to search for a Powershell Solution but unfortunately I am using Windows Server 2003 R2, Sharepoint 2007 and IndoPath 2007.

Hopefully someone can Help ;)

thanking you in anticipation

How to read a column of a sharepoint list to a text string field of infopath form?

My infopath form used to read these email addresses from a web service and web.config file. Now i would like to get these user email addresses from a contact list in a sharepoint server. I am trying to do this without writing any codes. Here is what i have done so far: 1. Adding a new "data connection to receive data from SharePoint library or List" where i selected Email Address column of the contact list. 2. I added a new Text Field and define a new rule with "Query using a data connection" defined above. When i try to access the newly created Text field above it always return empty as if the Query attached to it did not executed at all. What did i do wrong? Is there a better way? Thank you in advance for your help.

Submitting InfoPath data to a SharePoint 2007 List

Clayton, i sure hope you get this.  I would like to let the form get published to the form library and then workflow can create the new list item with all the required metadata mapped.  if data is updated i would like for the list item data to update as well.  currently i have an infopath form that is web-enabled.  i several views based on a status field as which view to open to.  this form have drop-down fields linked to list already on the sharepoint site.  i have tried using the "Submitting Data from Infopath 2007 to Sharepoint List" and it works as designed but unfortunately i cant customize the fields.  i need a dynamic user friendly form with drop downs etc.  any suggestions?

Updating an InfoPath Form Library Template breaks preexisting SharePoint List Views

When updating an InfoPath template (e.g. adding a new field), any views I have created on the library lose their filters and sorting, as if the columns on which they were built no longer exist.  Has anyone else encountered this and, if so, is there a solution? V/r Noelle

submit infopath 2003 form to a sharepoint list

hi, is it posible to add  an infopath 2003 form to a sharepoint list, not document library but a list. and can i create views from the infopath 2003 form?

Infopath Form Data submitting to Sharepoint 2010 List

Making a Client intake form that once submitted will send data to  a sharepoint 2010 List called contacts. Short Summary the form will have repeating fields and alot of information to submit. I have looked and read all over but I cannot find an easy step by step guild on how to submit the form data like that. Long Summary on the sharepoint site a button will open a form for adding a new client.  once the form has been filled out and the user hits submit sharepoint will then create a User File, in clients file, and take the data and put it into contacts list. I am trying to make use of Sharepoint as I would with access, meaning the more information I have on a client the easier it will be to mail merge letters, motions, basicly any file prepaired stuff. So once I have css designed forsharepoint to make it look the way I want then the forms should intergrate perfect

InfoPath 2007 - Publishing Creates multiple columns on SharePoint Form Library (GUIDS apparently are

I have been working this issue for 2 days now.  This has happened to me in the past and I was able to work through it.  It doesn't appear that this time I am going to be so lucky. Issue Description: When publishing an InfoPath form a new column is created that has the same name as the correct one, but a new GUID is created. Troubleshooting steps: I have read this article: http://www.delphi-ts.com/blogs/lozzi/post/2009/06/03/Duplicate-site-columns-in-MOSS-from-InfoPath-Forms.aspx   This was the solution the last time I had this problem.  However, no matter what I do, it is not working now.  I have a column named User Name which is the username of the person that submitted the InfoPath form for use with my Visual Studio workflow.  When the workflow kicks off, it reads this column and attempts to get the value.  The value is blank because a new column with the name User Name now exists and that is where the value is stored.  I attempted to fix it by remapping the GUIDs as described in the article.  I also reverted the code to a previous version from TFS.  None of these worked.   I now have 3 columns called User Name and I can remap the GUID to the second column and third column.  But when I try to map it to the first column (the one I need) it doesn't work. The first column that is circled is the correct column. 

Infopath 2007: Cant we fetch data from a list or form library without using a Query to the data conn

I am trying to fetch data from a form library and a list (both secondary data sources). But cant do it without using a rule (Query using a data connection). However when I use the 'Refresh' control on the form it brings the value. I find it quite weird, as the connections are made properly and logically speaking all the data connetions should fetch dynamic data once the form opens or loads. Cant we do it without using a (data query) rule? Update: I am using a web based infopath forms, while using the same form on client its working fine. Why is that?

Add a New Item to a Custom Sharepoint List and Sharepoint Calendar from one Infopath form.


I am trying to create an infopath form for requesting time off.  Once the request is approved I want the form to add the event to a calendar on sharepoint.  I was able to do this using the article by S.Y.M. Wong-A-Ton at http://www.bizsupportonline.net/infopath2007/programmatically-add-item-sharepoint-calendar-infopath.htm.  But I want the form to also add an item to a custom list that has the employees available time off stored on it.  That way the form can automatically subtract the time entered on the infopath form from what is available on the custom list.  I was able to do this using another article by S.Y.M. Wong-A-Ton at  http://www.bizsupportonline.net/infopath2007/programmatically-add-rich-text-item-sharepoint-list-infopath.htm.  I can make both of these functions happen seperately but I need them to happen on the same Infopath form.  I am using Infopath and MOSS 2007.  I have tried to use 2 CAML receive data files and I treid to co

Infopath cannot generate a form template for the sharepoint list


Dear All,

For Sharepoint 2010, Infopath 2010

When I trying to login Infopath by link Customize Form that available in the List tool bar I found the following error:

Infopath cannot generate a form template for the sharepoint list

The SOAP response indicates that an error occurred on the server

Can anybody help me figure out what is causing this error?

How do I submit an attachment in an Infopath Form to a Sharepoint list?

I have already written code to submit my infopath data to my share point list, but now I need to find out how to submit an attachment to the same existing custom list in Share Point 2007.

Email InfoPath form located on secure SharePoint 2007 using Outlook


I have a 2007 InfoPath form that is stored on a secure 2007 SharePoint team site that needs to be emailed to outside users for feedback on a certain subject. The form is opened by a team member (with site access), sent to the reviewer to provide feedback (via Outlook 2007), and then submitted back to the team member for review and submission to the SharePoint site.

The issue I've encountered is that the outside user who receives the form in Outlook as the body of the email cannot enter information in any fields in order to provide feedback. The option to "include the form template with the email" is blocked in my InfoPath form options (I believe because the form location is a secured site). I have tried adding the users to permissions in just the library where the form is published to, but they still cannot enter any information.

Can someone provide me with a solution for this problem?

Best way to update a Sharepoint 2007 custom list schema after it has been deployed to production


What is the best way to update a Sharepoint 2007 custom list schema file (that is deployed using a feature) after the list has been deployed to production.


Scenario: We have custom list based on a custom list definition and template that we have deployed to production. Users have added items to this list and also added their own new columns to this list apart from what we originally included. Now I want to update this list schema (add another custom column). Whats the best way to achieve that?

Also, a related question is that if a new <field> entry is added to an already deployed schema file, will pushing the new schema file to the right place be enough or will a feature deactivation/activation also be required? I have noticed that some changes to schema files are picked up without the need to deactivate/activate the feature. But whats the general practice for scenarios like this?

can i save to a Sharepoint List from an InfoPath form created from Blank template


Guys, i am using SharePoint 2010. i created a form using InfoPath, created hi using the Blank form Template, all i want to do is save this to an existing SharePoint 2010 List using writing code. I also tried creating a DataSource connection but when i select the optoin for "Submiting Data" it does not show me an optoin to save data to a sharepoint list. Cand i do this using SharePoint webservices, if yes then how is it possible.

thanks in Advance


Infopath 2007 Repeating Sharepoint List Sort Auto Number


Infopath 2007
Browser Enabled
Sharepoint List in a Repeating table

I have a view with a Sharepoint List showing in a repeating table. I have conditional formatting to hide items that should not show based on Line Total.

Line Total = 4

Approver    Min Amount        Max Amount  
Jim                      3                  9
Jack                    1                   7
Sally                   2                    5

Based on this, I need to sort the Approvers based on Max Amount and send an email to them in order of the sort.  Is this possible?


Problem opening an attachment from Infopath 2007 form in SharePoint 2010

I have an InfoPath 2007 form that is opened as a web based form in SharePoint 2010 that has an attachment control.  In Windows XP with IE 7 when you double click the attachment there is a warning message presented and after you click OK you get a prompt that asks if you want to open or save the file or cancel.  In Windows 7 with IE 8 when you double click the attachment there is a warning message presented and after you click OK you get a prompt that asks if you want to save the file or cancel, no open option.  I already set the SharePoint browser permission to permissive for the site and it doesn't help.  How can I get this to work in Windows 7 and IE 8?

Compare InfoPath Form Field to Document Library list in SharePoint


I have an infopath form that has a field that matches values in a SharePoint List. In the SharePoint List I have two fields, One is email and the other is the field I am trying to match on. When the form is submitted I want to take that field from the form and compare it to the SharePoint list and return the email that is associated with that list item. Can this be done?? I appreciate any assistance. Thank you.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend