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

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

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

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#

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

View Complete Post

More Related Resource Links

sharepoint workflow with infopath form

Hi all... when i deploy workflow with initation and task infopath forms, these forms uploaded into central admin But: status: installing workflowenable:No and no category or version then when I activate this forms this message appearence : This form template cannot be activated because it is still being uploaded to the farm. Wait until the form template's status is Ready and try again as aresult when activate my workflow, the initiation form unloaded and get error message so what 's the problem?????????????? Thanks

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

How can i have form used by infopath with workflow sharepoint 2010 ?

Hi all, I have sharepoint 2010 and infopath 2010. I would like to create a workflow which sends a task to a user every week. The task should be done in infopath 2010. How can i do that ?   Thanks

Problems when deploying sequential workflow with association Infopath form of sharepoint 2010 using


I’ve create a workflow project with infopath in it. And I get the error

 “Error occurred in deployment step 'Activate Features': Unable to locate the workflow's association data. To restore the association data to the workflow, restart the workflow settings wizard by selecting the workflow node in Solution Explorer and then clicking the ellipsis button (…) on one of the properties in the Properties window that has an ellipsis button.”

I'd really appreciate of any help.

I want to display the ID of an Infopath form after submission to a doc library on SharePoint


How can I display the ID of an InfoPath form after I have submitted it to my doc library in SharePoint.  In other words I want to display the ID the next time I open the form (ie after the first save) as well as in the doc library in a view.

Passing data into a Sharepoint Designer Form Action workflow


I have a workflow that is triggered by a "Custom Action" on a "Form Action Button" that I added to a DataFormWebPart in SharePoint Designer. So the workflow isn't associated to any list or document library. What I need to do is pass some data to this workflow so that it can do some useful stuff.

I see from here that Natalya Voskresenskaya shows a method that allows you to pass a single list item value into a workflow variable but if you hack this into the aspx file as suggested, when ever you subsequently open design view and the workflow on the button again, all the hacks are removed by SPD.

I have tried this method and it seems to work for one variable, but I cant figure out how to pass more than one. Here is another post that is very similar but slightly different.

In this post Ibrahim said on April 1st 2008:

"I am having difficulty building a Javascript string for my particular requirement; SPD had already built a concat

SharePoint Designer workflow task - problem with multiple users selector in InfoPath form




I have got an issue with InfoPath form generated for my SharePoint Designer workflow task. There is a multiple users selector that requests users from a task assignee. The problem is that only the first user entered got saved.


I am using SharePoint 2010 Standard Server (release). Steps to reproduce are the following:

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

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.

How can I show data from a Workflow variable in a SharePoint Designer Collect Data from User form?



I have collected some data (a comment) from a user in a SharePoint Designer (SPD) workflow step and I now want to display that comment in a second "Collect Data from User" form at a subsequent step in my workflow.  How can I add the content of my Workflow data variable, or even data from my original item, in the Collect Data from user form?

The Collect Data from user form is generated out of the Workflow Tasks list and only contains the url of the item where I could store the comment and which has the workflow attached to it.

This guy says he has done something similar but he appears to only use the URL and static info and does not explain the detail in any case: http://www.mstechblogs.com/paul/spd-workflow-collect-data-from-a-user-modify-the-generated-task-form

I'm keen to hack at the aspx form in SPD but I really need the particular line of code that will do it as I'm not a developer.

Your help is greatly appreciated!

Building InfoPath forms against Sharepoint 2010 Data Connection Library and Form Services...


Hi Sharepoint Experrts,

I'm trying to develop InfoPath 2010 forms that use External Lists that have been created in Sharepoint Server 2010.  I have problems when testing the forms because access is denied to the external lists.

When I try deploying the forms to the sharepoint site, I cannot upload the form template because it says I have to be a member of the local administrators group.  However, I'm running the administrator account used to install and setup sharepoint on the Windows 7 development machine I'm using.

I also tried loading the InfoPath Data Connections to a data connection library on my Sharepoint site... I can see the files when I login to the site but when I try creating a New form from a Data Connection File, I get an error message "This location does not contain any data connection files with the appropriate settings".  What ARE the appropriate settings?

I'm just really confused about this because I cannot seem to be able to build forms that use data connection files loaded onto a Sharepoint site or central server....

I appreciate any help I can get!




Thanks, KBW

How do I embed an InfoPath form in the body of an e-mail and have the data go to a SharePoint list w

I've managed to create a form in InfoPath with all the required fields.  I can publish this to be embedded in the body of an e-mail as long as it is not linked to the SharePoint list.  I can also publish the form directly in the SharePoint list so that when you 'Add document' the form appears and can be filled out.  However, I can't publish the form to an e-mail (embedded in the body) and have a end-user submit the information to a SharePoint list.  Is this possible?  If so, what steps am I missing to allow it to happen?  Thanks!

Sharepoint workflow + task + infopath form + ?!


I have a simple Vs2010 Sequential workflow. I have followed this guide: http://msdn.microsoft.com/en-us/library/ms580283.aspx and various others to get it working. So the connection from my workflow to the infopath form is OK and I can get data in and out via the Itemmetadata.xml file. However, one thing I can't work out how to do: add fields from the task item to the infopath form, e.g., the Status field.

I have tried adding a data connection to a SharePoint Library or List, but this creates repeating fields, i.e., for every item in the list - I want to just display the data for one task.

I figure I know the GUID of the task item so i could query the list from VS and pass it through to the form via ItemMetadata... but I assumed there would be an easier way to do this. The form should know what task item opened it... (for instance, if I go to the list, and click "Customise form in infopath" then the form it creates is perfect - except that it will only publish it back to the list it came from - I can't save it as a generic reusable template.

Sorry if I'm asking anything daft, but any thoughts or good tutorials on this?


weirdbeardmt, PhD, BSc. Silly name, but lots of letters.

How to allow only your team to update a field on web based InfoPath form in SharePoint


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?

Programatically adding rows to nested repeating tables in Infopath Form based on a criteria


Req Nested Repeating Table:







Using Infopath form fieldnames in a workflow fails



I designed a form in Infopath and I published it on a SP2007 server to use in a workflow in a library. That goes fine. In the workflow I send an email message. I can use the fields from my Infopath form in the message that I create. 
If the workfow is starts, Shrepoints sends me the message. But it does not use the fields from my InfoPtah form in the message in stead I see questionmarks.

Why doesn't it show the fields?

I alse saw (maybe this makes it clear) that when I let it dipslay the URL in the message, it show: http://1.portal.lucasonderwijs, but the actual site is whithout the "1" and it should also start with https://

Has anyone seen this before?

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