web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to use Power Autom...
Power Automate
Answered

How to use Power Automate to update document metadata in a SharePoint document library.

(1) ShareShare
ReportReport
Posted on by 6
I need to use an "Automated cloud flow" to update the metadata for a document in a SharePoint document library using a calculated field.  When the calculated field changes I need to use that information to change the document name.  See metadata fields below.
 
Library:  "Documents - Cybersecurity"
 
Trigger
  • Metadata (calculated) field changes:  "Document Name (formulated)"
Action
  • Change metadata field:  "Name"
Categories:
I have the same question (0)
  • Verified answer
    anuragporwal Profile Picture
    71 on at
    Hi,
     
    Do this - 
     
    1) After saving the attachment to SharePoint, call Update file properties with the Created file’s ID and set your columns there. 
     
    2) If columns don’t appear, or for managed metadata/locked files, use HTTP:
    - Method: POST
    - Uri: _api/web/lists/getbytitle('LibraryName')/items(ItemID)/validateUpdateListItem()
    - Headers: accept: application/json;odata=verbose, content-type: application/json;odata=verbose
    - Body:
      {
        "formValues":[
          {"FieldName":"Title","FieldValue":"Inactive Users April"},
          {"FieldName":"Status","FieldValue":"Processed"},
          {"FieldName":"Dept","FieldValue":"IT"},
          {"FieldName":"MMColumn","FieldValue":"Term Name|<TermGUID>"}
        ],
        "bNewDocumentUpdate": true
      }
     
     
    Notes:
    - Managed metadata requires Term Name|TermGUID. 
    - validateUpdateListItem works when files are checked out/need approval. 
    - If you copied the file, get destination Item ID via Get file properties, then update. 
     
  • Verified answer
    Ellis Karim Profile Picture
    11,691 Super User 2025 Season 2 on at
    Hi @isguy
     
    Use the "Send an HTTP request to SharePoint" action to update the columns. Be sure to use the internal column names in the "Send an HTTP request to SharePoint" action.
     
     
    Example: Power Automate "Send an HTTP request to SharePoint" action updating Author and Editor fields in a document library item using the validateUpdateListItem endpoint:
    Ellis Karim's blog: Power Automate action configuring an HTTP POST request to SharePoint. The URI uses validateUpdateListItem with an ItemId, and the request body sets the Author and Editor fields for a document library item.
     
     
    Ellis Karim
    Ellis Karim
    elliskarim.com  |  LinkedIn  |  Bluesky
    If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard