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 / Create and modified Sh...
Power Automate
Answered

Create and modified SharePoint list for multiple excel file in one flow

(0) ShareShare
ReportReport
Posted on by 7

I have a flow where this flow is connected to 1 share point list to more than one excel but when I upload or add a second row file the trigger filter array can't read it

Please help maybe someone can help with this problem

Categories:
I have the same question (0)
  • v-LilyW-msft Profile Picture
    on at

    Hi @Apri42l 

    Could you please share a bit more about your scenario?

    What is your trigger filter array?

    Best Regards

  • Apri42l Profile Picture
    7 on at

    1.png2.jpg3.jpg4.jpg5.jpg

     

    this is capture my flow, the problem is my flow in the end condition always read "true" although it should be "false"

    but my another flow is work correctly. Is that a limit about power automate to access row in the business excel, may be 500 rows or 1000 rows etc

     

    or may be you have some flow that you can share it

     

    i have a excel file that is master (all data from share point export to it)

    i have 5 excel files that export based on email created

     

    i ma sorry my english is not good

    thank you

  • Verified answer
    v-LilyW-msft Profile Picture
    on at

    Hi @Apri42l 

    By default Microsoft Power Automate only return the first 256 rows of the table when use "List rows present in a table" action, however you can increase this limit in the following way.

    You can get more rows returned by setting a higher value for the pagination settings.

    Go to "List rows present in table" action
    1.Select the options elipses ("...")
    2.Select 'Settings'
    3.Enable Pagination
    4.Set an appropriate row limit

    vLilyWmsft_1-1645692278280.png

    vLilyWmsft_2-1645692320795.png

    Hope the content above may help you.

    Best Regards

  • Apri42l Profile Picture
    7 on at

    it's work, can i increase that more than 5000, because when i fill it with 100.000, i got warning from power automate

     

    thank you very much

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 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard