Announcements
I'm connecting my App with SQL through gateway
when I add fields to the App I notice all these fields in view mode !
it should me in edit mode and showing the textboxes that I have to use
is it normal ?
what is the best practice in my case ?
@ElMeSaFeR
Did you add an Edit Form or a Display Form? You should be adding and Edit Form.
After you added the Edit Form you need to unlock each Card one-by-one. Its 100% normal.
---Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Insert two buttons on the form and OnSelect:
Button 1
Newform (YourFlowName)
Button 2
EditForm (YourFlowName)
After clicking on the button the form will change
------------If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Did you try my idea?
Please note: you cannot edit items in a form while using a SQL View. It’s not possible in PowerApps because you are looking at a View not the table itself.
SQL Views are read-only!
@mdevaney is correct. This is not a PowerApps constraint, just how SQL works. If you load data from a view and want to save it back, you can a) use Patch() to update the underlying table(s) or b) pass the updated data to a SQL stored procedure. I do a lot of this type of work in my PowerApps and typically don't use forms myself.
@mike528
@mdevaney
@eka24
Thanks for all
that's mean I have to edit all DataCards (maybe to create custom blank DataCards and add the inputs is better) then use Patch to fill the data into the SQL
@ElMeSaFeRHonestly, don't even bother with the form control in this instance. Just place the controls on the Canvas directly and write a PATCH function
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 220 Super User 2026 Season 2
WarrenBelz 189 Most Valuable Professional
Mohsin Ali 139