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
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
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.