auto generate duplicate ID issue

[ArtU]

Hello,

I use "If(EditForm.Mode=FormMode.New, Text(First(Sort(LIST, ID, Descending))" to generate auto id. But when 2 users create new record at same time, there are duplicate ID issue. any suggestion? thanks.

[v-jefferni]

Hi @ArtU ,

Could you please share more details? Which data source is your App associated with? If it is a SharePoint list, there is a default and auto-generate ID column, why you need a manually generate ID column instead?

Anyway, there is a video for your reference:

PowerApps Excel Auto Increment Column - YouTube

and a thread:

Solved: How auto generate ID - Power Platform Community (microsoft.com)

code:

If(EditForm.Mode=FormMode.New, Text(Last(LIST).ID +1))

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[v-jefferni]

Hi @ArtU ,

Have you resolved the issue? 

If above post helps, then please consider Accept it as the solution to help the other members find it.

Best regards,
Community Support Team _ Jeffer Ni

[ArtU]

Hi,

Not yet, the duplicate ID issue still there.

[v-jefferni]

Hi @ArtU ,

I think the best approach (if you are using SharePoint lists as the data sources) is using the default ID column, which would increase automatically based on the timestamps of the new records. Or if there is column type like auto-number it could be an option.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.