cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
v-yuazh-msft
Community Support
Community Support

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
v-yuazh-msft
Community Support
Community Support

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
Frequent Visitor

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
Continued Contributor
Continued Contributor

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

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (1,705)