Unanswered

Move file between Sharepoint folders if older than 30 days AND filename contains

(0) Share

Report

Posted on by DamoB

Hi,

I was pleased to create a flow which places the attachment from a weekly email I receive into the 'Files' area of a Teams channel (so, a SharePoint site).

However once the file has been Files for 30 days I want to move it to an 'Archive' folder in the same SharePoint site.
To avoid inadvertently moving any other files that people drop into 'Files' I want to only move files where the file name contains the specific string 'XYZ'. The files are always in a consistent format and file name always contains this string.

I have tried multiple methods of achieving this using some methods described here within the forums and others from Jon Levesque's YouTube channel - without success.
Recurrence steps are fine, 'Get Files (Properties Only) are fine, all the failures seem to be in the 'Apply to each' step.

Does anyone have any tips please?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

fchopo 8,003 Moderator on at

Like (0)

Report

Re: Move file between Sharepoint folders if older than 30 days AND filename contains

Hello @DamoB
Could you share your flow and show which are the errors you are receiving?

Was this reply helpful? Yes No
DamoB on at

Like (0)

Report

Re: Move file between Sharepoint folders if older than 30 days AND filename contains

Hi,
Thanks for responding. I've attached photos of one of my attempts.
The expression in the condition is:
lessOrEquals(items('Apply_to_each')?['Modified'], addDays(utcNow(), -30))
I think this attempt (there have been many!) i was just trying to get the 30 days thing working so no attempt here to add the 'file name must contain 'XYZ'' part.

Was this reply helpful? Yes No
DamoB on at

Like (0)

Report

Re: Move file between Sharepoint folders if older than 30 days AND filename contains

And the error message:

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report

Re: Move file between Sharepoint folders if older than 30 days AND filename contains

Hello @DamoB
As I can see by your screen captures, the error is related to the file identifier (it says Shared Documents/General), where this field should be a number (id field value of the sharepoint document). Have a look at this:

Hope it helps!
Ferran

Was this reply helpful? Yes No
DamoB on at

Like (0)

Report

Re: Move file between Sharepoint folders if older than 30 days AND filename contains

@fchopo Thank you very much.
I switched out 'Identifier' for 'ID' unfortunately I get a similar error at the same place.
Should the File Identifier field contain an expression that will find the 'XYZ' part of the Title perhaps?
Or 'Modified'? Or has the modified element been managed in earlier Condition?
I'm confused.

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (1)

Report

Re: Move file between Sharepoint folders if older than 30 days AND filename contains

Hello @DamoB
I have created this flow and it is working:

So you were right on using "Identifier" field value when using "Get File content" action. I mean, your flow should work! Furthermore, I realized that if there are any folders inside the document library, the flow does not work, and then you should specify the folder in the "Get files (properties only)" action:
Hope it helps!
Ferran

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (1)

Report

Re: Move file between Sharepoint folders if older than 30 days AND filename contains

Hi @DamoB ,

You should add one more condition to exclude folders.

Please refer to the following method to achieve your requirement.

Besides, it seems that you move the file in the same library, maybe it will cause some error.

Please take a try first and feel free to let us know if you have any questions.

Best Regards,

Was this reply helpful? Yes No
DamoB on at

Like (0)

Report

Re: Move file between Sharepoint folders if older than 30 days AND filename contains

This was really helpful, I hadn't realised that a folder in library would cause a problem.
I have now specified that it should just look for files within General and ignore folders.
With this knowledge and the help from @v-bacao-msft on adding the 'XYZ' string the flow now runs!

Thank you @fchopo and @v-bacao-msft .

Was this reply helpful? Yes No