cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Change Form Data Sources w/out Losing Form Styling?

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?

 

Thanks

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Change Form Data Sources w/out Losing Form Styling?

Hi @ericonline,

 

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.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Super User
Super User

Re: Change Form Data Sources w/out Losing Form Styling?

Hi @v-monli-msft

 

I'm referring to every property inside the data card: 

  • Label.Height, .Width, .FontWeight, .Font
  • Star.Visible, .Size, .Color
  • InputBox.Everything

 

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

Highlighted
Super User
Super User

Re: Change Form Data Sources w/out Losing Form Styling?

Another question here: 

 

  • If I use a SQL data source, will moving the SQL tables to another database cause loss of Form styling? 

e.g. Start with on-prem SQL database, import to Azure SQL at a future date. 

 

Thank you

Highlighted
Community Support
Community Support

Re: Change Form Data Sources w/out Losing Form Styling?

Hi @ericonline,

 

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. 

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,880)