Check the header
Excel Online Filter Query, Order By and Select Query parameters support only alphanumeric column names. A suggestion here is a rename plan—not a claim that your workbook has already changed.
Free Power Automate utility
Excel Online Filter Query Readiness Checker
Check a Power Automate Excel Online List rows present in a table filter before testing the flow. Diagnose headers and operators, then copy a connector-safe query or a documented Filter array fallback.
Local input analysis · no login · no workbook upload · no tenant connection
02
Readiness result
Generated locally from documented rules.
READY FOR FILTER QUERY
Header compatibility
- CustomerIDCompatible
- StatusCompatible
- Date SentHeader contains whitespace. Header contains punctuation or other non-alphanumeric characters.
- Order TotalHeader contains whitespace. Header contains punctuation or other non-alphanumeric characters.
Corrected Filter Query
CustomerID eq 'ABC-123'Filter array fallback
@equals(item()?['CustomerID'], 'ABC-123')Explanation
The target header and requested operation fit the documented Excel Online connector limits. Test the generated query against representative workbook data.
Warnings
- One or more additional table headers are empty, duplicated, or non-alphanumeric.
Try a known case
Interactive examples
Know which filtering layer you are using
Check the operation
For List rows, Microsoft documents eq, ne, contains, startswith and endswith. This tool never presents greater-than or less-than as supported direct filters.
Fall back deliberately
Filter array works after rows are retrieved. It supports workflow expressions such as equals(), empty(), greater() and less(), but text comparisons are case-sensitive.
Source of truth
Microsoft documentation
The checker paraphrases these current rules and avoids undocumented connector behavior.
- Excel Online (Business) connector ↗
- Power Automate expression cookbook ↗
- Expressions in conditions ↗
- Filter array and data operations ↗
Independent utility. Not affiliated with or endorsed by Microsoft. Always test generated output with representative workbook data before production use.
Privacy
Your worksheet content stays local
Headers, values, queries, generated expressions and diagnostic reports stay in your browser. We may record coarse product interactions such as selecting an example, copying an output or downloading a report, plus ordinary page analytics. Product events contain no entered content or user identity.