Power Platform Community Forum Thread Details

I'm trying to move files that are uploaded into our SharePoint folder by another department into the correct location for these files. as the department isn't fully aware of our structure it makes sense for them to upload the files into the same folder, regardless of where they need to go.. the files need to go into one of two folders which change slightly each month. I therefore, set up variables and a create folder step to ensure all the dynamic values and destinations are set up correctly.

However my flow is currently failing on the move file step with the error message Failed to verify the existence of source object. what makes no sense to me is the source file in the move file step is x-ms-file-id dynamic content taken from the trigger when a file is created in my dump folder from the for the other department. As I am using the item created to trigger the flow I can't work out why the flow is failing to find it.

Is there any reason as to why this would be causing an error. I could understand if I had an error or the moving location as I have a create folder step in the process which is where the bulk of the files should end up. I have put a 30 second delay after this step before I get to move step to allow for SP to catch up so this shouldn't be an issue.

I have put screen shots of the relevant stage in the flow for this query as well as the formulas for the variables or dynamic content where relevant below.

The identifier item of the destination is from this create folder stage

The folder path variable is a concatenation of our folder structure, the year, and the month from a couple other calculations there formulas are below.

Month formula

if (less(add(int(formatDateTime(utcNow(), 'MM' )),-5),1),add(int(formatDateTime(utcNow(), 'MM' )),7),add(int(formatDateTime(utcNow(), 'MM' )),-5))

Financial year formula

if(greater(int(formatDateTime(utcNow(),'MM')),4),concat(formatDateTime(utcNow(),'yyyy'),'-',add(int(formatDateTime(utcNow(),'yy')),1)),concat(sub(int(formatDateTime(utcNow(),'yyyy')),1),'-',formatDateTime(utcNow(),'yy')))

Categories:

Building flows