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 : yjwOWt4tq2YJWMvSgGINAB
Power Automate - Building Flows
Answered

Unable to Move SharePoint File when Property is Changed

Like (0) ShareShare
ReportReport
Posted on 20 Mar 2023 19:00:11 by 15

I've been trying for some time to move a file from one SharePoint library to another when a document property is changed. I've tried everything I've run across here and on other sites, but nothing has worked so far. The closest I've got so far is to have the flow go through the first two steps, "(When a file is created or modified (properties only)" and "Get file properties", but when it comes to the Condition, the flow doesn't appear to evaluate the variable correctly. It always evaluates the variable as false, never true, despite the fact when I look at the report after I test the "Get file properties" section shows the variable is set to "Published", which should trigger the move. Here's a screen shot of the flow I've come up with:

SP Move File.png

Does anyone have ideas I can try?

I have the same question (0)
  • Verified answer
    KRDL Profile Picture
    15 on 27 Mar 2023 at 15:42:55
    Re: Unable to Move SharePoint File when Property is Changed

    I thought I'd already responded to this thread with how I worked this out. Well, I guess I didn't. Here's how then...

     

    Per my last response above, I'd gotten stuck when the following error message popped up:

     

    Missing or mismatched field definition on the destination list for source field 'iStoreImpacts0' type 'Note'. Source site template id 'SitePagePublishing', target site template id 'SitePagePublishing'. Total blocked root objects in this operation is [1].

     

    One of our local SharePoint people said I should create a new Content Type and then assign the new Content Type and it's associated columns to both libraries so they are identical. I did that and the flow is now working as it should. When anyone changes the SB Status to the appropriate setting, the file is moved to another library.

     

    So, Christian, you were on the right track to point me at column Content Type discrepancies. I had been getting the column types to match between libraries, but creating a new Content Type means it's now impossible for them not to match, since they're the same Content Type.

  • KRDL Profile Picture
    15 on 21 Mar 2023 at 01:47:30
    Re: Unable to Move SharePoint File when Property is Changed

    Hey Christian,

     

    Thanks for your response! Yes, you picked up on one of the issues I've been having. I am now using "SB Status Value" instead of "SB Status". I've also changed the "Get properties" piece to "Get file metadata" and am now using "Identifier" instead of ID. It has moved me to the next step, as the error report is now showing it's passing "TRUE" to the condition.

     

    However, I'm now having another issue. Here's the error message I'm getting:

     

    Missing or mismatched field definition on the destination list for source field 'iStoreImpacts0' type 'Note'. Source site template id 'SitePagePublishing', target site template id 'SitePagePublishing'. Total blocked root objects in this operation is [1].

     

    I've checked the source and destination libraries and both fields are the same. They're both multi-line text with the display name "iStore Impacts". I do have a custom form I created and the form name was "iStoreImpacts0". I changed the form name to "iStoreImpacts" but am still getting the same error. 

  • ChristianAbata Profile Picture
    8,949 Most Valuable Professional on 21 Mar 2023 at 00:01:46
    Re: Unable to Move SharePoint File when Property is Changed

    hi @KRDL  when u are working with conditions if you use equals to te values needs to be the same and also same data type. That means Number Equals to number, Text equals to Text. 
    So if the values are not equals the condition will be false.

     

    If your value in Sharepoint is comming from a Choice you have to select the propertie ended with the word VALUE

     

    Example: Sharepoint Name Column is Status
    In power Automate you will see Properties: Status and StatusValue

    The second one content the data to compare

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 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading started