Update Metadata in Bulk - PowerAutomate

Synopsis: Use PowerAutomate to update Metadata values in bulk.

Published August 5th, 2025
Last Modified: August 5th, 2025

Intro: Following through with a request to update approx 2000 files in a SharePoint library with unique IDs. This was an Archive space, and was a flat container with unique file names. Faced some initial difficulties with parsing a CSV for use with Automate, and elected to use a list instead.






Quick Run Down

    1.) Import the CSV into a SPO List

    2.) Create the PowerAutomation

Import the CSV into a SPO List.

    Create a new list, and choose the 'Import from CSV' option.

Create the PowerAutomation.

    Flow Outline

    a.) Manually trigger a flow

    b.) Get Files (properties only)

    c.) For Each
    c.i) Get Items
    c.ii.) For Each 1
    c.iii.) Update File Properties

    Additional Details and Screenshot

  • On the initial Get Files (properties only) card, ensure that Pagination is enabled on the 'Settings' tab to allow your flow to return more than the default 100 files.

  • For each, on the previous Get Files card. This was done so we have the ID reference required in the final 'Update File Properties' card.

  • On the Get Items card, You'll filter the query by Title. This will return only the row with the file name in the CSV.
    "Title eq '@{items('For_each')?['{FilenameWithExtension}']}'"

  • On the file update properties, you'll specify the ID in 'For Each', and then the MetaData value from the column returned in 'For Each 1'


Newest Post