Filter Query Formatting Issue

(0) Share

Report

Posted on by CU28051919-0

Im currently working on an automation project and have a part where I take a name from an excel file and the number associated with its row. I am using the list row present action with the filter query option selected. Heres my code for the query
EMPLOYEE NAME eq '@{outputs('Compose_Officer1')}'
I confirmed this is the name of the table but when running it, the flow always fails due to incorrect syntax. I tried wrapping it in quotations but it says the operation is unsupported.

Heres the error

Flow run failed. Action 'Contact_1' failed: Syntax error at position 13 in 'EMPLOYEE NAME eq 'JULIO SINAWI''. inner exception: Syntax error at position 13 in 'EMPLOYEE NAME eq 'JULIO SINAWI''. clientRequestId: aedbc998-245f-4537-85bf-b31edaf7ed70

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@CU28051919-0,

Since the column name contains a space, try wrapping it in single quotes:

'EMPLOYEE NAME' eq @{outputs('Compose_Officer1')}

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.

Was this reply helpful? Yes No
CU28051919-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

I mentioned this when I wrote in the post that I wrapped the name in quotations. It gives me a new error

Flow run failed. Action 'Contact_1' failed: Invalid filter clause: unsupported operation. Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported. clientRequestId: 12829e67-d085-4480-acfa-2fd13cab6af5 serviceRequestId: 444c2dbb-67d0-4f74-aecb-3f6ec7c15601;b1122082-bdd8-494f-aa86-29d769aabc01;65d6f5a4-2817-4a6a-93bf-58fb65263c87

Was this reply helpful? Yes No
CU28051919-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

I ended up solving the issue, I couldn't get it fixed with the spacing in the column name, so I just renamed it EMPLOYEE_NAME and that seemed to do the trick

EMPLOYEE_NAME eq '@{outputs('Officer_6')}'

Was this reply helpful? Yes No