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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Move Sharepoint files ...
Power Automate
Answered

Move Sharepoint files with specific Retention Labels to new Sharepoint folder

(1) ShareShare
ReportReport
Posted on by 2
I've read through this forum many times, and there have been a few questions similar to this however I've not been able to enact the solutions suggested.  I have been tasked with moving files in sharepoint sites (specific ones, lets call it X for now) that have a Retention Label of - lets call it '1Year'
 
While Retention labels are intended to function as just that - for retention, the ask for me is to place these files in a new location where they can be 'reviewed' by another group (out of extreme caution/etc).  There are hundreds of files in each site, so an automation is preferable to manually selecting them.
 
I have attempted to create flows using the Sharepoint connector in the Power Automate Cloud that get file properties, and filter by the column - however the column request is failing.  I suspect its because its not a 'standard' column.
Action 'Get_files_(properties_only)' failed: Column '_ComplianceTag' does not exist. It may have been deleted by another user
I've used 'label', '_ComplianceTag', and a few other options.   So I'm guessing the column idea is a bust.
 
These files are not part of any special consideration, and simply live in the 'Documents' of the sites I'm working with.   
 
I'm not using any special filters, nor do I know how for that matter.  I've signed up for classes and training for Power Automate, however the completion date for this is before those start.   I appreciate any suggestions, insights, or ideas anyone has.
 
Manually Trigger
Get Files properties only (tried filtering on the columns eq '1Year'
For each, if the file DOES contain '1Year' in the tag, move to specified folder.  
 
Categories:
I have the same question (0)
  • Verified answer
    Michael E. Gernaey Profile Picture
    53,963 Moderator on at
     
    Were you able to get help with this?
     
    I was going to suggest, you can use the When an Item reaches end of its retention Action to move the file.
     
    Please take a look here as this is what you would use for that
     
     
    If this solves your problem I'd appreciate if you could Mark as such :-) and maybe a like.
     
    But yes, if you read that it literally shows you about triggering then using power automate to move the file so your other people can review it.
     
    Cheers!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 791

#2
Valantis Profile Picture

Valantis 582

#3
Haque Profile Picture

Haque 529

Last 30 days Overall leaderboard