Unable to Connect PowerApp to OneDrive for Business

[chad]

Hello,

I have an Office 365 account. Also with that account I have access to OneDrive for Business. In my OneDrive, I have an Excel Spreadsheet that I want to connect to a PowerApp. So, I attempted to create a connection from my PowerApp to my OneDrive for Business account.

When I attempted to do that, I received the following error:

We weren't able to add this connection. Please try again:

{"Message":"Failed to login to first party application: Failed to acquire token from AAD: AADSTS50001: Resource 'https://api.office.com/discovery/' is disabled.\r\nTrace ID: [id]\r\nCorrelation ID: [id]\r\nTimestamp: 2016-08-04 23:39:11Z"}

Session ID: [id]}

My question is, what's wrong? I have full control over the OneDrive account. Even more strange is that I was able to successfully add the OneDrive for Business account as a connection. It just fails when I try to connect it to my app. 

I am using PowerApps Studio for Web

[archanan]

Do you have an active Office365 subscription? Based on the error you are seeing, it looks like the account you used to sign in doesn/t. Can you check if you are able to sign into www.office.com and access any apps there? If not, you probably don't have an Office365 subscription.

[chad]

I do have an active Office 365 subscription. I can successfully sign into www.office.com. I can successfully access (and launch) apps there. In fact, I just successfully opend Mail, Calendar, OneDrive, SharePoint, Planner, Power Bi, Word, Excel, PowerPoint, and PowerApps itself. Still, when I try to create a connection from my PowerApp to my OneDrive for Business account. 

The really odd part is that if I go to "Manage -> Connections", I can successfully add the connection to my OneDrive for Business account. Yet, when I attempt to "Create an app from your data" and click the "Phone layout" button underneath OneDrive for Business, then click "Connect", I get the error mentioned at the start of this thread.

[chad]

This issue is still not resolved. For that reason, I'm following up.

[archanan · Accepted solution]

Sorry to hear that it's still not resolved.

When you select OneDrive for Business Phone Layout, in the next screen (with the list view), are you able to see your existing ODB connection and when you select this connection, do you see the error you mention? Or, are you trying to create a new connection again?

[danchart]

Can you provide the error message _with_ the ID's intact please?

[chad]

On a somewhat positive note, I can now connect to my OneDrive for Business account and see my Excel spreadsheets. I'm not sure what changed as I did not change anything. However, I'm unable to connect my actual spreadsheet. It says something like "There are no tables in the layout". I'm opening a seperate thread for this.