Unanswered

Run SQL queries on an Excel File using Power Automate Cloud

Like (0) Share

Report

Posted on 5 Jun 2024 13:39:47 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 ?

All responses (2)

Answers (0)

Random1234 6 on 05 Jun 2024 at 17:29:56

Like (0)

Report

Re: Run SQL queries on an Excel File using Power Automate Cloud

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.
Kaif_Siddique 2,104 Super User 2024 Season 1 on 05 Jun 2024 at 16:25:53

Like (0)

Report

Re: Run SQL queries on an Excel File using Power Automate Cloud

Hi @Random1234 ,

Use Filter Query.

Sample Data in SharePoint Document Library:

Flow:

Hope this will work for you.

Regards

Kaif