https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/77756.aspxThu, 19 Apr 2012 16:44:19 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:77756Anson Hidajat0https://www.infopathdev.com:443/forums/thread/77756.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=77756<p>Retrieving data from a SP list in InfoPath is pretty easy.&nbsp; Just create a secondary data connection (Data -&gt; Data connections) to receive data from a SharePoint List.&nbsp; This will pull in all the data from that list into the InfoPath form.&nbsp; You can even filter the data by using queryFields to limit which items are displayed.</p><p>Writing the data back to SharePoint is a little trickier.&nbsp; I would suggest using our SubmitToSharePointList functionality which is probably your best bet.&nbsp; Here is a link with more info: <a href="http://www.infopathdev.com/files/folders/qrules/entry49216.aspx">http://www.infopathdev.com/files/folders/qrules/entry49216.aspx</a></p>https://www.infopathdev.com:443/forums/thread/77745.aspxThu, 19 Apr 2012 13:24:20 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:77745mshopene0https://www.infopathdev.com:443/forums/thread/77745.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=77745<p>&nbsp;I&#39;ll look through the forums to see if this has already been answered but thought I would also post it and see if I can get an answer.</p><p>What I have is a Sharepoint list. Its departments with employees and hours that will be planned against those departments. About 130 rows and potentially 200 columns.&nbsp;</p><p>Currently we do all this in an Excel spreadsheet with lookups and then calculations. Want to move it to Sharepoint for various reasons.</p><p>Have tried to do this in just lists but keep running into limitations. Can get all the data into lists but its the calculations that cause the issues.&nbsp;</p><p>I need a form that will pull the information for just a specific department; all the various hours and employees by type and month. Allow the manager of the department to make changes to the number of employees in any month - like run a scenario to match a desired efficiency. This affects the later months and the total hours, etc. It updates the later months fields.</p><p>Can this be done in a form? Pull the specific info, make updates, then save back to the list? Can it be done in a saved infopath document that could be reopened and updated again?</p><p>&nbsp;Thanks for any help, Mike<br /></p>