web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

How to delete OrderClose, OpportunityClose & QuoteClose Activities?

(0) ShareShare
ReportReport
Posted on by 29

We have been having on-going issues with database storage, mainly the ActivityPointerBase table growing in size. We managed to get a decent breakdown from Microsoft Support showing us that the OrderClose, OpportunityClose, CaseClose & QuoteClose activities are the highest counts on the ActivityPointerBase table.

Here is an example of the OrderClose activity:

pastedimage1684411708809v1.png

I don't see any benefit to keeping these system generated activities, but I cannot delete them via bulk deletion as the Activities table is not an option as seen in the below screenshot:

pastedimage1684407961993v1.png

I then created a cloud flow to try and delete these records but ran into an error message stating that I cannot delete these activities because the table does not support this method:

pastedimage1684408005334v2.png

Here is the logic I'm using in the flow:

pastedimage1684408100790v3.png

It lets me delete these activities via advanced find - but I would like an automated method.

I have the same question (0)
  • Verified answer
    Bipin D365 Profile Picture
    28,983 Moderator on at

    Hi,

    Instead of using Activities in Delete A Row action, you will have to choose Opportunity close/QuoteClose/Case close based on Activity type code from List rows.

    You will have to add  check condition and define various delete Action for each entity types .

    You can not directly use Activities in Delete action.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Pallavi Phade Profile Picture

Pallavi Phade 101

#2
Tom_Gioielli Profile Picture

Tom_Gioielli 69 Super User 2025 Season 2

#3
TAHER Mehdi Profile Picture

TAHER Mehdi 58

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans