cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sizo
Regular Visitor

Use of Standard Tables and Upgrade Implications

When using PowerApps standard table(s) in a custom solution, what happens to the table, forms, views and/or data within the table(s) when Microsoft decides to upgrade their standard table, maybe add/delete field?

2 ACCEPTED SOLUTIONS

Accepted Solutions
ChrisPiasecki
Super User
Super User

Hi @Sizo,

 

The only material impact will likely be the out of box forms if you are using them. The OOB forms will be merged with your changes and may need to be fixed up. One way to avoid this is to just create new forms whenever using system tables such as Contact or Account, as these will be untouched by an upgrade. More info here.

 

MS will not just delete fields or other changes that result in data loss. While very uncommon, they could "deprecate" some fields, which would at least give you an opportunity to move them to another field if need be.

 

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

View solution in original post

EricRegnier
Super User II
Super User II

Hi @Sizo , 

To supplement on @ChrisPiasecki which is true what he mentions. All Microsoft changes are done via managed solutions, and every change you perform is done in the unmanaged layer which always sit on top of the managed layers. So all your changes (unmanaged layer) will take precedence. If you promote your changes with managed solutions, your managed layer will sit at a higher level (generally) then Microsoft's managed layer so will also take precedence. More on solution layers: https://docs.microsoft.com/powerapps/maker/data-platform/solution-layers 

That said, it's pretty safe to use standard aka out-of-the-box tables and very recommended to do so not to re-invent the wheel and leverage lots of out-of-the-box capabilities, especially for user, contact and account. See tip #5 from: https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Top-15-best-practices-when-configuring... 

Hope this helps!

View solution in original post

2 REPLIES 2
ChrisPiasecki
Super User
Super User

Hi @Sizo,

 

The only material impact will likely be the out of box forms if you are using them. The OOB forms will be merged with your changes and may need to be fixed up. One way to avoid this is to just create new forms whenever using system tables such as Contact or Account, as these will be untouched by an upgrade. More info here.

 

MS will not just delete fields or other changes that result in data loss. While very uncommon, they could "deprecate" some fields, which would at least give you an opportunity to move them to another field if need be.

 

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

View solution in original post

EricRegnier
Super User II
Super User II

Hi @Sizo , 

To supplement on @ChrisPiasecki which is true what he mentions. All Microsoft changes are done via managed solutions, and every change you perform is done in the unmanaged layer which always sit on top of the managed layers. So all your changes (unmanaged layer) will take precedence. If you promote your changes with managed solutions, your managed layer will sit at a higher level (generally) then Microsoft's managed layer so will also take precedence. More on solution layers: https://docs.microsoft.com/powerapps/maker/data-platform/solution-layers 

That said, it's pretty safe to use standard aka out-of-the-box tables and very recommended to do so not to re-invent the wheel and leverage lots of out-of-the-box capabilities, especially for user, contact and account. See tip #5 from: https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Top-15-best-practices-when-configuring... 

Hope this helps!

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,315)