Power Platform Community Forum Thread Details

Hello Community,

I'm building a model driven app with a virtual table connection to sql database and a database view in azure.

When I use a sql-view as a source, all is good creating and publishing table based views and form but when I try to open/edit a record I get an error "APIM request was not successful : BadRequest : No primary key exists in table..."

I used the Id column in the view as a external primary key when I created the virtual table/entity.

I was hoping to be able to use the forms in model driven app as a "view" form and a canvas button to update properties in the sql-table throug a virtual table connected to the sql table...

Has anyone tried a similar approach?

-Gunnar