Using the Filter or the Select Query can be limited on the Excel connector. The issues come up when there is a space in the column you are trying to Query, which results in a Bad Request error.
A relatively easy fix would be to change the column name to have no spaces. Sometimes this is not viable or possible due to many systems talking to each other. Or perhaps a third party is supplying the Excel doc.
The fix in my example shows how to use the Select, and Filter array actions in Power Automate.
Select is used to select certain columns to output.
Filter Array is used to filter on certain conditions and values.
Step 1 – Add the Select action under the Excel List rows present in table action
Step 2 – Add Filter array action under the Excel List rows present in table action
Some Actions have a limitation on the Odata filter and Select queries. Some examples include:
- When filtering on Names with special characters
- James O’ Henry
- Columns with spaces
Thank you for reading.