BulkDelete action in Dataverse

(0) Share

Report

Posted on by Jean M.

Hello!

We have an annual data clean-up wherein we need to delete Contact records that doesn't have any Case associated to it. I couldn't find a reference of query set syntax with related entity used as a filter condition. Would you please help translate below FetchXML query to a QuerySet that is used in PowerAutomate? Thank you!

All responses (7)

Answers (0)

Susie Z 14 on at

Like (1)

Report
BulkDelete action in Dataverse

Hi Jean,

A bit late for a response, I hope your query was solved!

For reference, the syntax below works for related entities in the Power Automate unbound action.

[
{
"EntityName":"<sourceentity_schemaname>",
"LinkEntities":[
{
"LinkFromEntityName":"<sourceentity_schemaname>",

"LinkFromAttributeName":"<sourceentity_column_schemaname>",
"LinkToEntityName":"<relatedentity_schemaname>",

"LinkToAttributeName":"<relatedentity_column_schemaname>",
"JoinOperator":"Inner",
"LinkCriteria":{
"Conditions":[
{
"AttributeName":"<column_schemaname>",
"Operator":"Equal",
"Values":[
{
"Value":"<value>",
"Type":"System.String"
}
]
}
]
}
}
]
}
]

References:

General syntax examples https://philcole.org/post/bulkdelete

LinkEntities property MS docs https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/reference/linkentity?view=dataverse-latest
Jean M. 26 on at

Like (0)

Report

RE: BulkDelete action in Dataverse

Hello Steve Zhao2 , thank you for your help. I've checked the link provided but it doesn't contain syntax for link-entity. Would you know any other reference that we could use? Also, I tried to pattern the syntax for link-entity condition but it doesn't work.
Albion Ferracaku 20 on at

Like (0)

Report

RE: BulkDelete action in Dataverse

Hello,

According to your query, field "..caller" of "contact" should be null. So selecting field "..caller" in "Fields" section and choosing "Does Not Contain Data" should be enough.

(in my case: "Account" is a lookup field that points to Account entity)
Steve Zhao2 on at

Like (1)

Report

RE: BulkDelete action in Dataverse

Hi Jean M,

There is a tool named FetchXML builder which can convert fetchxml to Query Expression in the Xrm Toolbox.

However, it isn't the format of QuerySet in the Bulk Delete action and you need manually build it.

About the format, you can refer to this link:

Solved: Dataverse - Perform an unbound action - Bulk Delet... - Power Platform Community (microsoft.com)
Bipin D365 28,959 Super User 2024 Season 1 on at

Like (1)

Report

RE: BulkDelete action in Dataverse

Hi,

Create rollup field on consumer entity of type whole number to store the count of case file records.

learn.microsoft.com/.../define-rollup-fields

Now use this field in your filter criteria

if yourrollupfield value ==0 Delete
Jean M. 26 on at

Like (0)

Report

RE: BulkDelete action in Dataverse

Hello Bipin Kumar, thank you for your response. Unfortunately, does not contain condition (for related entity) is not available as operator in Bulk delete. Would you know if there is a workaround for this one? Our goal is to delete consumer (contact) records that doesn't have any case(file) associated to it.

Here's the condition used in the view.
Bipin D365 28,959 Super User 2024 Season 1 on at

Like (0)

Report

RE: BulkDelete action in Dataverse

Hi,

Can you not setup oob bulk delete jobs to cleanup your records?

learn.microsoft.com/.../delete-bulk-records