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

Report
All responses (
Answers (