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
Hi,
Any solution for this?
or Is it the issue from microsoft itself?
Thanks
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...
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?
Hi @Expiscornovus , Thanks for your reply,
But now the error occurred because of Pagination.
The below is the screenshot of trigger
and this is the pagination screenshot:
Whenever I'm enabling pagination, then I'm getting an error:
. Without enabling pagination, the flow is working fine (but only giving 2048 values by default)
What am i doing wrong here?
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)
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,089
Most Valuable Professional