Hi,
I am a beginner to powerapps and ssms, hopefully someone can help me
If I do not add a primary key to my child table in ssms, the "plus" data icon is not visible:
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
Solved! Go to Solution.
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.
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.
Good day, thanks for your advise!
Works perfect.
John
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
203 | |
187 | |
81 | |
50 | |
37 |
User | Count |
---|---|
290 | |
244 | |
122 | |
74 | |
55 |