You’re offline. This is a read only version of the page.
6
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 ?
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.
Hi @Random1234 ,
Use Filter Query.
Sample Data in SharePoint Document Library:
Flow:
Hope this will work for you.
Regards
Kaif
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
