Can't delete CDS entity data

[mP]

Hi,

I am using the CDS contact entity in a powerapp.

Now I want to delete the sample data and fill in my data.

The option 'open in excel' works but when i delete rows in the table in excel and try to publish,an error occurs.

'

22:34:01 08.01.2017

Fehler beim Veröffentlichen Details: Während der Veröffentlichung sind 1 Fehler aufgetreten. 0 Änderung(en) wurde(n) erfolgreich veröffentlicht.

---

Fehler beim Veröffentlichen der Zeile Details: Das Löschen einer Zeile im Dataset Contact wurde nicht veröffentlicht. Fehlermeldung: 'Delete failed for table row of type 'RTSContact'. Infolog: Warning: Contact(RTSContactTable) cannot be deleted while dependent Case(RTSCaseTable) exist. Delete dependent Case(RTSCaseTable) and try again.; Warning: |Pas7c|The entity record could not be deleted because validation failed for the following data source: RTSContactTable (RTSContactTable) ''

What am I doing wrong?

Can someone help me!?

thx

Matthias

[v-monli-msft]

Hi MP,

All entities, whether standard or custom, are created with a set of read-only fields that you can't change, delete, or set to a value. Please check if you were trying to delete any of these system fields: Created Record Date, Created By, Modified Record Date, Last Modified By.

Also, what is the sample app name that you downloaded?

Regards,

Mona

[mP]

Hi Mona,

as you can see in the screenshot I open the data in excel and see the records, delete some rows, click to publish in the add-in and the error occurs.

In the Excelfile I think I cannot delete the read only system fields as they do not appear.

The app I created is not from a sample app, I created a blank app and connected to CDS entity contact.

Regards,

Matthias

[mP]

Hi Mona,

as you can see in the screenshot I open the data in excel and see the records, delete some rows, click to publish in the add-in and the error occurs.

In the Excelfile I think I cannot delete the read only system fields as they do not appear.

The app I created is not from a sample app, I created a blank app and connected to CDS database entity contact.

Regards,

Matthias

[CWesener]

Hi Matthias,

The error you're receiving is because the Contacts have been referenced on records in the "Case" entity. You need to delete the records in the case entity first, before it will allow you to delete the contacts.

We have an option to clear all the sample data before you've started creating your own data - but unfortuantley once you have both you do need to remove the sample data manually. We are working on improving this experience in an upcoming release.

Please let me know if this has helped.