Unique record ID with autonumber

(0) Share

Report

Posted on by atray13

147

Hi,

In CDS i am trying to create a field in my entity that automatically assigns a unique record ID to each new record as they are created. I have tried creating a new field, with the data type set as autonumber, but i get this error message:

"The entity could not be updated: Attribute cr31d_recordid of entity cr31d_handover is not an Auto Number attribute. Please confirm the inputs for Attribute and Entity correctly map to an Auto Number attribute.."

Any ideas what's wrong?

Categories:

Entities

I have the same question (0)

All responses (7)

Answers (0)

GarethPrisk 2,828 on at

Like (0)

Report

Re: Unique record ID with autonumber

Did you follow the steps outlined here?

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/autonumber-fields

Please try these steps, and let me know what issues you encounter. There are a few things to note: the field will be a text field, or must be an existing text field, and it only works in the new solution experience.

Was this reply helpful? Yes No
v-siky-msft on at

Like (0)

Report

Re: Unique record ID with autonumber

Hi @atray13 ,

Could you please share more detail about your scenario?

If the field type is set as the AutoNumber, the AutoNumber field would be automatically generated when a new record is created.

When you have defined the AutoNumber field, you need to refresh the CDS entity connection before you implement any patch actions.

If it still doesn't work, please share more information about how did the error come about.

Sik

Was this reply helpful? Yes No
the365bit 136 on at

Like (0)

Report

Re: Unique record ID with autonumber

@atray13

Try to create an autonumber field in another entity, if you are able to do it and it works fine you must have a process running in the background of the entity that you are trying to create the autonumber.

If you share more details we might be able to help more.

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report

Re: Unique record ID with autonumber

To supplement on the other posts, there's also a nice tool in the XrmToolBox to manage auto numbers which can simplify your work:
https://anm.xrmtoolbox.com/
Cheers

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Unique record ID with autonumber

It is possible that the autonumber tool in xrmtoolbox added to the issue. There was a bug and I don't think the auto numbering is resolved. I noticed in my little personal environment that auto-numbering is not working as expected.

Was this reply helpful? Yes No
Arafat 189 on at

Like (0)

Report

Re: Unique record ID with autonumber

Hi @atray13

Were you able to resolve this? If yes then how?

Was this reply helpful? Yes No
SL84 7 on at

Like (0)

Report

Re: Unique record ID with autonumber

I just had this same issue. I was unable to update my text field to autonumber and I was also unable to add a new field with autonumber to the same entity.
I went into the settings for the entity itself and updated a setting, saved, and then I was able to edit the existing text field to autonumber.

I don't think the setting I updated made the difference, I think the entity needed the update. That said, I went to the section "Create and update settings" > "Enable change tracking".

I hope this works for others!

Was this reply helpful? Yes No