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

I have the same question (0)

All responses (5)

Answers (1)

UshaJyothiKasibhotla 203 Moderator on at

Like (0)

Report

Hi @MCubedMama

Give coloumn name in square brackets.....

For example [columnname]

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

Hope this helps,

Usha.

Was this reply helpful? Yes No
MCubedMama 64 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
UshaJyothiKasibhotla 203 Moderator on at

Like (0)

Report

Hi @MCubedMama

Use this [columnname] = %variable%

Hope this helps

Usha

Was this reply helpful? Yes No
MCubedMama 64 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (1)

Report

@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%%' )

Was this reply helpful? Yes No