I am trying to connect Flow to a MS NAV 2018 Database.
I have installed the MS - On-Premises Gateway on an SQL Server. It has connected ok.
When I connect using Powerapps the tables display and can be accessed as expected.
However when using the same connection with Flow the tables cannot be retrieved.
I tried using a custom value to directly table name. That still did not work.
Anyone have any ideas?
Hi @Anonymous ,
Thanks for updating.
That might be the cause.
Glad to hear that you have figured out the issue.
Best regards,
Mabel
Hi Mabel,
Thanks for you reply. However that’s not the issue.
I believe I have found my issue There are too many table in the SQL DB for Flow to retrieve. I have around 20,000 tables.
If I enter the exact Table name I am after in Get Rows it works fine.
Darren.
Hi @Anonymous ,
SQL Server triggers only work for SQL Azure Database table, but not SQL on-premises tables.
As you mentioned, you are using SQL on-premises, so I am afraid that it cannot be used in your scenario.
Please check the following blog for more details:
https://flow.microsoft.com/en-us/blog/introducing-triggers-in-the-sql-connector/
There is a similar request on Flow Ideas Forum, please vote it at here:
Best regards,
Mabel