Skip to main content

Notifications

Community site session details

Community site session details

Session Id : iRphUPUfILo8aQdaQ164a8
Power Automate - Building Flows
Unanswered

Getting Syntax error in Get rows SQL Connector

Like (0) ShareShare
ReportReport
Posted on 12 Jul 2023 15:03:30 by

Hi,

I'm getting syntax error when executing a query in Get rows V2 filter query.

 

The query I'm executing is Select * from tablename where a<>0.00 or b<>0.00 or c<>0.00 ......(assume15 columns ).

The error I'm getting is: Syntax error at position 8 (whole select query) client id : .(some client id)

 

How I can solve this? as I want to update my sharepoint list from SQL Table using automate flow.

Thanks

 

 

  • DBTS7 Profile Picture
    on 18 Jul 2023 at 04:28:30
    Re: Getting Syntax error in Get rows SQL Connector

    Hi,

    Any solution for this? 

    or Is it the issue from microsoft itself?

     

    Thanks

  • DBTS7 Profile Picture
    on 17 Jul 2023 at 10:25:22
    Re: Getting Syntax error in Get rows SQL Connector

    Hi,

    I'm using nvarchar(8) for the column type .

    and Execute a SQL query action is running successfully. Not sure what I'm doing wrong...

  • Expiscornovus Profile Picture
    31,652 Most Valuable Professional on 17 Jul 2023 at 08:32:24
    Re: Getting Syntax error in Get rows SQL Connector

    Hi @DBTS7,

     

    What type of column are you using in your query? Is it a string type of column or a integer/number? 

     

    Can you also try the Execute a SQL query action with your original SQL query to see if that makes a difference?

  • DBTS7 Profile Picture
    on 17 Jul 2023 at 07:07:27
    Re: Getting Syntax error in Get rows SQL Connector

    Hi @Expiscornovus , Thanks for your reply,

    But now the error occurred because of Pagination.

    The below is the screenshot of trigger

    DBTS7_0-1689577434072.png

    and this is the pagination screenshot:

    DBTS7_1-1689577479189.png

    Whenever I'm enabling pagination, then I'm getting an error:

    DBTS7_2-1689577727218.png

     

    . Without enabling pagination, the flow is working fine (but only giving 2048 values by default)

     

    What am i doing wrong here?

     

  • Expiscornovus Profile Picture
    31,652 Most Valuable Professional on 13 Jul 2023 at 10:23:35
    Re: Getting Syntax error in Get rows SQL Connector

    Hi @DBTS7,


    The Filter Query field in the Get rows (v2) action expects an OData type of filter. I see you used the SQL query instead.

     

    Try something like below. Replacing <> by not equal (ne).

     

    (a ne 0.00) or (b ne 0.00) or (c ne 0.00)

     

     

    Or you can also have a look at the Execute a SQL query (V2) action instead, that action should be able to handle a SQL query:

    https://learn.microsoft.com/en-us/connectors/sql/#execute-a-sql-query-(v2) 

     

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,743 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,089 Most Valuable Professional

Leaderboard
Loading started