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 / Create A Flow To Chang...
Power Automate
Answered

Create A Flow To Change Metadata

(0) ShareShare
ReportReport
Posted on by 42

Hello, 

 

In the document library, I had several metadata columns set up such as "Responsible Party." Our company's CEO changed, so we want all the contracts under the current CEO to be changed into the new CEO's name (which is linked to his email). As expected, there are probably about a hundred contracts scattered in the library (and folders) and was wondering if there is a flow that can be implemented to do it. Please show a clear step-by-step procedure. 

Categories:
I have the same question (0)
  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    @IceQueen  you could also do it using Edit in Gridview option in library as shown in below screenshot, that will not require you to use flow

    annajhaveri_0-1624881168745.png

     

     

  • IceQueen Profile Picture
    42 on at

    @annajhaveri 

    Right, I did see that we could edit it manually one by one. However, we wish to make it an automatic process using PowerAutomate since there are hundreds of contracts. 

  • Verified answer
    annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    @IceQueen  you can create instant flow, with Manual button trigger, then add Get Items action to get items from SharePoint, then add Apply to each action and provide value (list of items) from dynamic content of Get Items in the input of apply to each. Then add Update Item action inside apply to each, provide ID value from get items dynamic content, and provide value of columns to be updated. 

    annajhaveri_0-1625066268777.png

     

    To test first, in Get Items provide top count of 2, then test it and if it works as expected then you can run the flow without top count. Also if you want to process hundreds of records you need to turn on pagination and provide a threshold for number of records you want to process at a time, in Get Items settings. 

     

    annajhaveri_1-1625066348348.png

     

    One more thing i would suggest, if you process hundreds of records at a time, the flow will run slow, so alternatively you can provide filter query in the Get Items action to process limited number of items at a time.

     

     

  • IceQueen Profile Picture
    42 on at

    @annajhaveri 

     

    Hello, 

     

    So, my "Update Items" event is like this:

    IceQueen_0-1625594281959.png

    I'm not sure what to enter the list as....

     

    On another note, the "Update File Properties" event (looks sorta more promising) 

    IceQueen_1-1625594365440.png

    since I want to change the Responsible Party but so far I when I run it, nothing seems to change in the file. Also, why does it require me to have a "File Type Value"?

     

  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    @IceQueen  yes i realized that as you have a library instead of list you can use update file properties action. When you say nothing seems to change in file, you mean in the columns data of the file or contents inside the file? Regarding file type value, is that a required column in the library, if yes then you will need to provide value for it, for required columns you can provide the value from Dynamic content of Get Items action.

  • IceQueen Profile Picture
    42 on at

    @annajhaveri Never mind, it was a mistake on my part. 

    However, although I can get run the flow on the test folders I am using, it for some reason does not work on the "Contracts" folder (which is why I am creating this flow). More info can be found at:

    https://powerusers.microsoft.com/t5/Using-Flows/PowerAutomate-Flow-Unable-To-Enter-Folder-Contents/m-p/1002538

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 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard