web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get files (properties ...
Power Automate
Answered

Get files (properties only) more than 100 files

(0) ShareShare
ReportReport
Posted on by 41

hi

 

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.

 

Categories:
I have the same question (0)
  • StretchFredrik Profile Picture
    3,395 Super User 2025 Season 2 on at

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

     

    StretchFredrik_0-1655465902489.png

     

  • Megaoctane Profile Picture
    41 on at

    I tried this and it returns the error:

    "The attempted operation is prohibited because it exceeds the list view threshold"

  • Verified answer
    Megaoctane Profile Picture
    41 on at

    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.

  • guilefox Profile Picture
    4 on at

    What did you insert into the ODATA filter part?!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard