cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pankaj1
Level: Powered On

Edit Form in Power app

I am new to Power app, i am trying to create new app to take the data from Sql server can edit the records and update the value in table. For that by referring the below link : 

 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/working-with-forms

 

I have created three screens browser Screen, detail Screen and Edit Screen. I have getting data selected column data corrctly in all screens. but my problem is while edit.

 

1. As per post given in the link,. on Edit screen it shows labels and value in textboxes where as in my Edit screen all are coming labels/text , i have added Item Property as Scree1.selected. Why do i cant see the value in textbox

 

2. On yes tickmark and top most right , i have added code as SubmitForm(EditScreenName,None) but it is throwing error.

 

Thanks..

 

Any help on this two problems will be extremely helpfull

 

 

added Sql Source data source , added table fields 

2 ACCEPTED SOLUTIONS

Accepted Solutions
ChrisR
Level 8

Re: Edit Form in Power app

Screen1 would not have Selected data.  You would need to use the gallery on screen1 to get the selected record.

 

Example:  BrowseGallery1.Selected

 

The submit would also need to reference the form, not the screen

 

SubmitForm(Form1)

 

 

Chris

 

Highlighted
Super User
Super User

Re: Edit Form in Power app

In addition to what @ChrisR says, please also check you have a primary key in your table. Edit forms do not permit the editing of data against tables without a primary key.

4 REPLIES 4
ChrisR
Level 8

Re: Edit Form in Power app

Screen1 would not have Selected data.  You would need to use the gallery on screen1 to get the selected record.

 

Example:  BrowseGallery1.Selected

 

The submit would also need to reference the form, not the screen

 

SubmitForm(Form1)

 

 

Chris

 

Highlighted
Super User
Super User

Re: Edit Form in Power app

In addition to what @ChrisR says, please also check you have a primary key in your table. Edit forms do not permit the editing of data against tables without a primary key.

Pankaj1
Level: Powered On

Re: Edit Form in Power app

Thanks ChrisR and Timl for your help, I am able to edit the screen now for the SQL table. 

 

Need one more help which is my ulitimate goal. 

 

I have integrated Powerapp in PowerBI reoprt from app service, power BI report data source is taular cube. 

Is edit possible for the tabular cube, underlying table used in tabular cube should be updated.

 

Thanks ,,

Pankaj

 

 

 

 

 

 

 

 

Akumar
Level: Powered On

Re: Edit Form in Power app

Hello Pankaj,

I do have the same requirement to edit and view the sql data in PowerApps , how are you doing it ?
Have u created any list view to display list of sql data in PowerApps ? Too

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Users Online
Currently online: 170 members 5,366 guests
Please welcome our newest community members: