List files in folder and limit top 20 for select all

[42RIO]

Hi,
i have problem with function "List files in folder". When i use this function and select all files in OneDrive, result is only 20 items.

In nextlink is parametr ..?top=20...

When i sett "Pagination", result is Error 400
{
"status": 400,
"message": "Header 'x-ms-apim-tokens' not found.",
"source": "api.connectorp.svc.ms"
}

Is possible selected all files?

[v-yuazh-msft · Accepted solution]

Hi @42RIO,

I have made a test on my side and the issue is confirmed on my side.

I afraid that we could only list 20 items from the "List files in folder" action and there is no any way to list more than 20 items from the "List files in folder" action in microsoft flow currently.

So there is no way to achieve your needs in Microsoft Flow currently.

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,

Alice

[fatih_dur]

This untested idea came after hitting the same limitation (BTW, I upvoted the "idea"):

- Take the first 20 and move them to iteratively created sub-folders in the same directory (keep some sort of index) in One Drive and save the file names/references in an array

- Do this until the main folder has less than 20 files (Do Until might be an option as in https://powerusers.microsoft.com/t5/Building-Flows/Repeat-previous-steps/td-p/86537) 

- Re-place the files out of the sub-folders.

If the requirement is to extract share-able links, then the files should stay in the sub-folders.

It is obviously cumbersome and inefficient but might be a resolution!

[juresti]

I also noticed this limitation where I have a flow that I want to use to delete files older than a month.

I ended up using "Find files in folder" instead which allows up to 100 files.

100 worked for me since I won't ever have over 100 files in that folder.

[Hyperion]

I also ran into this issue and confirmed the default limit is 20 but if you go into the settings you can turn on the Pagination feature and increase the limit to your needs.  I tested with 100 and it worked.

Details on how to change the setting can be found below

https://natechamberlain.com/2017/11/11/how-to-change-microsoft-flows-default-limit-of-100-items-for-...