cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
skylitedave
Kudo Kingpin
Kudo Kingpin

connect to lists within a sharepoint appweb

Hi

 

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-us...

 

does anyone have any insights on this?

 

 

Thx!

 

1 REPLY 1
rekenliu
Power Apps
Power Apps

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 

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Users online (55,928)