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 / Move Sharepoint files ...
Power Automate
Unanswered

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

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