Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Unrecognized character OData Query

(0) ShareShare
ReportReport
Posted on by 31

Hello

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

 

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

image.png

With the following filter and executing the flow this happens:

 

image.png

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.

  • v-bacao-msft Profile Picture
    v-bacao-msft on at
    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:

    75.PNG76.PNG

     

    Best Regards,

  • Sharaz Profile Picture
    Sharaz 31 on at
    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 Profile Picture
    v-bacao-msft on at
    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:

    62.PNG

    Or you could use Filter array.

    Like:

    63.PNG

    Hope it helps.

     

    Best Regards,

  • yashag2255 Profile Picture
    yashag2255 24,442 on at
    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard

Featured topics