While using SQL execute with Case Statement, The keyword WHEN is not recognizing. The Below Error is coming
"SQL statement unrecognized keyword WHEN"
The SQL query as given below
SELECT [Material],[Value Unrestricted]
case
when [Material]>0 then 'h1'
end as Valuation
FROM [Sheet1$]
Hi @kkreddy
In that result should it be "H1" I cannot remember and wonder if thats it.
I haven't specifically tried to use When through Power Automate Desktop, and wonder what type of connection are you using to open Excel (ODBC?? ADO.NET? JET??)
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Hi Michael Gernaey,
I am trying to use SQL against an excel in Power automate desktop.
Please provide pictures, so we can see and understand what you are doing. Are you trying to use SQL against an Excel Sheet? What are you doing?
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey