Dear Community,
I am currently facing an issue with a canvas application developed within a PowerApps solution (SharePoint based customized form).
The application relies on SQL Server connections as its data sources, where we want to display the data in PowerApps gallery and forms (using SQL Views/Tables as data source).
The problem arises after successfully publishing the app. It throws the below error for the end users:
"Error when trying to retrieve data from the network: Error from token exchange: Permission denied due to missing runtime policy ACL: User = cac5b1d0-b2e5-45bf-84d5-ce451e46b524@46e16835-c804-41de-be3c-55835d14dee4 appid=9362bc14-3e81-4ef9-8b77-f1c40afe68e0, runtimePolicy=europe-001/sql/40abe139-5f46-4145-8b50-7d990116a8e5"
Screenshot of the PowerApps error (This is the share point integrated PowerApps - customized form)
To address this issue, please find the below observations and implementations:
- Granted access to end users for SharePoint list where app is linked - Did not work
- Cleaned up the data sources and Reconnected the SQL table/View connections - Did not work.
- Created a replica of the same app as stand-alone app - Works only for stand-alone app not the Sharepoint integrated app(NOTE: we are facing issue for Sharepoint integrated power app)
- Only owners of the application are able to see the data without any error - Not the end users
- Shared SQL connection to users within PowerApps - Did not work
Despite these measures, am still facing the issue.
I am seeking guidance from this esteemed community to help me resolve this issue. Any insights, suggestions, or potential solutions to troubleshoot and overcome this problem would be greatly appreciated.
Thank you in advance for your invaluable support.
Best Regards,
Chethan M
