Answered

Changing database schema

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All, I have following problem: I created some canvas app, that allows add/edit records in some database tables, for example:

dev.table1

dev.table2

dev.table3

Now I would like to use the same app, to do the same processing on tables with the same structure, but on different database schema, for example:

itg.table1

itg.table2

itg.table3

Do I need to manually remove all dev tables, add itg, change all fields definitions, and code? Or there is some option to globaly change a database schema in app?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Pstork1 69,543 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You can change the connection in the App to point to the new database using the same connection name. Then refresh the connection. After that you'll have to clean up any formulas that show errors based on the schema change. There is no global switch that will adapt to a changing schema. It will try to match as much as it can and then you'll have to cleanup the rest.

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,
I'm afraid it's not supported to use the same formula structure and replace the table's name currently in PowerApps.
As an alternative way, you could try to use Substitute function to replace some specific words.
Insert a textinput control, set its text:
Substitute("original formula","dev.table1","itg.table1")
Here's a doc for your reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-replace-substitute

Best regards,
Community Support Team _ Phoebe Liu

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@v-yutliu-msft wrote:
Hi @Anonymous ,
I'm afraid it's not supported to use the same formula structure and replace the table's name currently in PowerApps.

Sad news 😞
But thank you all for answer.

Was this reply helpful? Yes No
DragonLord 200 on at

Like (1)

Report
Copy link

Link copied!

this feature really needs to be added.

Was this reply helpful? Yes No