Some tables or views don´t appear

[ludosodo]

Hello, when I want to connect to a SQL SERVER using on premise data gateway some tables and views can be called from Power Automate, but others don´t appear and I don´t know why

Can you help me?

Thks!

[abm · Accepted solution]

Hi @ludosodo 

Couple of things:

1. Make sure you have the right permission.

2. Set that view as custom value and enter the view name. Save the flow. Press the back menu. Edit the flow again. Generally it should pick up the value from the dropdown list which you entered manually.

Thanks

[ludosodo]

Perfect!, thks a lot!