web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Authentication Error u...
Power Apps
Unanswered

Authentication Error using Microsoft PowerApp Office Add-in with Excel 2016

(0) ShareShare
ReportReport
Posted on by 8

  I created a separate environment in which I have Common Data Service.  I select the Contact Entity and then hit the 'Open in Excel' button.  The download starts and completes.  I then click the download and Excel 2016 opens up.  I then hit the 'Enable Editing' button and the PowerApp Office Add-in activates.  After a few moments, I get the following error message:

 

2:45:04 PM 1/23/2017Authentication error

Details:
AADSTS50058: A silent sign-in request was sent but no user is signed in. The cookies used to represent the user's session were not sent in the request to Azure AD. This can happen if the user is using Internet Explorer or Edge, and the web app sending the silent sign-in request is in different IE security zone than the Azure AD endpoint (login.microsoftonline.com).
Trace ID: 8f22fe2b-f10b-4c6b-83d4-268a99a97f14
Correlation ID: d1cb2a9d-10c4-4182-8377-5c3b24303473
Timestamp: 2017-01-22 21:58:09Z

 

I'm logged into both the web & Windows 10 PowerApp at the time that I started the download.  The separate environment in which the CDS connection exists is selected as the 'current' environment.

 

Any ideas on how I can correct this issue?

 

Thanks in advance

Categories:
  • v-yamao-msft Profile Picture
    Microsoft Employee on at

    Hi Fcunningham,

     

    Did you sign in the Excel using the same account with PowerApps?

    Could you try to use Chrome to see if you would still get the same error?

     

    Best regards,

    Mabel Mao

  • fcunningham Profile Picture
    8 on at

      Yes, I'm using Chrome Version 55.0.2883.87 m (64-bit) on a Windows 10 (64-bit) - all of the latest patches have been applied - with a GoDaddy hosted Office 365 subscription running all of the Office apps, including Excel, at the 2016 version level.  I have cleared the cache and run Chrome in both regular and incognito modes.  I'm still getting the same error within Excel which is logged into the same GoDaddy O365 account as are the web & PC based PowerApps and the web based Flow app.  (Excel doesn't appear to have the ability to specify a PowerApp/Flow 'environment' but all of my PowerApp & Flow login's include the 'default' environment as a part of their execution context.

     

      I have a 2nd environment defined which is where I was, 1st, able to access my, separate, premium Common Data Service subscription.  I started exploring PowerApps/Flow sometime in December.  At that time, I wasn't able to access CDS directly through GoDaddy as they don't support Enterprise level features.  (I spoke with a support person at GoDaddy and he felt pretty sure that I wasn't going to be able to access CDS under GoDaddy due to the nature of their product offerings around Office 365.)

     

      I noticed that there was a separate 'Sign-up' for premium services that I found on the Microsoft PowerApp website.  I used it to setup my 'separate' trial of CDS.  After doing so, I was unable to figure out how to access the CDS through my GoDaddy account within PowerApps.  I came back at over the past couple of days and noticed that things seemed to have changed as my PowerApps account had a reference to access CDS.  I attempted to do so from within my default environment but didn't get the CDS environment to build within it.  Given that, I hunted around the PowerApp boards and found a CDS note that recommended using a different environment if connectivity/access issues seemed to be preventing the CDS from realizing itself.

     

      I created a new environment and was able to get the CDS connection to initialize itself within it.  It was within this separate environment that I 1st encountered this authentication issue.  (The 1st evening when I successfully initialized the CDS, I was able to do everything including the MS Excel 'Open' function without error.)  The authentication issue appeared the next day after I had to re-establish all of my connections to PowerApp/Flow with my GoDaddy credentials.

     

      2 days ago, out of frustration, I went back to my default environment - I had seen a number of posts on this board related to various authentication issues that MS addressed by doing fixes in the backend - and attempted the CDS initialization again.

     

      This time it worked.  I have, since, switched over to using only the default environment.  The authentication error message below was gotten a few minutes ago attempting to open up the Contact Entity using the 'Open in Excel' button.

     

      By the way, I deleted and then re-installed the Excel Add-in for PowerApps at the same time, 2 days ago, in the hope that a fresh start might help.

     

    ***Error message from Excel 2016's PowerApp Add-in***

    MS_Excel_2016_PowerApps_Error.png

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

      I had seen, in another post by you, that you might want/need a 'Fiddler' dump for such issues.  I downloaded and installed the Telerik version of Fiddler and have played around with it to the point where I can save a 'secured' dump just in case you might want it.

     

      Thank you,

      Frank

  • v-yamao-msft Profile Picture
    Microsoft Employee on at

    Hi Fcunningham,

     

    Have you tried to close this error message and click the Sign in button with the right credential?

    error1.PNG

    Sometimes I get the same error message, I just close the error and sign in again, then it works. Could you have a try and back to me the result?

     

    Best regards,
    Mabel Mao

  • fcunningham Profile Picture
    8 on at

    Response after using Sign-In button 

     

    Yes, doing so just gives the error seen above - hopefully Smiley Happy:

      

      Thank you,

      Frank

  • fcunningham Profile Picture
    8 on at

    PowerApp_Open-in-Excel_Auth_Error2.png

     

    As Maxwell Smart would have said: "Missed it by that much!"

  • v-yamao-msft Profile Picture
    Microsoft Employee on at

    Hi Fcunningham,

     

    I tried to reproduce your issue from my side, but I am not able to reproduce it.
    If you have a fiddler trace, please send it to my email address, and I will try to involve someone who is familiar with this to take a further investigation on it.

     

    Thanks for your patience and understanding.

     

    Best regards,
    Mabel Mao

  • fcunningham Profile Picture
    8 on at
    I have collected the Fiddler session that shows me logging into PowerApp Studio, spawning a PowerApp Web session where I open up the CDM Orgaization entity then hit the 'Open in Excel' button. The download takes place and I click it followed by Excel opening where I hit the 'Enable Editting' button. At that point the 1st error message is encountered. I close that and attempt the separate 'Sign-in' but that fails to. How can I, securely, send you the resulting SAZ file? Should I use the Private Message facility of this board or is there a better way to send it? Thanks, Frank
  • v-yamao-msft Profile Picture
    Microsoft Employee on at

    Hi Frank,

     

    Please try to send it to my email address.
    And my email address is v-yamao@microsoft.com.

     

    Best regards,
    Mabel Mao

  • m_takatsuka Profile Picture
    33 on at

    I also had the same symptoms.
    In my case, after opening the file downloaded from the CDS, I selected the account tab from Excel's file tab, and I chose sign out from office there.
    Then I signed in at Microsoft PowerApps Office Add-in on the spreadsheet screen by clicking → on the tab on the tab without signing in.
    In my case, I could connect to CDS with this operation.

    I hope Frank will go well.

    (Since I can not write English, I wrote this sentence in a WEB translation
    I am sorry if it is not correct English)

  • Nishant Rana Profile Picture
    81 on at

    This should help fixing the issue

    https://tinyurl.com/y8lzcyme

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 350 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 318

#3
Mohsin Ali Profile Picture

Mohsin Ali 220

Last 30 days Overall leaderboard