I have a workflow that updates a list to show the status of the approvals that are generated by PowerAutomate.
If outcome of the approval request is Approve, I want to delete that item from the list after 7 days.
IE: Approval is done on 2/1/22, I want to delete the item from the list on 2/8/22. I am using the list for a PowerBI report and I want to make sure that I clean up the list so that it doesn't get large. Not sure if it is best to do this as part of my approval workflow, or if I should schedule a separate flow that gets the items and deletes those that are a week old.
I am able to get the items, but having issues determining how to identify which items have met that 7 day threshold and are ok to delete. I do not want to delete them until the Date Approved is 7 days old.
Solved! Go to Solution.
I actually decided to create a calculated field in my list for a file called Delete Date. When the Date Approved is entered, it adds 7 days to that. I then will have my flow look for an item where that date = today and delete.
I actually decided to create a calculated field in my list for a file called Delete Date. When the Date Approved is entered, it adds 7 days to that. I then will have my flow look for an item where that date = today and delete.
User | Count |
---|---|
92 | |
45 | |
21 | |
18 | |
17 |
User | Count |
---|---|
144 | |
50 | |
43 | |
40 | |
31 |