We have two flows that can be triggered within a Power App. Each flow has one or more SQL connector steps ("Execute stored procedure," "Get rows (V2)"). We are building in a dev environment and moving the solution to a staging and then production environment. The problem is we have to manually change the server name before or after this move to point to the correct server.
In an older flow we made with a SQL stored procedure step, the Server name drop-down had the option "Use connection settings". This meant that when the solution was imported into another environment, the connection reference would point to a different SQL connection, and everything just worked.
Does anyone know why this option isn't showing up for these newer flows?
We did set up a variable to hold the server name, so that in our flow with multiple SQL steps we only have to change it in one place. But this is still not ideal.
