cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
knishal
Helper IV
Helper IV

Convert Sharepoint List To SQL Server Database.

Hi I am currently inserting data to a sharepoint list. I have a form on powerapps and everytime I submit the form the data gets stored in a sharepoint List. Is there a way to change the data source to a Local SQL Server or Azure SQL without recreating the form?

 

Any Help or advice will be highly appreciated

4 REPLIES 4
Drrickryp
Super User
Super User

@knishal 

As long as the field names and field types match the SharePoint column names, you can just change the Datasource property of the form.  Problems will arise if you have lookup, person or choice type columns in SharePoint.  If this is the case, you may need to save the SharePoint lists as Excel tables and import them into Sql tables and then reconfigure or recreate the forms. .

@Drrickryp Thank you. I have person column, choices and dropdowns. Will have to store the dropdown menus in a separate table? If anyone else has any advice or done this before please let me know 

Drrickryp
Super User
Super User

@knishal 

I haven't done this with sql but it is logical that you will need separate tables for each of these type of columns and create the relationships in sql.

You would need to store these in a separate table. If you're not worried about moving this data and only the data that is being input. You could simply keep them in their current data source and move the rest of the data. Assuming there are no relationships between the data.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,593)