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

View solution in original post

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,603)