Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - AI Builder
Answered

100 records limitation

(1) ShareShare
ReportReport
Posted on by 14
I built a workflow to capture data from pdf file by AI builder. the workflow get files from sharepoint folder, and input the captured data to a sharepoint list.
 
The problem is there are thousands of files under sharepoint folder, but only created 100 items in list after running the workflow. my expectation is one item for one pdf file, so thousands of files should create thousands of items in list. 
 
So who do know how to fix this issue? 
 
 
 
  
Categories:
  • Verified answer
    RobElliott Profile Picture
    10,151 Super User 2025 Season 1 on at
    100 records limitation
    @eastman_silver by default the get files and get items actions brings back a maximum of 100 items. You need to go to Settings for the action (the 3 dots at the top right of the action) turn on pagination and set the threshold to more than the number of files in your library.
     
    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, Microsoft Power Platform, WSP Global (and classic 1967 Morris Traveller driver)

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >