You can use the User Profile Service webservice to fetch that information. I believe there is an InfoPath 2007 video on the site that explains how to use that webservice.
Have created a new form library from excel spreadsheet – I am editing the form modify /edit choice properties, I want to receive data from a sharepoint list – I am using the wizard but stopped when I enter the site location (odd enough I see the list and actually choose it and it comes back and tells me The operation could not be completed?? I have already connected and created the form library – any ideas on what I can check… Thank you so much
Trying to get data in an InfoPath form from a SharePoint list is a pretty simple process. If that doesn’t work, my guess would be either a) the List’s schema is somehow not being understood by InfoPath or b) it’s trying to retrieve too much data and timing out somewhere. Just a guess…
If none of these things pan out, I would suggest making a comment about this on the InfoPath team blog. They are pretty responsive to queries.
The best way to push data back to the database from InfoPath will be to use web services (as a Secondary data connection). It will require some coding unfortunately to do it right.
If I have a form that can be filled out by reference to a database (by entering a key piece of data) can you use infopath to basically function as a report or do you have to fill in each field as you go?
View 
Subscribe via 
Leave a Comment
June 16, 2010 pm30 12:31 pm
How would one get the department field from the current user who is filling out the form?
June 18, 2010 pm30 4:18 pm
You can use the User Profile Service webservice to fetch that information. I believe there is an InfoPath 2007 video on the site that explains how to use that webservice.
July 8, 2010 pm30 4:07 pm
Have created a new form library from excel spreadsheet – I am editing the form modify /edit choice properties, I want to receive data from a sharepoint list – I am using the wizard but stopped when I enter the site location (odd enough I see the list and actually choose it and it comes back and tells me The operation could not be completed?? I have already connected and created the form library – any ideas on what I can check… Thank you so much
July 11, 2010 pm30 11:54 pm
Trying to get data in an InfoPath form from a SharePoint list is a pretty simple process. If that doesn’t work, my guess would be either a) the List’s schema is somehow not being understood by InfoPath or b) it’s trying to retrieve too much data and timing out somewhere. Just a guess…
If none of these things pan out, I would suggest making a comment about this on the InfoPath team blog. They are pretty responsive to queries.
August 20, 2010 pm30 11:00 am
This shows how to get data from the database to the form. Can you use infopath forms to update data in a database or would you use some other method?
August 20, 2010 pm30 11:05 am
The best way to push data back to the database from InfoPath will be to use web services (as a Secondary data connection). It will require some coding unfortunately to do it right.
August 20, 2010 pm30 11:51 am
If I have a form that can be filled out by reference to a database (by entering a key piece of data) can you use infopath to basically function as a report or do you have to fill in each field as you go?
August 30, 2010 pm30 6:40 pm
You can definitely do lookups from a database table passing in parameters/variables from InfoPath forms.