On premise gateway - SQL some tables not showing

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I want to ask you for help. I use on premise gateway for power automate and it works.

But Today I had problem because I added new tables to database and I can not find it in power automate.

I tried install new gateway on different server but it does not work. I still can not see that.

Do you have some advice, how to add new table into power automate from SQL?

Interesting is that I can manually write name of table and I will get names of columns. But in moment when I testing this flow, it still waiting for action... (I removing data, adding data.. without change)

Thank you for feedback,

Jan Fiala

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (0)

Sort by

eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

I have also experienced delays in schema changes before (table/column/views etc). The changes should come through eventually after a few hours. Not sure why.

--------------------------------------------------------------------------
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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @eric-cheng ,

Its day after and I still can not see my table 😕 This problem will be different.
I am not sure why

Jan

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Interesting. After two days I found missing table but in predefined template. But I still cannot see this table in manualy created flow. Exactly this trigger which doesnt showing new table is "When an item is created".

Was this reply helpful? Yes No