Previously I provided an overview of why Power Automate disposition reviews are important to record management tasks for many organizations. With the introduction aside, let’s cover how to create a Power Automate disposition review from concept to execution. This process will create a custom message to the disposition reviewer. If approved it will delete the document and update a destruction tracker list in SharePoint. If rejected, the record manager will be notified to take necessary action.
Create a Simple Power Automate Distribution Review
Start with the Workflow
Before building the process, you first must plan out the process. In this case, we are going to deal with a simple situation. Create a disposition review with a customized message and approval workflow (we’ll do something more complex in my next post). The process of implementing a Power Automate disposition review process is actually to start with Power Automate. The workflow has to exist in the tenant before it can be linked to a retention label.
- Log in to Power Automate and click on Create. Select Automated cloud flow.
- Give the flow a meaningful name and select the trigger “When an item reaches end of its retention period” (a trick to find this one is to type retention in the search bar)
- For the purpose of this flow, all of the information necessary for the following steps are captured in the trigger so add an approval activity to the flow
- Approval Activity Type: Stop and wait for an approval
- Approval Type: Approve/Reject – First to Respond
- Add the custom message to the approval request and assign to the necessary approvers.
- Add a condition to track the approval process.
- If approved:
- Add the “Deletes the item” activity from the Microsoft Compliance connector.
- Fill in the information within the activity (all fields are available from the workflow trigger)
-
- Update the Destruction Tracker list
Note: For large organizations, a SharePoint list will likely not be the best place to track this. A SQL database would likely be better.
- If rejected:
- You can follow any process you wish here, but be aware that at this time there isn’t any of the standard disposition controls such as relabel, extend retention, etc. available at this in the Power Automate workflow connector. In this case, I am simply going to send a notification to the record manager to have them review the document. But I would update the flow to follow any internal process defined within your organization.
Attach Workflow to Retention Label
Once the disposition workflow has been created, the next step is to create the label and link to the disposition workflow created for this purpose.
- Login to the records management console within Microsoft Purview
- Click on the File plan tab and click “+ Create label”
- Provide the label with a meaningful name and description based on your organization’s record plan and click Next.
- Fill in the necessary descriptors for the label (optional) and click Next.
- Select the label retention settings and click Next.
- Fill in the required retention timeline based on the file plan and click Next.
- Select how the label will protect the document during the retention period and click Next.
- At the screen “Choose what happens after the retention period” select the option “Run a Power Automate Flow“
- Click on “+ Select a flow“
- Select the flow created above.
- Click Apply and then Next.
- Review the configurations and click Create Label
- Deploy your label and wait for a document to trigger for retention.
Once the retention schedule completes the selected user(s) will receive the notification to dispose of the document and once it has been done, the workflow deletes it.
Approval Email:
IMPORTANT NOTE: I really want to point this out because it caught me the first time. Using the M365 Compliance Connector will NOT result in immediate deletion. It instead runs the back-end disposition process so you have to wait for that to run.
After approval (note file still exists):
Once backend processes had run:
And a view of the custom destruction log:
Thanks for reading!
Comments