Skip to main content
Community site session details

Community site session details

Session Id : i9ypq6LT1AwqrRZ6btoxDm
Power Apps - Microsoft Dataverse
Unanswered

Auto delete records when Created On is 7 years old (Business rule?)

Like (0) ShareShare
ReportReport
Posted on 4 Apr 2022 10:25:45 by 802

Hi there,

 

I am looking to find a way to auto delete records which have a Created On date of itself plus 2555 days (7 years). 

 

I am looking in Business Rule - but there is no action to "Delete"

 

How best can I implement this for just one Dataverse table?

 

Thanks

K.

  • Ram Prakash Profile Picture
    5,318 Super User 2025 Season 2 on 04 Apr 2022 at 11:12:41
    Re: Auto delete records when Created On is 7 years old (Business rule?)

    Hello @Kosenurm 

     

    You can use Out-of-the-box SYSTEM JOBS to perform that operation.

     

    Steps to follow 

     

    1. Navigate to https://make.powerapps.com

    2. Click Gear icon at the top then select Adavance Settings 

    3. Click Settings then click System Jobs.

    4. Click More Action then Select Bulk Delete.

    5. It will show a prompt in that Select Look For as Entity(Table Name) then Add a condition as Created on or Before (Then Input 31-Dec-2015)

    6. Click Next - then click Finish

     

    That's it 🙂

     

    Please mark as Answer if it is helpful and provide Kudos

     

     

    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

    Follow me on Twitter : @rampprakashd

    Blog : https://microsoftcrmtechie.blogspot.com

  • Mira Ghaly Profile Picture
    11,409 Moderator on 04 Apr 2022 at 10:48:34
    Re: Auto delete records when Created On is 7 years old (Business rule?)

    @Kosenurm 

    You can use the scheduled bulk delete feature please check below blog post to be able to do this:

    https://blogs.perficient.com/2021/02/16/power-platform-dataverse-cds-bulk-record-deletion/

     

     

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

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Featured topics