Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Sharepoint Library Sub-Folder Metadata

(2) ShareShare
ReportReport
Posted on by 10
We have set up a Sharepoint Library for our projects
Each project parent folder contains the same subfolders (based on project phases)
We have set up metadata for this library (Portfolio, Strategy, Service etc)

 
We want the metadata in the sub folders and documents to be inherited from the top level folder.
I did some research and found that document sets will partially solve this for us. I have created a 'project' content type 
All documents within the parent folder inherit the metadata.
We have also templated the folder structure as 'default content within the 'project' content type.
The issue is that these subfolders are dont inherit the metadata from the parent.
 
I'm looking at a power automate flow to update the metadata on all of the sub-folders. To do this:
I have added a Yes/No Column called update. The trigger is when I change the column for a specific project to yes.
I am trying to get items
 "$filter": "path eq @{triggerBody()?['{FullPath}']}"
 
This is producing an error 
Action 'Get_items' failed: The expression "path eq Asset Projects/XXX" is not valid. 
 
Could anyone provide any advice? Thanks
  • Verified answer
    Michael E. Gernaey Profile Picture
    43,177 Super User 2025 Season 1 on at
    Sharepoint Library Sub-Folder Metadata
    Hi,
     
    An expression has to be like this
     
     
    ColumnName eq 'Value' 
     
    If the column name as a space then do
    [Column Name] eq
     
    and the string MUST have single quotes around it. But you will have to manually add them, EVEN if you are putting in a dynamic property value that is a string
     
    ColumnName eq 'DynamicProperty'
     
     

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >