cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate I
Advocate I

Azure, without primary key in child table not possible to add data

Hi,

I am a beginner to powerapps and ssms, hopefully someone can help me Smiley Happy

If I do not add a primary key to my child table in ssms, the "plus" data icon is not visible:

Knipsel.JPG

 

However, when I add a primay key, the 'plus' icon is visible.

As I do not want to add data to the primay key field (which is now mandatory), what do I have to do?

 

Thanks a lot for your answer!

 

John

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Hi John,

For the SQL Server connector to connect to a table, it is a mandatory requirement for the table to have a primary key.

If it's just the case that you don't want the user to enter a primary key value in your form, you can an int column to your table and set the Identity property to true. This will create a server generated, auto-incrementing primary key value in your table.

View solution in original post

2 REPLIES 2
Super User III
Super User III

Hi John,

For the SQL Server connector to connect to a table, it is a mandatory requirement for the table to have a primary key.

If it's just the case that you don't want the user to enter a primary key value in your form, you can an int column to your table and set the Identity property to true. This will create a server generated, auto-incrementing primary key value in your table.

View solution in original post

Good day, thanks for your advise!

Works perfect.

John

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (3,441)