I have mysql database with table. In this table there are data that i want to show in infopath and i save in sharepoint list. Can you help me how?


First, you should be aware of The SQL Server is the only supported database source in Infopath.

enter image description here

In your case, you can achieve your requirements by using the Web Service as the following:

  1. Creating a Web Service that read data from your data source (MySQL)

Note: Make sure that the Web Service is reachable and accessible inside your SharePoint domain.

  1. Consume this Web Service in your InfoPath form by adding a new data connection as shown below.

enter image description here

  • Can you give me some instruction for creating web service?
    – gogi100
    Mar 18 '18 at 22:39
  • Check this stackoverflow.com/questions/8362835/…, if you need more clarification about web service you can ask this in StackOverflow, please don't forget to Mark this answer as accepted in case it helped you ! Mar 19 '18 at 7:58
  • I created web service, bu i have a problem with infopath form. When i open infopath form in preview i receive data from mysql but when i publish form i cannot receive data from mysql
    – gogi100
    Mar 19 '18 at 20:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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