Power Platform Community Forum Thread Details

I have a PowerApp that is calling a SQL stored procedure on Azure virtual machine.
Stored procedure is activated directly from Power Apps and not with flow.
I use the same account in both runs as described below.

When I run Power App is activated in edit mode, everything is working perfect.
When i run the Power App in run mode, i get the following error message:

{ "code": 403,
"message": "Operation is not allowed",
"source": "europe002-002.azure-apihub.net",
"path": "choose[3]\\when[1]\\choose\\when[1]",
"policyId": "",
"clientRequestId": "xxxxx",
"dreeSet": "true" } }

Please advice how to solve this issue?

Categories:

Power Apps Pro Dev & ISV

Hi,

Hmm.. I am wondering if when you are building the App I believe its because the URI / IP is different than when you Play (run it) so I believe you need to

verify that its allowed from the IP / Range of the Run, not the Edit

I hope that makes sense, as thats the only thing I can think of, unless its a user based issue, where I assume its YOU doing the run etc.

What you can try though to get more details.

1. Close the app in Run Mode

2. Go to Apps from Power Apps.com

3. Find your app and select the ...

4. Select Details => Monitor

5. once monitor is up, click Play Published Version

6. Once that tab opens, causey our error to happen

7. Flip back to Monitor and Filter (top right) by Error

8. Now find the "grouping 2-4" of errors related to your specific error

When you do, one of them will open a side window on the right with 4 Tabs. The 4th is the Response