Run an update query on a List e.g. only keep recent records

Avatar

Avatar
Validate 1
Level 1
alexbcf
Level 1

Like

1 like

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
alexbcf
Level 1

Like

1 like

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
alexbcf
Level 1

31-08-2018

Hi all,

I have a List. I want to create a workflow that runs daily and only keeps records in the List that are 30 days young (I have a "created" column).

I could potentially, read List, then select last 30 days and save again (deleting existing records).. but I am afraid that while this runs I might miss records that have been added between start and end of this flow.

Is there an easier more standard way to delete older records?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Vapsy
Employee

02-09-2018

Hi alexbcf,

There is no out of the box functionality which you can use.

The workaround that I can suggest is, give the power to purge a list to the same workflow that creates the list.

Once a day on that workflow, before starting the transition that go ahead with purging 30 days older data and once it has done by reading list, identifying data which is within the last month, scope, merge it with the new data that should be part of this list using Union activity, update the list using the condition delete and recreate the list.

Regards,
Vipul

Answers (0)