cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shin12
Frequent Visitor

How to use LIKE SQL with Power Automate Desktop

Hi everyone 

 

I am in need of help to query data using Like SQL Query Expression

 

so I have excel table with column named product_name

in product_name column we have D&D Asorted, D&D 56Pack and so on.

 

 

i want to pull this data using SQL query Like expression,

 

 

tried this SQL below but it cannot get the data

 

select product_name

from [Sheet1$]

Where product_name Like 'D[&]D*' 

 

4 REPLIES 4
Sundeep_Malik
Community Champion
Community Champion

Thank you, i already look for that above.

 

when i set variable it give me syntax error.

 

1. set variable D&D is text not variable

Shin12_0-1662594712324.png

 

i am not sure what i am doing wrong

I'm not very good at SQL so I may be wrong here...
It looks like you're using a quotation mark like this = ´
rather than an apostrophe = '
not sure if the SQL used in PAD supports the use of ´

eeeeeeeeeeeeee2
Regular Visitor

Example:

SELECT * FROM device where ( model like  %'\"%Desktop%\"'%  or model like   %'\"%Laptop%\"'%   or model like  %'\"%Workstation%\"'% ) and status ="Completed"

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,370)