News and Announcements icon

Power Platform CommunityForums Power Automate - Using Connectors V2 changes connecting ...

Power Automate - Using Connectors

Answered

V2 changes connecting to SQL Server

(0) Share

Report

Report

Posted on by myintuition

16

I am trying to run a simple select statement from our on premise SQL Server.

I have a stored procedure to do this which runs, but I am struggling with how to get the results.

I have found several tutorials but wondering if things have changed.

All my Flows have (V2) eg Execute stored procedure (V2) where the tutorials do not have V2.

When I put in my Select Flow and click the From, there is only an icon that says PowerApps - Select_From

Am I doing something wrong, have I missed something obvious or are these new changes.

Here is the tutorial I am attempting to follow now.

https://powerapps.microsoft.com/sv-se/blog/return-an-array-from-a-sql-stored-procedure-to-powerapps-split-method/

Here is what I see

All responses Img

All responses (3)

Answers Img

Answers (1)

Pstork1 67,060 Most Valuable Professional on at

Like (0)

Report

Re: V2 changes connecting to SQL Server

Other than moving the database to Azure SQL your only other option is to not use a stored procedure and get the return data another way.
myintuition 16 on at

Like (0)

Report

Re: V2 changes connecting to SQL Server

ahhhh!!
Ok so what are my options then?
Verified answer

Pstork1 67,060 Most Valuable Professional on at

Like (0)

Report
Re: V2 changes connecting to SQL Server

Its not that you are doing anything wrong. But Stored Procedures have limitations for on-premises connections through a gateway and aren't really supported. Here's the list of limitations from the documentation. https://docs.microsoft.com/en-us/connectors/sql/

When invoking a Stored Procedure on an on-premises SQL server, we have the following limitations:

Output values for OUTPUT parameters are not returned. You can still specify input values for OUTPUT parameters.

Return value is not available.

Only the first result set is returned.

Dynamics schemas are not supported for result sets.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#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

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans