Unanswered

Move SharePoint file based on column property

(0) Share

Report

Posted on by blopspro

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

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

SCTdan 604 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
ShadiAyoub 34 on at

Like (0)

Report
Copy link

Link copied!

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

If I answered your question please accept my solution.

Regards,

Shadi

Was this reply helpful? Yes No