cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
42RIO
Level: Power Up

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 Team
Community Support Team

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

3 REPLIES 3
Community Support Team
Community Support Team

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

fatih_dur
Level: Powered On

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
Level 8

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.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 385 members 5,049 guests
Please welcome our newest community members: