cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
deannab
Regular Visitor

EditForm not editable with SQL Server

I'm using Power BI to embed a Power app via the power app visualization tool.  My data in PBI connects to SQL Sever.  In the Power app, I have the gallery screen to view the data, then an edit screen with the EditForm.  The EditForm is also connected to SQL server because the user wants to view the data and edit it, sending it back to SQL. The problem I'm having is that no matter what permission changes I've made in SQL, I still cannot actually Edit the form. I've changed the DisplayMode to Edit. 

 

In SQL, I right click on the table (I only need 1 table), then select Properties, then Permissions.  I select my username and I keep checking "Grant" and "With Grant" but then they don't stay checked when I reopen.  

deannab_0-1662469606816.png

I've refreshed my sql connection in power apps, but I still don't have the Edit Text available.  I've changed the data card text to "Gallery.Selected.columnname" and also changed the display mode to edit. 

deannab_2-1662470151860.png

 

deannab_1-1662470081716.png

Here is my app setup: 

deannab_3-1662470236725.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
deannab
Regular Visitor

just needed to click "File, save" in SQL after making permission and primary key changes. 

View solution in original post

2 REPLIES 2
BCBuizer
Super User
Super User

Hi @deannab ,

 

Have you tried removing the datacard and then adding it back?



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.
deannab
Regular Visitor

just needed to click "File, save" in SQL after making permission and primary key changes. 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (1,898)