cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
blopspro
New Member

Move SharePoint file based on column property

Hi,

 

I am looking to create a flow that can move a file within a document library based on which column property is selected.  There is a column which has 5 options and one of the options is to Archive.  If Archive is selected for this file, I want to move it to the Archive folder.  The file needs to keep it's version history.  I did quite a bit of searching and have not been able to find a solution.

Thanks!
b

2 REPLIES 2
SCTdan
Continued Contributor
Continued Contributor

Have you created a flow and it's not working properly?  

 

You should be able to start with a sharepoint trigger, 'When a file is created or modified (properties only)' set to your main document folder.  Then create a Condition, "if choice column value = archive" -> move file.  It will retain the version history so long as you move it (not copy).  

 

Let me know if that makes sense.

ShadiAyoub
Frequent Visitor

Hi @blopspro 

To do that I am using a scheduled flow where I use Get files (Properties Only)and filter query on the value which I want same as below screenshot. in my case I am using the values in two columns:
The first column: Checked_Out = 1 
The second column: PO = 1 


Capture.PNG
If I answered your question please accept my solution.

Regards,

 

Shadi

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (968)