Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - AI Builder
Answered

Document Processing - ai builder

(0) ShareShare
ReportReport
Posted on by 4
Hello - great video on this topic. I have created a model using AI builder that passes .pdf information into an excel table. this appears to working ok when I trigger it by copying a new pdf file into a SP list. However if I copy multiple .pdf's at once it just copies one data set and not all of them - could anyone advise what might cause this and a suggestion for fixing it? -
 
 
 
Categories:
  • SS-20031007-0 Profile Picture
    4 on at
    Document Processing - ai builder
    Thank you Sandeep - much appreciated I will take a look at implementing your suggestions - I'm new to this so going to take me a while i think..
  • Verified answer
    sandeepstw Profile Picture
    297 Super User 2025 Season 1 on at
    Document Processing - ai builder
    When you copy many PDF files at once into the SharePoint library, your AI Builder model only processes one file because the flow may not handle multiple triggers properly or doesn't loop through each file.
    1. Change your flow trigger from "When a file is created" to a scheduled flow that runs every few minutes
    2. In the flow, use Get files (properties only) action to collect all PDF files from SharePoint
    3. Add a filter to select only unprocessed files
    4. Use Apply to each loop to process each file one by one
    5. Inside the loop, use your AI Builder model to extract data and save it into Excel
    6. After each file is processed, mark it as processed (for example, update metadata or move to a different folder)
    7. To avoid conflicts, open trigger settings and turn off Concurrency Control
    8. Use Scope actions and add error logging if needed
    9. Example filter to get only PDF files:
        Name ends with '.pdf'
    10. Use the SharePoint column like "Processed = No" and update to "Yes" after completion.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,518 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,744 Most Valuable Professional

Leaderboard