cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Demo Extravaganza Championship Voting Open

Voting Ends: October 30, 2019!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

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

Top Kudoed Authors
Users Online
Currently online: 411 members 4,496 guests
Please welcome our newest community members: