cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mr-dang
Level 10

CDS entity not writing new record

I have an entity called UserBank that has not been able to write new records for the past few months. This is true while trying to do it in the Excel add-in and within an app. I don't exactly understand the error:

 

 

Error Publishing Row
Details:
A row created in data set UserBank_ was not published. 
Error message: 'Write failed for table row of type 'RTSUserBank_'. 
Infolog: Error: Cannot create a record in RTSUserBank__Table (UserBank). The record already exists..'

 

It says the record already exists, but it's a new record so I don't see the problem. 

 

Can I get some help on this?

 

Microsoft Employee
@8bitclassroom
1 ACCEPTED SOLUTION

Accepted Solutions
PowerApps Staff CWesener
PowerApps Staff

Re: CDS entity not writing new record

 

I'm glad to hear it. We have a known issue at the moment with our autonumbers - and there are scenarios where you can get into a situation where your next number to be issued, as already been used - this is why you get an error because the unique value has already be used once in your entity.

 

We need to handle this more gracefully, and progress the numbers, or allow you to control the next number - we are working on both of these to improve autonumber in the future.

 

Thanks again for reaching out,

Thanks,
Clay.

View solution in original post

10 REPLIES 10
Community Support Team
Community Support Team

Re: CDS entity not writing new record

Hi @mr-dang,

 

Would you please share more details about the mentioned field "RTSUserBank_ ", including its data type, and the field property?

The error message you posted seems to be mostly related with the field property restriction.

Please share the data types in an example, I will check and see if I could reproduce this.

Regards,

Michael

 

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JWilding
Level: Powered On

Re: CDS entity not writing new record

Hi @v-micsh-msft,

 

I seem to be having the same issue. This appears to have happened while I have been absent from the office - no one else monitors my app, so nothing has been changed.

 

Hopefully you can assist?

 

I have attached screenshots below with my error message (same as @mr-dang, RTS...) and the property field settings for each data field. 

 

Capture.PNGScreenshot_2017-09-04-15-15-35.png

 

Thanks, 

James

PowerApps Staff CWesener
PowerApps Staff

Re: CDS entity not writing new record

Hi Mr Dang / James,

 

If you could confirm that your entities have a Primary Key field that is of type Auto number? If so, it's most likely there is an error with the autonumber that is what's causing the potential duplicate error.

 

If that's the case - if you could send me some information in a private message here - we can get the team to look at your environments. If you could please go to web.powerapps.com and select your environment, then open the list of entities, select the Account entity. Once you are on the Account entity field list, copy the full URL in your browser.

 

If you could send that to me along with the name of your entities - we will have a look at it for you.

 

Thanks,

Thanks,
Clay.
Highlighted
PowerApps Staff CWesener
PowerApps Staff

Re: CDS entity not writing new record

Hi Mr Dang,

 

Your environment should be updated - please retest and let me know if you're unblocked.

 

Thanks,

Thanks,
Clay.
mr-dang
Level 10

Re: CDS entity not writing new record

@CWesener

Confirmed:

My entity is working!

powerapps test userbak.png

 

I'm curious what was happening with it?

 

 

Thank you very much!

Microsoft Employee
@8bitclassroom
PowerApps Staff CWesener
PowerApps Staff

Re: CDS entity not writing new record

 

I'm glad to hear it. We have a known issue at the moment with our autonumbers - and there are scenarios where you can get into a situation where your next number to be issued, as already been used - this is why you get an error because the unique value has already be used once in your entity.

 

We need to handle this more gracefully, and progress the numbers, or allow you to control the next number - we are working on both of these to improve autonumber in the future.

 

Thanks again for reaching out,

Thanks,
Clay.

View solution in original post

Renuka
Level: Powered On

Re: CDS entity not writing new record

Hello,

 

Am also getting the same error while submitting the form for an entity while creating new record ...

 

please help me out

PowerApps Staff CWesener
PowerApps Staff

Re: CDS entity not writing new record

Hi Renuka,

 

Sorry to hear you're having problems. If you could send me some information in a private message here - we can get the team to look at your environments. If you could please go to web.powerapps.com and select your environment, then open the list of entities, select the Account entity. Once you are on the Account entity field list, copy the full URL in your browser.

 

If you could send that to me along with the name of your entities - we will have a look at it for you.

Thanks,
Clay.
Mattias1
Level: Powered On

Re: CDS entity not writing new record

Hi.

I have this problem now. I tried to create a new Common Data service Entity. I get the same error. Is it something wrong with the Primary ID? 

RecordId is automatically created but I can see that the checkbox Unique is not checked.

 

I can see this problem is from 2017. Surely you have a solution for this

 

Thanks in Advanced. 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,584)