Can't figure out edit field

[Charlotte12]

Hello,

I'm trying to make an edit form in order to edit specific fields, but it doesn't give me boxes to edit (see screenshot). I am connecting to an Azure database and I do have rights to edit the field there, but I can't figure out this form in PowerApps. Any help would be appreciated! Thank you. 

[Charlotte12]

@Drrickryp 

Okay, so I'm following up until I add the edit form. Once I add this form and connect to the data source, the edit form doesn't populate with the fields from my data source. I then hit edit fields, and add appropriate fields - but when I do this, I don't get those edit boxes that I see on your screen (see screenshot). It also doesn't give me the option to set the control type to edit (I'm going through an Udemy course and the videos switch to edit here but I don't have that option - and again I am able to edit in Azure)

[Drrickryp]

@Charlotte12 

Delete the datasource from the bar at the top of the screen and add it from the dropdown on the right side of the screen like in the first picture.  It behaves differently if you select it from the dropdown vs. typing it in yourself.  Don't ask me why.

[Charlotte12]

@Drrickryp That still doesn't work for me (and I tried it all over just to make sure). If I delete the data source from the bar at the top of the screen and then select it from the dropdown on the right side, it just adds it back to the top automatically. And I still have to go through the same motions of selecting fields and not having that edit option (not having those blue edit boxes appear) 

[Drrickryp]

@Charlotte12 

The error message on your screenshot indicates that you may not have privileges to make changes to the database or someone is using it and it is not allowing you to edit.    To trouble shoot this, go to make.powerapps.com and choose SQL follow the instructions and see if PowerApps can create an app for you or if it hangs up along the way and gives you an error message.

[Charlotte12]

@Drrickryp Yes it allows me to make an app, and I tried the edit form here and got the same issues...

(Again thank you for your responses and for trying to help me!!)

[Drrickryp]

@Charlotte12 

That process should have generated a three screen app.  It appears to me that you only got the first two screens and had to make your own edit screen.  This indicates to me that you have view only authorization for your database.  I would speak with the administrator and see if that can be changed.  

[Charlotte12]

@DrrickrypYea it must be the Azure data source and a hidden setting. I just called my team and tried another data source and it is editable when I follow your steps using that other data source. It's strange because I do have edit capabilities on the Azure data source... 

THANK YOU so much for your help - and if you have any ideas about a setting that I may be missing on Azure... 

[Charlotte12]

@Drrickryp are views uneditable in PowerApps? 

[Drrickryp]

@Charlotte12 

Views are editable and are a good way of prefiltering and presorting big datasources. I don't use Azure, my experience is with SharePoint and Dataverse so I wouldn't have any idea about the setting.  If my posts helped you solve your problem, please mark it solved so others can find it.