Answered

OData filter query help

(0) Share

Report

Posted on by andrewpmize

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!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Srini007 3,327 Super User 2025 Season 2 on at

Like (0)

Report

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

https://powerusers.microsoft.com/t5/Building-Flows/OData-Filter-witha-blank-space-un-column-Name-ExcelOnline-Block/td-p/1606020

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

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (1)

Report

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.

Was this reply helpful? Yes No
andrewpmize 6 on at

Like (0)

Report

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.

Was this reply helpful? Yes No