cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mhasan
Advocate II
Advocate II

A lot of stored procs are missing from the list in the execute sp action

Hi,

The drop down in the Excute Stored Procedure action displays some stored procs but majority are not included in the list including the sp I'm trying to execute.

 

Please advise if this is a known bug or something in the configs of the database that may cause this.

 

Thanks

3 REPLIES 3
v-yuazh-msft
Community Support
Community Support

Hi @mhasan,

 

Could you please explain more about the connector that you mentioned?

Which connector are you mentioned?

 

Please share more details so we would try to provide a proper workaround for you.

 

Best regards,

Alice

Sorry for the lack of details.  I'm connecting through a data gateway which was created by our DBA and shared with me.

I'm connecting to SQL Server 2012 the biggest table I'm using has under 1400 records.  Please let me know if you need more details.  Appreciate your help. 

Anonymous
Not applicable

What needs to happen to get stored procedures to appear in the Execute Stored Procedure v2 Flow action?  There should be two dbo. procs here but it sees nothing. What are we doing wrong?

 

stored-proc-missing.PNG

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (2,861)