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

Community site session details

Session Id : IdHJzADgxx0yZjwvSAhFb6
Power Automate - Building Flows
Answered

Flow to move a library folder up 1 level based on a list column status

Like (0) ShareShare
ReportReport
Posted on 9 Mar 2020 04:06:02 by 43

Hello

 

I have inherited looking after our team's SharePoint page and have very little knowledge or experience with SharePoint and workflows etc. The previous person setup many good workflows with SharePoint Designer. There is one workflow for new projects where when a new project is added to a list there is a project number generated and a corresponding folder created with that number in a library. I want to create a flow so that when the project list item has a 'status' column changed to complete the corresponding library folder moves up a level to a folder called archive. Please advise of the best way to do this? Thank you.

 

Regards

Nick

I have the same question (0)
  • Nick_k Profile Picture
    43 on 11 Mar 2020 at 08:32:20
    Re: Flow to move a library folder up 1 level based on a list column status

    Hi  efialttes.

    I have my flow working and i'm very happy. Thank you for your advice!

    Regards

    Nick

  • Nick_k Profile Picture
    43 on 11 Mar 2020 at 03:39:08
    Re: Flow to move a library folder up 1 level based on a list column status

    The folder name is a combination of 2 column values, the Folder No and Title Column. EG the folder is called XXX-OS-455-Network Install. The XXX-OS-455 comes from the Folder No column and the Network Install comes from the Title column.

     

    Sorry for the back and forth, I'm really quite a novice with Flow... 😞

  • efialttes Profile Picture
    14,756 on 11 Mar 2020 at 03:27:04
    Re: Flow to move a library folder up 1 level based on a list column status
    Hi
    I think it will be easier if you provide us an example: this folder is called xxx and the 'number' is stored in a SP list column called yyy. The column is defined of type ( number, single line of text,...)
    Thanx!
  • Nick_k Profile Picture
    43 on 11 Mar 2020 at 03:22:38
    Re: Flow to move a library folder up 1 level based on a list column status

    Yes the folder is created with the number that is generated. but how do you specify that specific folder for moving? Also do i need to put any actions in the 'if yes' and 'if no section'?

     

    Regards

    Nick

  • efialttes Profile Picture
    14,756 on 10 Mar 2020 at 09:39:19
    Re: Flow to move a library folder up 1 level based on a list column status
    Hi!
    I think you gave the answer in your first post
    "when a new project is added to a list there is a project number generated and a corresponding folder created with that number in a library"

    Try to build the target folder name by using that number... since the number is stored in a column of your SP list, right?
    Hope this helps
  • Nick_k Profile Picture
    43 on 10 Mar 2020 at 08:32:12
    Re: Flow to move a library folder up 1 level based on a list column status

    Thank you both for your replies. How do I ensure the flow is going to move the correct folder? I'm unsure what action should go in the yes condition? Underneath the condition I have a move folder action, is this correct? Please see screen shots below.

     

    archive flow.JPGarchive flow 2.JPG

     

    Regards

    Nick

  • v-litu-msft Profile Picture
    on 09 Mar 2020 at 08:55:12
    Re: Flow to move a library folder up 1 level based on a list column status

    Hi @Nick_k,

     

    @efialttes's advice is very accurate. You can build your Flow by following the links he provides. If you have problem when you building Flow, please feel free and I could give you some advice.

    And there is an item be modified and its value of Status is Complete, move the file, how do you store file information into the item? Filename or folder path?

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • Verified answer
    efialttes Profile Picture
    14,756 on 09 Mar 2020 at 08:02:25
    Re: Flow to move a library folder up 1 level based on a list column status

    Hi!

    The first step is then to set up a flow when an item is updated, and evaluate Status column value. My suggestion is to have a look to this recent thread

    https://powerusers.microsoft.com/t5/Building-Flows/Sharepoint-flow-creation/m-p/491970#M60876

     

    So you need a trigger, you need a condition to evaluate, and...

     

    In oder to move the file, I would recommend you to explore Move file action block from Sharepoint connector. If it match your requirements, I would add it inside your condition true branch.

     

    Please note if your flow need to update the item, you can enter a neverending execution loop.

    Please also note if the Status value is kept as is, and the item is updated again in the future, your flow will be executed again and condition will also be true.

    Hope this helps

  • Nick_k Profile Picture
    43 on 09 Mar 2020 at 07:49:56
    Re: Flow to move a library folder up 1 level based on a list column status

    column properties.JPG

    Hi - the status column is setup as a choice. I think the list entry is referenced in the library folder by the title column and the folder number column

  • efialttes Profile Picture
    14,756 on 09 Mar 2020 at 06:27:41
    Re: Flow to move a library folder up 1 level based on a list column status
    Hi!
    Can you share a screenshot of your SP list column definition? So is 'status' column of type Choice, how is reference to the corresponding library document stored, etc?
    Thanx!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 840 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 712 Super User 2025 Season 2

#3
stampcoin Profile Picture

stampcoin 373 Super User 2025 Season 2

Last 30 days Overall leaderboard
Loading started