I have a backend in google sheets. I want to move this backend to SQL server Microsoft Azure backend.
The problem I am having is that I have developed an app where I am using a form which is connected to google sheets.
I am very worried when I repoint this form to my SQL server that powerapp is going to reformat the form.
Could someone let me know how can I avoid this from happening because I have put a lot of effort in developing this form
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
In general, I think it's safe to modify the DataSource property of a form without PowerApps reformatting the content.
What I would recommend you do is to backup your app onto your local computer by going to File > Save As (This Computer). That way, if the form designer messes up your work, you can revert back to a copy that's correct.
Hi @mpezzutti ,
Do you want to repoint the Edit form which connects to your Google sheet table to your SQL Table?
Actually, when you re-point the data source connects to your Edit form, it would show up a prompt as below:
On your side, if click "Replace my data cards" option, then all data cards in your previous Edit form would be replaced with columns from your SQL Table.
If you click "No Thanks" option, the previous data cards from your Google sheets table would be invalid. You need to remove all data cards from your Edit form, then enable the corresponding field data cards from your SQL Table.
Currently, within PowerApps, I afraid that there is no way to get rid of reformatting the Edit form when you repoint your Edit form to another different data source.
If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:
Check out new user group experience and if you are a leader please create your group
Next call is happening on April 21st at 8a PST.
May the fourth be with you, join us online!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.