Sharepoint move file flow error

[ajssbp]

Hello,

I'm trying to make a flow that will run and move all files older than the specified date range to a subfolder called Archive.  Identifying the files works fine, but when the Flow tries to move the file(s) I get a Bad Request Error:

Here's the flow:

Any suggestions would be much appreciated.  Thanks.

[v-yujincui-msft · Accepted solution]

Hi @ajssbp ,

You could try using the 'Identifier' as parameter in the Move File Action.

I have made a test and it seems that works fine on my side.

Result Screenshot:

Best Regards,

Charlie Choi

[ajssbp]

Hi @v-yujincui-msft Charlie

I think I may have two problems going on - Changing from ID to Identifier fixed some of the failures, but I'm still having some.  Is there a character limit on the file path/file name combined?  Some of the file names are long and combined with the path may exceed 255 characters.  When I test the flow it isn't identifying all the files (for example, it'll run against 100 files when there are 160 in the folder).  I can't figure out why I keep getting the BadRequest failure on some files.  Thanks.

[v-yujincui-msft]

Hi @ajssbp ,

Maybe you could try the following steps:

1. Click the ellipses on the “Get files (properties only)” Action.

2. Settings.

3. Pagination.

4. Click Done.

Here is an excellent article on how to deal with the collection size limits (e.g. SharePoint page size, Top count, Threshold):

https://alextofan.com/2019/08/22/how-to-get-more-than-5000-item-from-sharepoint-online-in-flow/ 

Best Regards,

Charlie Choi

[ajssbp]

Combination of changing from ID to Identifier and changing the pagination seems to have worked.  Thanks!