Power Platform Community Forum Thread Details

connect to lists within a sharepoint appweb

Trying to get a connection to lists in an appweb within a sharepoint hosted app and I get the follwoing error when I enter in the url setting up a sharepoint connection

Could not retrieve values. {"error_description":"Exception of type 'Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException' was thrown."}

I have no issue connecting to lists in the host web ( a regular team site) of the SP hosted app

I have tried to manually create a connection in the Manage->Connection under the powerapps site with no luck. Looks like an authentication issue within the appweb.

Thinking the issue is because the host web uses AAD auth and SP hosted apps use ACS.

This post may provide the necessary code bits if we have to create a custom connector for appwebs...

http://dannyjessee.com/blog/index.php/2014/07/accessing-sharepoint-data-from-provider-hosted-apps-use-the-right-context/

does anyone have any insights on this?

Thx!

Categories:

Connecting to Data

Based on my test, lists created within a SharePoint Hosted App(now named SharePoint Add-in) cannot be selected in PowerApps. Manually enter the URL encountered the same error as you saw. Basically the SharePoint hosted add-in URL format looks like https://yourdomain-8efd32da51497a.sharepoint.com/. Please notice that this is a different domain from your SharePoint sites, so the token generated in PowerApps may not be used for this domain. SharePoint iteself uses the cross domain library(CDL) to deal with the cross domain authentication issue.

It's not difficult to understand that the provider hosted SharePoint add-ins can also not work with PowerApps, because it is totally a separate web app, and use ACS as a trust broker with SharePoint.

Thanks,
Reken Liu

Quick Links

Leaderboard > Power Automate