.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 allow only your team to update a field on web based InfoPath form in SharePoint

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :C#

Hello and thanks for reading,

I am relatively new at creating an InfoPath form for SharePoint but did accomplish a lot so far. Right now I am in a bind! I am almost completely done but can not figure out how to allow only my team members to change a field in the form and NOT have the users touch the field. This form is a "reguest" form for tasks to be completed by our team. I created a "status" field and a "assignee" field and do not want anyone else to touch. I believe this an InfoPath and not a sharePoint function, correct?

View Complete Post

More Related Resource Links

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.

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

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/

Map an InfoPath form field to a SharePoint column

I am trying to create a custom SharePoint list template feature (feature.xml, schema.xml, the whole nine yards), which is based on the OOTB XML Form Library in MOSS 2007. I copied the XmlFormLibrary feature out of the FEATURES folder on my SharePoint server, and made a few minor modifications (changed the feature name, new GUID, added some fields in schema.xml, created a new content type for it, etc...).

What I ultimately want to do is publish an InfoPath form template into it as the document template for the library, and I would like to be able to map certain fields in the form template to fields in my custom SharePoint library template. In InfoPath, I open the Publishing Wizard and go through the typical steps to publish to a Document Library. I then choose the columns in my form that I want to promote to fields in the form library, and select the appopriate fields to map to in the form library. I publish the form, and do not get any errors or warnings.

However, when I choose "New" from the form library and fill out the form and save it, only certain fields in the library are actually being populated from the form. Specifically, this seems to work fine for a date/time field I am using, but does not work for the "Location" field. I am using the OOTB "Location" field from the "Core Contact and Calendar Columns" group. Ev

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

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.

Compare InfoPath form field to SharePoint List


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.

Compare InfoPath form field to SharePoint List


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.

Infopath form conditionally populating based on sharepoint list

OK, here is my problem. I have an infopath purchase requisition form that autopopulates user info based on their sharepoint account using the getuserinfobyname data connection. One of the fields in the form is for the users manager's name. I then have a SharePoint list set up that has 2 columns, one is manger names and the other is their purchase approval limits. Basically I want the form to compare the manager name field in the infopath form to the list in sharepoint and populate a field in infopath with that manager's approval limit. Any thoughts would be much appreciated.

How to change the way the infopath form saves data in SharePoint library (Ex: Person/Groups field is

Person/Group field is taken as an integer field in SharePoint form library when a form is submitted. I need to retain it as Person/Group column in the SharePoint form library too. Please help on the same. Thanks.

InfoPath Calculated Field doesn't Post to SharePoint List when form is submitted


I have a nice InfoPath form that includes a calculated total field.  That works great.   The form is published to a SharePoint list and when users of the form Submit the form to the list the form information neatly populates to the list.   Well, all of the fields populate to the list except for the calculated total field, that one is just blank.  Naturally, I've noodled around to figure out why and therefore I'm here now asking for guidance.   What should I be focusing on to resolve this issue?


ItemAdded Event not always returning SharePoint field information when InfoPath form submitted


 (SharePoint 2007)

I am struggling with an issue related to InfoPath and use of the ItemAdded event handler.  I have created an InfoPath form that contains several fields that are being published to SharePoint fields in a Forms Library.  When I submit a new form, the SharePoint data is being correctly updated.  ian see it in the list.  However, I am trying to write an ItemAdded event handler that performs specific logic based on the value of one of the InfoPath/SharePoint fields for the form being added to the library.  The logic appears to work correctly the first time through.  I can sucessfully read the value from the field and then execute my logic.  However, subsequent submissions appear to not be able to read the values.  It is like they don't exist or are null.  I am thinking that it has something to do with threading but I cannot find a work around for this problem.  The interesting thing is that the same exact logic works correctly when the ItemAdded event handler is tied to a standard Document Library.  Any word documents that are being added always read the values correctly. 


Does anybody know what might be causing this or a possible way around this issue? 



Pulling data from SQL tables in a Sharepoint Workflow based on an InfoPath form submission


I'm not sure this is the right forum for this, but here goes:

I'm creating a workflow that kicks off when a user submits an InfoPath form to a form library on a Sharepoint 2007 platform.  The workflow should find the manager of the user that submitted the form from SQL and email that person for approval before the next step is run.  Is this possible in Sharepoint 2007 or is using SQL in a workflow only a feature of Sharepoint 2010?

Thanks in advance

Insert image into Infopath form and save to SharePoint as PDF file


I have an InfoPath web-enabled form in MOSS 2007, that is integrated with a K2 blackpoint process for an approval workflow.

Once the form (a Purchase Order request form) has been approved in the K2 workflow process, I switch the form view to a "print-friendly" view for the requestor to view from the browser.  However, now I need to go one step further with this scenario:

1) I need to somehow insert/embed an image with the scanned-in signature of the approver (likely stored in a SP doc library) at the signature line section of my form.  Also, what are the security requirements for storing such images, but not granting all users access to these (e.g. only services accounts that need to access this for embedding into the form, etc.)?

2) Then I need to convert this final "print-friendly" view of the form (with the signature image) to a PDF document so that I can store it in SharePoint (and email it to the requestor using K2's email event capabilities).

Can anyone help me with a solution to both of these requirement, or point me to some resources for this (even 3rd party components are open-game).



Attachment upload error on browser based InfoPath form



I am having an interesting problem with browser based InfoPath forms in SharePoint 2007.  For some reason the file attachment control is not working any more.  It was working fine in July, but now it will not allow file attachments over a few kb.  I tried a 34KB file and I get the error below, a 2KB file works fine.

Unable to connect to SQL Server session database. The connection string (server='SPDB', database='SharedServices1_DB') was returned by an instance of the IPartitionResolver type 'Microsoft.Office.Server.Administration.SqlSessionStateResolver, Microsoft.Office.Server, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c'.   at System.Web.SessionState.SqlSessionStateStore.ThrowSqlConnectionException(SqlConnection conn, Exception e)
   at System.Web.SessionState.SqlSessionStateStore.HandleInsertException(SqlConnection conn, Exception e, Boolean newItem, String id)
   at System.Web.SessionState.SqlSessionStateStore.SetAndReleaseItemExclusive(HttpContext context, String id, SessionStateStoreData item, Object lockId, Boolean newItem)
   at System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs)
   at System.Web.HttpApplication.SyncEven

While Printing an Infopath Form it Prints lot of Blank Spaces Before RichText Field


I had an infopath form with few rich text field. When i copy some content from somewhere and paste in the richtext Box then while Printing the form I get Lot of Blank Spaces Infront of the rich text box.

I tried creating teh print view too but still i get bunch of empty pages printed before by richtext box control.

Is there a way we can remove those blank spaces.....

I am not able to find out what is going wrong here....

SharePoint Batch Update Auto Increment Field Value


Hello All,

I am making use of SharePoint List Batch Updating methodology in order to update the items in bulk. I build the query dynamically for each and every item using StringBuilder and process the data ultimately using 'ProcessBatchData' Method.

Now, I have a requirement where I have to increment a particular field value in the query while iterating through each item for building the query. How can I auto-increment a field value for each item in the batch query?


Infopath Brower enabled form not visible in the sharepoint library after being submitted

Hi, I have created a infopath browser enabled form to submit to a sharepoint form library, however the submitted forms are not visible in the sharepoint link structure.   I'm able to see them in the SPD structure.  I'm using infopath 2007 and MOSS. I actually created a SPD workflow which retrieves specific values from the submitted form and saves it to another sharepoint list. This works fine even if the forms are not visible. Appreciate any help. Thanks
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