Autoincrement on PK / problem with MS SQL DB

Like (0) Share

Report

Posted on 30 Jun 2021 18:45:00 by Community Power Pla...

Hi,

I have a table in a MS SQL Server DB which has a PK and setup to autoincrement (integer value):

However, my Powerapp - where I use the patch function to create a new record complains about not proving this key. I have refreshed the DB source connection, removed and refreshed it, but I is still complaining about the missing field an throwing an error.

What I am missing ? I thought and that is what I am reading from other posts that unlike for other DB types (e.g. Postgres, MySQL) this should be possible out of the box with MS SQL. Or is my understanding wrong?

Appreciate if someone can pinpoint me to solving this issue!

Cheers,

Udo

All responses (5)

Answers (0)

zmansuri 6,048 Super User 2024 Season 1 on 30 Jun 2021 at 19:20:27

Like (0)

Report

Re: Autoincrement on PK / problem with MS SQL DB

I agree.
Community Power Pla... on 30 Jun 2021 at 19:16:47

Like (0)

Report

Re: Autoincrement on PK / problem with MS SQL DB

@zmansuri thanks for the research...I read that post you provided also earlier, but I thought some solution must be out there, because I also came across this post where the user claims not having had an issue with MS SQL:

postgresql - PowerApps Postgres auto increment ID - Stack Overflow

But reading through your posted thread a bit more user still (this year) complain about the missing support for this. So I guess I have to get rid of the autoincrement and determine the next value myself as a workaround...😒 that is pretty lousy considering that we are in year 2021 where 20 years ago this was possible in php or coldfusion etc. etc. I do not get it...
zmansuri 6,048 Super User 2024 Season 1 on 30 Jun 2021 at 19:05:41

Like (1)

Report

Re: Autoincrement on PK / problem with MS SQL DB

Ok i searched it.
PowerApps connection to MySQL: id issue - Power Platform Community (microsoft.com)
This post is from 2019. i am assuming issue still exist.
Community Power Pla... on 30 Jun 2021 at 19:02:43

Like (0)

Report

Re: Autoincrement on PK / problem with MS SQL DB

Hi @zmansuri ,

thank your trying to help! Really appreciate...I tried that and it is coming back with a type error (text instead of expected int) 🙄:
zmansuri 6,048 Super User 2024 Season 1 on 30 Jun 2021 at 18:53:47

Like (0)

Report

Re: Autoincrement on PK / problem with MS SQL DB

I haven't work with SQL. But, try this add id columns syntax with patch in the value just write ""
Like {ID:""}