Showing results for 
Search instead for 
Did you mean: 
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

Super User
Super User


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 

Super User
Super User


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

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,616)