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 / How to get Edit text i...
Power Apps
Unanswered

How to get Edit text in Control type

(0) ShareShare
ReportReport
Posted on by

Hi,

I have read and write access to the azure database, I can connect and add the data source to the power apps but I am not being able to edit/update the fields and only can get view text in control type after adding the fields. I am just curious to know if I still missing some requirements to get edit text in control type after adding the fields in power apps so that it will update the field in power bi as well as in azure database.

Thank you.

Categories:
  • Michael E. Gernaey Profile Picture
    53,970 Super User 2026 Season 2 on at

    Hi @Ansu8371 

     

    To edit data in any back end you have to do one of the following

     

    1. Use Built in Controls :

    • Add a DataCard / Form to the screen. Bind it to the data and then have a button to do a Submit of the Form back to the back end

    2. Create in Code

    • Add controls to the screen that are bound to a data source
    • Add a Gallery
    • Add a TextInput into the gallery, bind to a Field of a datasource
    • add a button that executes a Patch statement to update the back end

    3. Create an Edit Form (OOB functionality) that is bound to the data source.

     

    You can't just bind to it and then make a change and its auto written, you have to do one of those 3 up there. There are other ways, but those are standard.

     

    Also, I am assuming Power BI is bound to the Same Source you want to update in this App. And therefore will update on its next Scheduled Update once the Azure Database is updated


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • Ansu8371 Profile Picture
    on at

    Thank you for the response Mike, I have found the issue why I didn't get the edit text option in Control type; it is because of missing primary key in source database. I am able to update the values now after defining the primary key.

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 360 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 325

#3
Mohsin Ali Profile Picture

Mohsin Ali 232

Last 30 days Overall leaderboard