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.
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,
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.
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,
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!