Edit Form with SQL View

[Sharuk]

Hi,

I have created a view for SQL Table. and i've passed it to edit form in the powerapps. but i'm not able to see the text inputs for the datacards. can we use SQL views on the edit forms and patch/submit the data back to data source ? 

[zmansuri · Accepted solution]

I think SQL Views are only read only in PowerApps

[timl · Accepted solution]

Hi @Sharuk 

Views are not updatable - that is, it's not possible to set the data source of a form to an SQL view and to save the record.

The workaround for this would be to add a form and to set the data source of the form to the source SQL table. You can set the items property of the form to look up the record by the primary key ID value.

In the case where your view retrieve records from multiple tables and you want to update rows from those source multiple tables from a single screen, you can add multiple forms that correspond to each table. You can then add a 'save' button and call SubmitForm for all forms in one go.