Wrong files being moved to another library

[Jukka]

Hi,

I have a flow that is supposed to move a file from a document library to another one after two columns match certain criteria. There are plenty of other columns too in the library and its views. 

It works almost like a charm, but there is this problem that if I edit in grid at the library two or more files at the same time, and at least one of the files meets the criteria that is set the flow to move documents, also other files that are edited are being moved. This is even when they don't have the desired values in columns. 

Example: - Columns A & B should have values A & B -> move a file

               - while editing files, one file has values A & B, but second file that is being edited at the same time has column C being edited and is also moved to another document library, even Column C should have nothing to do with the flow.

Here are snips of my flow atm:

[v-jefferni · Accepted solution]

Hi @Jukka ,

I made a test from in my library but the flow works fine, the two items both have triggered the flow but only the only meet the condition ran to the true branch of the condition.

The question is: Why did you put the "get files" action in the flow? Could it be more logical that moving files based on the file id that come from the trigger?

For your current flow, every time a file property is modified, it will loop all the library to get the files that meet the condition and check if need to be moved. If you modify properties of two files in the grid view, the flow will be triggered twice so it will loop twice as well.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[Jukka]

Hi @v-jefferni,

I have no more 100% clear answer to why I had that "get files" action. Perhaps I got the idea from some post that I had read, I have been googling a lot to get this work. 

You help really seems to have been vital with this case. It seems that my flow also works now like it should. No extra documents are being moved anymore - only those who match the determined criteria. So, a big "thank you" to you! Funny, that the correct way was that simple to build. I had lost my way.

Best,

Jukka