SQL Stored Procedure Call from PowerApps | Missing all my stored procedures

(0) Share

Report

Posted on by Warren-GenPoint

Hi,

I have a PowerApp connecting to on-premise SQL via a gateway. All is good, I am able to read and write to any table and call any view. We decided to start trying to use Stored Procedures for the obvious performance benefits.

But, I cannot see any stored procedures other than what appears to be a few built-in ones.

These are the type of stored procedures I can see when selecting (Showing when I start typing sp_)

Here is when you don't search, shows about 56 stored procs, none of my own custom ones.

These are the ones I really want to see.

Does anyone have any ideas here or had a similar issue and how did you resolve it? I am 100% I am using the correct SQL connection as I am seeing all the tables and views.

Thanks,

Warren

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (9)

Answers (0)

Pstork1 69,129 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Are you running the SQL connection as your account? Or using a SQL authentication? Could it be that the account used in the connection doesn't have permissions for the Stored Procedures?

Was this reply helpful? Yes No
Warren-GenPoint 55 on at

Like (0)

Report
Copy link

Link copied!

Hi, I created the stored procs.

Was this reply helpful? Yes No
Pstork1 69,129 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I understand that they are your Stored Procedures. But the connector is probably running using a different account. If it is then the stored procedures would only be visible if that account has access to the stored procedures. When you set up the SQL connection what type of authentication did you use?

Was this reply helpful? Yes No
Warren-GenPoint 55 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Okay I get what you mean, its using SQL authentication. Same account I used to create the procs.

Was this reply helpful? Yes No
Pstork1 69,129 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The only other thing I can suggest is to try creating a Power Automate flow and see if the Stored Procedures are visible there. If they aren't then its definitely a problem with authentication through the connector. If they do then its some kind of bug in the Power Apps support. Stored Procedures in Power Apps is a very new feature.

Was this reply helpful? Yes No
Warren-GenPoint 55 on at

Like (0)

Report
Copy link

Link copied!

Thats great idea. I will try that also.

Was this reply helpful? Yes No
Warren-GenPoint 55 on at

Like (0)

Report
Copy link

Link copied!

oh no....bug? I am seeing all sprocs in powerautomate via same gateway

Was this reply helpful? Yes No
Suggested answer

Warren-GenPoint 55 on at

Like (0)

Report
Copy link

Link copied!

@Pstork1 - turns out my account didnt have execute stored procedures permissions on test database. You DID mention that earlier. Thanks!

Was this reply helpful? Yes No
MichaelFP 1,943 Moderator on at

Like (0)

Report
Copy link

Link copied!

Are you using Datagateway for that? If it is, try to remove and include the SQL connection again in power apps.

Was this reply helpful? Yes No