In order for you to get the most out of SharePoint as a document managing tool you want to keep your file’s properties up to date. Using Power Automate and the REST API in SharePoint can do this for you in a more efficient way.

In this blog we will go over the steps to creating a flow in Power Automate to update file properties in SharePoint.

Step 1: Create A New Flow in Power Automate
Navigate to Power Automate and create an instant cloud flow with a manual trigger.

Step 2: Create 4 Compose action cards to hold your Doc Site URL, Site-Relative-Path, Library Name, and Status.

Step 3: Get File Properties
Add a “Get file properties” action card and fill the Site address and Document library with Outputs from the Compose Action cards.

Step 4: Add a “Apply to each” action card with the following details:
Compose action card(File-Property): Current item
Compose action card(File-ID): item()?[‘ID’]
Send an HTTP request to SharePoint action card: with the details in step 5

Step 5: Send an HTTP Request to SharePoint
Add a “Send an HTTP request to SharePoint” action card and configure it with the following details:

Site Address: The URL of your SharePoint site.
Method: POST
Uri: _api/web/lists/getbytitle(Outputs expression)/items(Outputs expression)
Headers:
{
  "Accept": "application/json;odata=verbose",
  "Content-Type": "application/json;odata=verbose",
  "X-HTTP-Method": "MERGE",
  "IF-MATCH": "*"
}
Body:
{
  "__metadata": {
    "type": "SP.Data.OutputsItem"
  },
 "FlowTrigger":"Start Flow",
 "DocumentStatus":"Outputs"
}

The flow should look like this when completed:

---