Unanswered

PA Cloud: List rows present in a table only returns rows filtered on the source Excel file?

(1) Share

Report

Posted on by ncd

Hi there,

A Power Automate Cloud using the "List rows present in a table" action was returning far fewer rows than it sould, despite having a very high pagination value set up, and I have noticed it seems to be that if a filter is applied in the source Excel file in Sharepoint, the action only returns filtered ("visible") rows.

Copilot claims it is a feature, but I really do not think that it is working as expected (are users expected to manually remove all filters from the source file everytime an automated flow is triggered?). Particularly inconvenient considering it is a shared file to which several people might be applying different filters at the same time.

Is there a way to conveniently work around this? We also have a limited Office 365 license, so Office scripts or HTTP actions are not an option.

Cheers.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (0)

Report

Hi

Do you still need help?

Was this reply helpful? Yes No
KimBim 157 on at

Like (0)

Report

I am experiencing the same behaviour in an Excel automation.

Even if a person removes all filters before the automation runs, only a part of the complete Excel table is still returned.

I wonder if Power Automate also takes into account the filters that individual users set for themselves?

This type of filtering in Power Automate is very unfavourable for us because we only ever get a very small part of the actual rows in the Excel list.

I would be very grateful for a tip on how to fix this. Below is a screenshot of my ‘List Rows Present in Table’ action.

Was this reply helpful? Yes No