Get files (properties only) more than 100 files

(0) Share

Report

Posted on by Megaoctane

I am trying to build a flow to add metadata to each file, folder and anything within any subfolder. What i need is file ID and folder path of the file. the get files properties only returns an error because the sharepoint folder contains almost 3000 files...

How can i manage to get all file ID's, folderpaths in an array?

The Pagination doesn't work for get files.

Also the TopCount doesn't work.

I have the same question (0)

All responses (4)

Answers (1)

StretchFredrik 3,306 Super User 2025 Season 2 on at

Like (0)

Report

Re: Get files (properties only) more than 100 files

In the settings of the step you should be able to set it to 5000 for example. See image below, its in Swedish but maybe you understand where im at. 🙂

Was this reply helpful? Yes No
Megaoctane 41 on at

Like (0)

Report

Re: Get files (properties only) more than 100 files

I tried this and it returns the error:
"The attempted operation is prohibited because it exceeds the list view threshold"

Was this reply helpful? Yes No
Verified answer

Megaoctane 41 on at

Like (0)

Report

Re: Get files (properties only) more than 100 files

I had to insert something in the Odata filter part. So i added a filter wich still picks up almost every file, and now it works.

Was this reply helpful? Yes No
guilefox 4 on at

Like (0)

Report

Re: Get files (properties only) more than 100 files

What did you insert into the ODATA filter part?!

Was this reply helpful? Yes No