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!

I have the same question (0)

All responses (7)

Answers (0)

Bipin D365 28,983 Moderator on at

Like (0)

Report

Hi,

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

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

Was this reply helpful? Yes No
Jean M. 48 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Bipin D365 28,983 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
Steve Zhao2 on at

Like (1)

Report

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)

Was this reply helpful? Yes No
Albion Ferracaku 20 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Jean M. 48 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Susie Z 14 on at

Like (1)

Report
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

Was this reply helpful? Yes No