Unanswered

Data Gateway not displaying tables

(0) Share

Report

Posted on by mstrydom

I am new to PowerApps and am trying to create a new flow to use with a Canvas App. When the app updates an entity record in the Common Data Service, the flow should update a record in an on-prem SQL database.

I have a Data Gateway that is working with Azure functions, so I am pretty confident that the Data Gateway is working. When I inspect the connection details, it indicate the connection is connected.

I then create an Automated - from blank flow with the following trigger.

As the action I select SQL - Insert row (V2). I gives the correct options for the server and database, but the tables does not load.

However, when I select "SQL - Execute stored procedure (V2)", the correct list of sp's load.

Any help would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @mstrydom ,

It looks like some errors on the server side, but it can be sure that the Gateway is working properly, otherwise even the database would not be picked. I believe this is a temporary problem.

But for now, All I can suggest is that you change your browser, try restarting the gateway, and refresh the data source.

Sik

Was this reply helpful? Yes No
mstrydom 4 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-siky-msft

Thanks for your prompt response. Unfortunately none of your suggestions have worked. Hopefully this is just temporary. 😀

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @mstrydom ,

If the error still exists, please submit a Support Ticket to Microsoft for further assistance.

Get Help + Support

Sik

Was this reply helpful? Yes No
mstrydom 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks @v-siky-msft, will do.

Was this reply helpful? Yes No