Cosmos DB Delete Document Fails

(1) Share

Report

Posted on by jarra64

I'm have very simple Power Automate using Cosmos DB connectors:

Cosmos Get All Documents (V3)
1. Apply to each body/Documents
  1. Cosmos Delete a document (V2)
    1. Database ID: xxx
    2. Collection ID: xxx
    3. Document ID: items('Apply_to_each')['id']

I have verified that all connections to db, collection and document Id's exist and return as expected.

I get the error: Entity with the specified id does not exist in the system

The id does in fact exist checking in both Azure data explorer as well as the response from Get All Documents (V3). The Power Automate debugger lists the correct id in the Document ID field.

This one has me really confused! Thank you.

All responses (2)

Answers (1)

jarra64 8 on at

Like (1)

Report

Re: Cosmos DB Delete Document Fails

Thank you @enzocano I didn't realize the double quote requirement for string partition keys.
Verified answer

enzocano 9 on at

Like (1)

Report

Re: Cosmos DB Delete Document Fails

I had the same problem; you should define the proper partition key to fix it.
For example, if you partition key is `/id` you must add that to the delete step. Also, you must cast the partition key to be string by enclosing the value with double quotes ("<value>") if you are using string (reference).

The following example is to delete a testcosmos document with "testcosmos" partition key