Showing results for 
Search instead for 
Did you mean: 
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*' 


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



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 ´

Regular Visitor


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

Helpful resources

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)