Announcements
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 ?
Hi @Random1234 ,
Use Filter Query.
Sample Data in SharePoint Document Library:
Flow:
Hope this will work for you.
Regards
Kaif
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 592
Valantis 340
11manish 284
