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