SQL Server Connector Missing Schema Name

(0) Share

Report

Posted on by CU10091302-0

I have two stored procedures with the same name that live in different schemas:

When using the "Execute a stored procedure (V2)" connector, I can't tell them apart:

The only way to do so is to click the "..." and "peek code":

From there, I can read the JSON and see the fully qualified SP name:

This is clunky. Is there some reason that we don't see the [schema].[table] in the dropdown when using this connector? Can that be a setting we are able to turn on at some point in the "Settings" menu here at some point?

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

wskinnermctc 6,519 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @dschro1 This would be something you can add as a recommendation in the Power Automate Ideas Forum.

I agree it would be helpful, but honestly I doubt anything will change. The connector for SQL Server doesn't get a lot of attention from Microsoft.

Was this reply helpful? Yes No
CU10091302-0 24 on at

Like (0)

Report
Copy link

Link copied!

Ah, didn't realize there was a separate spot for ideas. I'll post there, thanks!

Was this reply helpful? Yes No
CU10091302-0 24 on at

Like (0)

Report
Copy link

Link copied!

For anyone interested in this issue, please upvote/comment here: Add Schema Name to SQL Server Tables in SQL Server Connector.

Was this reply helpful? Yes No