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. 

RachelRig
Advocate V
Advocate V

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
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,348)