Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Moving document to an archive library when status is changed

(0) ShareShare
ReportReport
Posted on by 84

I've got multiple libaries that I want to set up an automatic workflow on.  When the status changes from current to archive, I want the document to be moved to the archive library.  These are custom list in the on-line environment.  Is this possible?

  • GUSers Profile Picture
    20 on at
    Re: Moving document to an archive library when status is changed

    I'm in a similar boat trying to move files based on a Yes/No field being toggle to Yes. However, I've tried what you've got screen shots for above with the Condition, but the condition is evaluating as false when I change that value on a file. I've also been trying the Trigger Conditions on the trigger action so that the flow only runs when that specific trigger is met and not on all modifications to files checking for the Condition Action being met.

  • Jsharkey Profile Picture
    75 on at
    Re: Moving document to an archive library when status is changed

    Can you explain how you resolved this? I am implementing something similar. I am currently facing an issue with the archive expecting a column of type workflow status, I need to move the file and not copy it because i need to maintain the version history of the document. 

    How did you resolve this?

  • Christy_Roach Profile Picture
    84 on at
    Re: Moving document to an archive library when status is changed

    Please disregard.  I finally got this figured out.

  • Christy_Roach Profile Picture
    84 on at
    Re: Moving document to an archive library when status is changed

    I have been able to use this information to set up the flow successfully to move documents from 4 of my 5 libraries to the archive library when the status is changed to archive.  The 5th library is giving me a fit and I'm wondering if anyone can provide me with direction? I have checked several times to make sure that the columns are exactly the same and in some cases have replaced the columns with the correct/exact information so that they do match.  That is what I've done on the other 4 but on the 5th one, it's still not working.  Here is the error message that I'm getting:  

     

    Missing or mismatched field definition on the destination list for source field 'Page' type 'Text'. Source site template id 'SitePagePublishing', target site template id 'SitePagePublishing'. Total blocked root objects in this operation is [1].
    clientRequestId: 742f5e54-019a-487f-9d93-d3831eadc781
    serviceRequestId: 9613d89e-f078-8000-8f19-3f7e2ed6732c

     

    I've attached my images of the flow I've set up,  It's working on 4 other libraries so I don't think the issue is the flow but somehow the underlying libraries. 

     

    Thank you for any help you can give me.Flow1.jpgFlow2.jpg

  • Christy_Roach Profile Picture
    84 on at
    Re: Moving document to an archive library when status is changed

    I have been able to use this information to set up the flow successfully to move documents from 4 of my 5 libraries to the archive library when the status is changed to archive.  The 5th library is giving me a fit and I'm wondering if anyone can provide me with direction? I have checked several times to make sure that the columns are exactly the same and in some cases have replaced the columns with the correct/exact information so that they do match.  That is what I've done on the other 4 but on the 5th one, it's still not working.  Here is the error message that I'm getting:  

     

    Missing or mismatched field definition on the destination list for source field 'Page' type 'Text'. Source site template id 'SitePagePublishing', target site template id 'SitePagePublishing'. Total blocked root objects in this operation is [1].
    clientRequestId: 742f5e54-019a-487f-9d93-d3831eadc781
    serviceRequestId: 9613d89e-f078-8000-8f19-3f7e2ed6732c

     

    I've attached my images of the flow I've set up,  It's working on 4 other libraries so I don't think the issue is the flow but somehow the underlying libraries. 

     

    Thank you for any help you can give me.

  • Verified answer
    v-yamao-msft Profile Picture
    on at
    Re: Moving document to an archive library when status is changed

    Hi @Christy_Roach ,

     

    Do you want to move documents from one library to another library when the status changes to specific value?

     

    I assume that the Status is a custom Choice column in the library.

     

    I have made the following flow for your reference.

     

    Before starting the flow, I created two libraries with the same columns.

     

    Then configure the flow with the trigger When a file is created or modified (properties only), add a Condition to check if the Status value is equal to Archive.

     

    Under if yes branch, add an action Move file to move file.

    Note: if the two libraries don’t have the same columns, it will return an error message “Missing or mismatched field definition on the destination list”.

     

    Images for your reference.

    1.PNG2.PNG

     

    Best regards,

    Mabel

     

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,651 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow