There are MANY cases where I want to develop a PowerApps Form against a Sharepoint Custom List then move my app to a different data source later.
Moving to a new data source REMOVES all the Data Card formatting that I put in place.
Am I missing something here or is there a way to keep your Data Card formatting and point the Form to a new Data Source?
What is the Data Card formatting that you are trying to keep? Did you mean like the control types inside Form? If so, your requirement cannot be achieved so far. It is by design that if you change the data source of the Form, the controls inside would automatically change according to the column types in the new data source.
I'm referring to every property inside the data card:
I go through significant efforts to customize the contents of a Data Card but for some reason, all that customization is tied to the Data Source. I believe we would all benefit greatly from separating Data Card formatting from the Formulas and Parent.Everthing.
The biggest use case is when someone comes to me and says: "Thats the wrong Sharepoint list, we need your app to point over here.", or "We'll just move it to SQL in the future." I have to say, "Its not that easy".
Another question here:
e.g. Start with on-prem SQL database, import to Azure SQL at a future date.
Yes, it is by design that all these would be reset if you change the data source in the Form control. Sorry that so far there is no workaround I could think of for this.
Check out new user group experience and if you are a leader please create your group
Please join us on Wednesday, July 21st at 8a PDT. We will be announcing the Winners of the Demo Extravaganza!
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.