You’re offline. This is a read only version of the page.
Announcements
13
Hi there,
I am moving a number of flows associated with a Power App from a DEV environment to a PROD environment,
They also need to change from a DEV sql database to a PROD sql database.
These Flows have a very large amount of SQL Server actions (probably over 100),
each one of these actions needs to have the sql server and sql database names specified.
Right now the only way I see to change these all from the DEV DB to the PROD DB is to go through each one by one and copy and paste the PROD server name and PROD DB name.
This is a problem because I will likely need to move from DEV to PROD often and this will take a lot of time.
(Every time I export and import the Flows it will overwrite the server and DB names)
I've tried setting the server name and DB name to string variables however this causes the sql actions to error out and not work.
Any help would be greatly appreciated thanks.
Ryan
We are doing the same thing with large number of Flows. If they are inside a Solution, you can use a "Connection Reference" to point to the desired AAD SQL Instance. Then we use Environment Variables (e.g. DBServerName and DBDatabaseName) to point the the desired server and database. We were getting timeouts when we first tried, so found that it worked reliably when you deleted the SQL action and re-created it using the above approach.
This works for actions such as Execute A Stored Procedure V2 as well.
Share
Report
All responses (
Answers (
