web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / add fields items from ...
Power Apps
Answered

add fields items from SQL table view mode

(0) ShareShare
ReportReport
Posted on by 157

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

 

Annotation 2020-05-22 152726.png

 

 

is it normal ? 

what is the best practice in my case ?

 

Categories:
  • mdevaney Profile Picture
    29,993 Moderator on at

    @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."

  • eka24 Profile Picture
    20,925 on at

    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.

  • Sharif Alhennawy Profile Picture
    157 on at
    still same!
  • Sharif Alhennawy Profile Picture
    157 on at
    of course edit form
    and the default mode "New"
  • mdevaney Profile Picture
    29,993 Moderator on at

    @ElMeSaFeR 

    Did you try my idea?


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

  • Verified answer
    mdevaney Profile Picture
    29,993 Moderator on at

    @ElMeSaFeR 

    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!

     

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

  • Verified answer
    mike528 Profile Picture
    236 on at

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

     

     

  • Sharif Alhennawy Profile Picture
    157 on at

    @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 

  • mdevaney Profile Picture
    29,993 Moderator on at

    @ElMeSaFeR
    Honestly, don't even bother with the form control in this instance.  Just place the controls on the Canvas directly and write a PATCH function

     

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

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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 220 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 189 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 139

Last 30 days Overall leaderboard