Form not editable while connected to SQL Server - why?

(1) Share

Report

Posted on by UnspeakablePirate

Hi there,

I wanted to create small app that get data from my SQL Server on promises that works 24h/7. App will be really simple. From gallery choose item and on the right show data for selected item and if needed change data and send it back to SQL Server. I have data-gateaway installed as I use that SQL Server for my Power BI reports.

I got Gallery, and Form. Form is on FormMode.Edit. Yet in some reasons I can't see that border on selected fields which will allow me to change any values like "Read/Write" on picture below. Why is that?

If you create app from dataverse table I don't have any problems. Is there someone who could tell me what am I doing wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Ryan_B 446 on at

Like (1)

Report
Copy link

Link copied!

By default, if you use a display form control it will only place text labels to show the data. If you want to utilize the display form control to update the data, you will need to delete the label and insert a text input control instead.

Otherwise, I would simply recommend you edit the data using the edit form control you already have to keep things simple. If you want it to look better when editing the data in the form, you can turn on auto-height for the text inputs so that it looks like the display form control.

Was this reply helpful? Yes No
UnspeakablePirate 21 on at

Like (1)

Report
Copy link

Link copied!

I finally got it the state that I can edit form. I didn't want to add any "Save" button so basically to every placeholder user can edit I added in OnSelect = SubmitForm(Form_1). Although I get notificiation of success change isn't visible in database. Any idea why?

If I use SharePoint data it saves as intended but on SQL it just doesn't want to work properly.

Was this reply helpful? Yes No
UnspeakablePirate 21 on at

Like (1)

Report
Copy link

Link copied!
Ok, I figured why it save data. I get an error on SubmitForm.

I find it weird cause I do have PrimaryKey in table

"ServerMessage": "[dbo].[main_table] — niepowodzenie: The specified table has no primary key. Update and delete operations are not supported.\r\n inner exception: The specified table has no primary key. Update and delete operations are not supported.\

Was this reply helpful? Yes No