I am experiencing an unexpected behavior with the Excel "List rows present in a table" action in Power Automate.
In my flow, I set a Filter Query:
Status eq 'Approver 1'
The flow is scheduled to run every 10 minutes to check whether there are any rows in the Excel table with the status "Approver 1".
However, recently I noticed that sometimes the filter query is not applied, and the action returns all rows from the Excel table, even when the Status value does not match the filter.
For example, rows with the following statuses are still returned:
These values clearly do not match the filter query Status eq 'Approver 1'.
Additional observations:
- This issue happens intermittently (not every run).
- It is affecting multiple flows, not just one.
- The flows are reading from Excel files stored in SharePoint/OneDrive.
- The Excel data is formatted as a Table.
Questions:
- Has anyone experienced a similar issue where the Filter Query in "List rows present in a table" is ignored?
- Is this a known limitation or bug with the Excel connector?
- Are there recommended best practices to make the filtering more reliable?
- What can I do to prevent this issue in the future?
Any suggestions or references would be greatly appreciated.
Thank you.
