delete from dataverse table

[craigja]

I have a dataverse table called Contracts, I want to delete all rows created today - I use the Dataverse Input tool, with a custom OData filter and it returns the records I expect.  I then pass the results to the Dataverse Output tool, select the Contracts table and when it asks for the Field containing the primary key, I selected the Contracts field, since this has the GUID in it.  I get an error Unique identifier column not found.  Does anybody know what Im doing wrong?  What other column would it be?  Ive looked at the columns in the table and Contracts column is set as the unique identifer in the datatype field

[Shivangi105949 · Accepted solution]

You’re getting that error because the Dataverse Output tool only accepts the table’s Row ID (primary key), not any GUID-looking column. For the Contracts table, that key is typically “contract id”.

Do this:

1. In Power Apps > Tables > Contracts > Columns, find the Row ID (schema/logical name like contract id).

2. In the Dataverse Input tool, include contract id (and created on) in $select and apply your filter.

3. In the Dataverse Output tool (operation: Delete), pick contract id as the “Field containing the primary key”.

“Created today” filter (UTC example):
created on 2025-09-04T00:00:00Z and created on  2025-09-05T00:00:00Z
(Adjust the dates for the day you’re running it.)

Gotchas:

• Display names like “Contracts” aren’t the same as the logical name. You must use contract id.

• A custom GUID column won’t work; only the system Row ID does.