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

Creating Apps - No Edit Screen

I'm trying to create a simple app over a local postgres database, but having some trouble when editing data/creating new records.

 

I'm using the wizard to create a simple three screen app, but it will only create BrowseScreen1 & DetailScreen1 - no EditScreen1, or insert/edit icons in the title bar. 

powerapps.jpg

 

If I try then to add an edit form, the datacards contain only the Key/Value items, but as labels rather than proper form controls.

powerapps2.jpg 

 

I've tried creating something some scratch using Excel hosted on Dropbox, which worked - so I'm guessing it's something to do with the Postgres data connection.

 

Any ideas?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Creating Apps - No Edit Screen

Hi @mjsonline

 

This behaviour usually occurs when the table doesn't have a primary key.

 

http://www.postgresqltutorial.com/postgresql-primary-key/

 

Have you defined a primary key on your table?

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Creating Apps - No Edit Screen

Hi @mjsonline

 

This behaviour usually occurs when the table doesn't have a primary key.

 

http://www.postgresqltutorial.com/postgresql-primary-key/

 

Have you defined a primary key on your table?

View solution in original post

mjsonline
Level: Powered On

Re: Creating Apps - No Edit Screen

Cheers timl - that's fixed it perfectly.

 

That'll teach me for being a lazy data warehousing type with little regard to table constraints!

mjsonline
Level: Powered On

Re: Creating Apps - No Edit Screen

Cheers timl - that's fixed it perfectly.

 

That'll teach me for being a lazy data warehousing type with little regard to table constraints!

Itsdeep
Level: Power Up

Re: Creating Apps - No Edit Screen

Hi, 

This solution is not working for me. I didn't have primary key on table then I added primary key constartint. Still, I am not getting Edit Screen. My data source is sql server

Screenshot_10.pngScreenshot_9.png

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (6,531)