How do I connect Power Automate to my hosted SQL Server VM?

Question

Hi

I hope this question is not out of context and I am posting on the right community Forums.

I would like to connect my SQL Server VM (MSSQL, hosted in a Windows environment of course) to our Power Automate apps to do SQL queries, execute stored procedures and do lookups for suppliers, etc.

I've been following guides: ways-to-connect-to-sql

And I got the point where, great my VM is up. But how do I now test connectivity to SQL?

To actually execute a query and see data coming back into the cloud environment.

My goal is to:

1. Pull in invoices via our generic email account using Power Automate
2. Save them under the correct directory after using AI builder to extract invoice information
3. Use the invoice information, more specifically the Purchase Order Number, to query SQL (The ERP systems back-end)
4. And makes decisions based off this to automate our invoice processing and checking side of the accounts function within our organization.

Please let me know if I can provide more information.

Thanks in advance

Answer 1

Power automate is not currently supported here on Q&A. The product group for Power automate actively monitors questions in dedicated forums here.
https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

--please don't forget to upvote and Accept as answer if the reply is helpful--