Power Automate Desktop - Execute SQL Statement

(0) Share

Report

Posted on by MCubedMama

I am trying to Execute a SQL query in Power Automate Desktop. Part of my query includes the following code:

And (Assign_To_Name = '%Smith%' Or
Assign_To_Name = '%Johnson%' Or
Assign_To_Name = '%Null%')

However, I receive an error that states Invalid Column Name. I have tried severl different ways of executing code such as

And( Assign_To_Name = "%%Smith%%") or Assign_To_Name like '%Smith%' but none of these syntax ways work. I think it is the modulus that is throwing it off. Any suggestions

Categories:

Power Automate Desktop

All responses (5)

Answers (1)

Sort by

UshaJyothiKasibhotla 229 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MCubedMama

Give coloumn name in square brackets.....

For example [columnname]

Then it works....please check.....

Hope this helps,

Usha.
MCubedMama 64 on at

Like
a
(0)

Report
Copy link

Link copied!

@UshaJyothi20 So I tried that using And( [Assign_To_Name] = '%Smith%')
and I received the following error: Parameter 'SQL statement': Variable 'Smith' doesn't exist
UshaJyothiKasibhotla 229 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MCubedMama

Use this [columnname] = %variable%

Hope this helps

Usha
MCubedMama 64 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for helping. Unfortunately that doesn't work either
Verified answer

CU16071609-1 6,255 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@MCubedMama
Please follow the below syntax for variables:
SELECT * FROM TableName where (Column_Name like '%Variable1%' or Column_Name like '%Variable2%')
If you want apply text instead of variable then use below syntax:
SELECT * FROM TableName where ( Column_Name LIKE '%%Value%%' )