Power Automate Flow — Notify Reviewer on File Creation + Notify Again When Completed

Power Automate – Reviewer Notification & Completion Workflow
Purpose

Automate document review notifications in SharePoint by:

Emailing the assigned reviewer when a document is created

Emailing the reviewer again when the document status is marked Completed

Updating required file properties at completion

Scope

Applies to SharePoint document libraries that use:

Assigned Reviewer (Person/Group)

Status Value (Choice)

Prerequisites

Edit access to the SharePoint site and document library

Power Automate permission to create flows

Required columns already created in the library

Procedure
1. Create the Flow

Go to Power Automate → Create → Automated Cloud Flow

Flow name: Document Review and Completion Workflow

Trigger: When a file is created or modified (properties only)

2. Configure Trigger

Site Address: Select target SharePoint site

Library Name: Select document library

3. Get File Properties

Add action: Get file properties

Site Address & Library Name: Same as trigger

Id: Use ID from trigger

4. Notify Reviewer on File Creation

Add Condition:

Created is equal to Modified

If Yes:

Action: Send an email (V2)

To: Assigned Reviewer Email

Subject: New Document Assigned for Review – File Name

Body: Reviewer name, document name, clickable link

If No:

Leave empty

5. Check for Completion Status

Add second Condition:

Status Value is equal to Completed

6. Update File Properties (Completed)

Inside Yes branch:

Action: Update file properties

Id: From Get file properties

Status Value: Completed

Populate other required fields (e.g., Project Owner Claims)

7. Notify Reviewer on Completion

Action: Send an email (V2)

To: Assigned Reviewer Email

Subject: Document Completed – File Name

Body: Confirmation message, document link, phase, due date

Testing & Validation

Upload a new document → creation email received

Update Status Value to Completed → completion email received

Confirm links open correctly

Maintenance Notes

Avoid file-level permission changes

Keep permissions at site or library level

Review flow if columns are renamed or deleted