You’re offline. This is a read only version of the page.
8
In the power automate flow, I need to establish multiple connection with the sql database Dynamically(on the Run time). Is there any way to establish connection in power automate flow on the run time?
Do you know a way to create a connection on a SQL server that can use the differents bases of this server?
And, in a flow, change dynamicly the data base (not the serveur, juste data base).
Yes, I don't want to write API using code.
Hi @HarshYadav ,
When you say multiple databases, I am assuming you mean multiple databases across multiple SQL servers right?
I don't really know if there is a feasible option to achieve what you want to do that can remain both scalable and maintainable.
Assuming you don't want to write any APIs using code, one approach which I haven't tested and honestly don't know if it will work would be to create linked servers and then use Power Automate to execute stored procedures against linked servers. You would need to pass in parameters to act as the linked server name etc. Again, no idea if it will work in the context of Power Automate.
--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up
Connect on LinkedIn
Hi @HarshYadav ,
Can you elaborate what you are trying to achieve? Do you need to connect to different SQL servers at runtime?
You can create multiple connections and use that within the same flow. Similarly, you should be able to use multiple SQL actions to connect to different SQL servers within the same flow.
--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up
Connect on LinkedIn
#1
WarrenBelz
146,605
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,946
Most Valuable Professional
Share
Report
All responses (
Answers (
