Hi All,
I have a Power Platform Solution that has Power Automate flows using connection references that are pointing to on-prem sql servers.
My requirement is to move data from an on prem SQL Server (The source) and push that to 4 separate on premise SQL servers. These 4 separate servers have databases that are identical.
I created 2 connection references, 'source' and 'target'. I was thinking that I would be able to configure/update the target connection reference to point to the next server. When I make this change, it seems to corrupt all of the flows. Our only way forward seems to be, create all new flows. Am I misunderstanding how the connection references work? Does anyone have advice on how I can parameterize the target database connections?
Any advice appreciated,
Thanks,
Philip