Unrecognized character OData Query

(0) Share

Report

Posted on by Sharaz

Hello

I'm trying to filter a query using the Sql connector, without the filter the query is ok:

But when i try to filter the query with the remarked field this happens:

With the following filter and executing the flow this happens:

I think it's due to the symbol '-' but what can i do so it lets me allow this carhacter or any other way to filter the field "Sell-to_x0020_Contact_x0020_No_"

Thank you.

Categories:

Using connectors

I have the same question (0)

All responses (4)

Answers (1)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Sharaz

Currently this looks like a limitation for ODATA Queries in Flow that the column names (be it sharepoint/ excel too) cannot have any special characters.

Hope this helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Sharaz ,

Could you share more details about the Flow configuration or the intent to create this Flow?

If you can't use this field to filter rows in Filter Query, please try to use Condition to filter rows directly.

Like:

Or you could use Filter array.

Like:

Hope it helps.

Best Regards,

Was this reply helpful? Yes No
Sharaz 31 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-bacao-msft I can do that but consider that in that table there might be 1000+ entries and increasing, and it effects a lot in efficiency, unfornately there is no other field in the table that i can use to filter within the select.

Thank you.

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Sharaz ,

It seems that you have misunderstood what I mean, I just want you to use the field you mentioned earlier to filter rows.

But since it seems to be limited in Filter Query, I recommend that you use Condition or Filter array to filter rows.

I think the execution efficiency of the Filter array is acceptable.

In addition, if you use Condition, you could set Apply to each to improve execution efficiency.

Increase the degree of parallelism to improve execution efficiency.

Image reference:

Best Regards,

Was this reply helpful? Yes No