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

[Apri42l]

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

[v-LilyW-msft]

Hi @Apri42l 

Could you please share a bit more about your scenario?

What is your trigger filter array?

Best Regards

[Apri42l]

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

[v-LilyW-msft · Accepted solution]

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

Hope the content above may help you.

Best Regards

[Apri42l]

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