Unanswered

Run SQL queries on an Excel File using Power Automate Cloud

(0) Share

Report

Posted on by Random1234

I have a table in a Excel File and I would like to run sql queries on this table. I've found multiple sites that answered this question (notably this one: Run SQL queries on Excel files - Power Automate | Microsoft Learn), however all of them use Power automate Desktop and i'm using the cloud version, so the setup is different from the tutorials I've seen. Additonally, I seem to not have access to the "Open an SQL connection" action on power Automate Cloud. Can someone please help me with this issue ?

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (0)

Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Random1234 ,

Use Filter Query.

Sample Data in SharePoint Document Library:

Flow:

Hope this will work for you.

Regards

Kaif

Was this reply helpful? Yes No
Random1234 6 on at

Like (0)

Report

Thank you for your quick answer! My issue is that I'm also planning on executing more complex sql queries between different tables (on different Excel files) so I think it'd be easier for me to find a way to create an sql connection with my files (I'm trying with just one file for now). Unfortunately, I have no idea why this action isn't available on my Power Automate Cloud. Any idea would be greatly appreciated.

Was this reply helpful? Yes No