cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
42RIO Advocate I
Advocate I

List files in folder and limit top 20 for select all

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?

 

Screenshot 2018-11-04 at 23.25.19.png

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: List files in folder and limit top 20 for select all

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

View solution in original post

4 REPLIES 4
Community Support
Community Support

Re: List files in folder and limit top 20 for select all

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

View solution in original post

fatih_dur
Frequent Visitor

Re: List files in folder and limit top 20 for select all

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 Resolver II
Resolver II

Re: List files in folder and limit top 20 for select all

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
New Member

Re: List files in folder and limit top 20 for select all

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-...

 

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (7,934)