Answered

Two databases or two connections in same flow

(0) Share

Report

Posted on by kj2

I am using on-premise gateway for a Flow. My first step is "When an item is created". My second step is "Insert row".

It works fine when both tables are in the same database. Is it possible to have a connection with two databases? Or a Flow that uses two connections?

There does not appear to be an option to use a different database or connection for the "Insert row".

Thank you!

Categories:

Using connectors

I have the same question (0)

All responses (7)

Answers (1)

Pstork1 69,022 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

If you want to use two different databases then you will need to configure two connections, one for each database.

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @kj2 ,

You could change the Database through the existing connection, basically a connection corresponds to a configured Database.

In addition, you could also add a new Database as a Data Source by adding new connection.

Image reference:

Hope this helps.

Best Regards,

Was this reply helpful? Yes No
kj2 5 on at

Like (0)

Report
Copy link

Link copied!

Thanks! I figured I needed two connections, but I didn't know how to specify the connection. The graphic of how to alter the steps demonstrates what I need to try.

I haven't had time to test this yet, but I'll check it out as soon as I can.

Was this reply helpful? Yes No
himuengg 13 on at

Like (0)

Report
Copy link

Link copied!

Any luck on this? I am facing the same issue.

Was this reply helpful? Yes No
Pstork1 69,022 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

A solution was provided for this one a while back. if that isn't working for you then I would suggest posting this as a new question. You'll get more views that way and we'll better be able to help you. I would also suggest being more specific about your issue. Is there some reason that adding a second connection isn't working for you?

Was this reply helpful? Yes No
himuengg 13 on at

Like (0)

Report
Copy link

Link copied!

adding a second connection works but wanted to know if it can be achieved without creating a second connection.

Was this reply helpful? Yes No
Pstork1 69,022 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

No you can't do it without adding a second connection. Connections specify the database they are attached to, so if you want a second database you have to create a separate connection.

Was this reply helpful? Yes No