Hello all,

I am a sharepoint expert who is not very experienced in InfoPath. Now i have a requirement to move a paper-form into sharepoint.

So these audit forms will be managed on sharepoint environment. I have had some infopath forms experience, but they were flat forms, that are 1-to-1 with the associated sharepoint list.

Now i have a challenge, and dont know how to do this infopath.

Shortly, i try to explain the form:

  • Every month a monthly food menu will be entered in another sharepoint list. Which contains a number of food for each day of month.

  • There is a audit form (can be seen above) which should be filled daily with data of each food of that specific day.

  • So when the audit form is opened, form should populate the Foods of that specific day initially, then user enters data for each food.

  • And in the belowof form there is another section that have values of some predefined places.And also i think this should map to another sharepoint list in behind.

So how should my sharepoint list/column/data architecture should be, and how can i do this with infopath.

1 Answer 1


Yes, and InfoPath is the right choice for such kind of forms!

Food, Control Criteria, Menu

For the form
AuditForm: Unit, CreateDate
AuditFormMenu: AuditFormId, FoodId, Number, Weight, Heat, Feel, Extra, Comment
AuditFormGeneral: AuditFormId, ControlCriteriaId, Feel, Comment

So architecture will have 3 Entities Lists and 3 Lists for saving Form data!
You can make SQL Server tables for the entities and make external content types and external lists for views!

Now since there is no OOB available to submit form to multiple lists, few options you can have are: How to submit InfoPath form data to multiple SharePoint lists at one time?
5 Ways to submit an InfoPath form to a SharePoint list

For your complex form, I would recommend you to go for a Web Service... Write a web service that make inserts/updates on the Lists on behalf of the form! And from the InfoPath form call the Service, you can easily map your fields to Web Service Method inputs, and where you have repeating table you can simply send in XML format...

If you choose to go for SQL Server and External Content Types, you can use Entity Framework in your Web Service for easy handling on database operations!

Let me know if you want more information, I hope this helps!

  • I couldn't grasp why do you use sharepoint lists for this Dec 4, 2012 at 0:22
  • Updated my answer! :) Dec 4, 2012 at 5:42
  • @GennadyVanin--ГеннадийВанин what is your suggestion?
    – ozdogan
    Dec 4, 2012 at 18:47
  • @ArsalanAdamKhatri sql server option is not suitable for me
    – ozdogan
    Dec 4, 2012 at 18:52
  • @ozdogan I guess GennadyVainin was talking about external data source instead of SharePoint lists Dec 5, 2012 at 12:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.