Unrecognized character OData Query

Like (0) Share

Report

Posted on 7 Aug 2019 11:01:22 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.

All responses (4)

Answers (1)

v-bacao-msft on 08 Aug 2019 at 06:43:36

Like (1)

Report

Re: Unrecognized character OData Query

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,
Sharaz 31 on 08 Aug 2019 at 06:26:31

Like (0)

Report

Re: Unrecognized character OData Query

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.
Verified answer

v-bacao-msft on 08 Aug 2019 at 00:42:13

Like (0)

Report

Re: Unrecognized character OData Query

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,
yashag2255 24,635 Super User 2024 Season 1 on 07 Aug 2019 at 13:19:53

Like (0)

Report

Re: Unrecognized character OData Query

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!