You’re offline. This is a read only version of the page.
I need to filter a table by 2 columns and copy the visible rows over to another table. I keep getting an OData filter query syntax error. I can't figure out why.
Here's my flow:
Headers in the first table:
Odata filter query (recommended by Copilot)
the error:
"Syntax error at position 13 in 'STATUS DETAIL eq 'Completed' and Confirmation Date eq null'.\r\n inner exception: Syntax error at position 13 in 'STATUS DETAIL eq 'Completed' and Confirmation Date eq null'.\r\nclientRequestId: df01405a-dea2-4a0c-a14e-cca1a1521c1b"
Any help would be greatly appreciated!
Thanks. I've resigned to the fact that filter query just won't work with excel tables with spaces in the column names. I was able to get the filter array data operation to work, but it was tricky.
Hi @andrewpmize,
You have referred to a wrong column name, you should find out the real inner column name of 'STATUS DETAIL'.
Just check the outputs of the list rows presents into a table action, find the 'STATUS DETAIL' column name in that array outputs.
Or I suggest you remove this filter query and use a condition instead, in your condition tab, select the 'STATUS DETAIL' dynamic content from the list rows presents into a table action.
Hi @andrewpmize
The problem is that with the column name has the spaces, either try to remove those spaces and try or you need to retrive all the cases and then filter those later
Check the similar issue
If you find this reply helpful, please consider giving it a LIKE AND
If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION
Cheers,
Srini
#1
Pstork1
20
Most Valuable Professional
#2
rpersad
16
#3
David_MA
10
Super User 2025 Season 1
Share
Report
All responses (
Answers (