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

Community site session details

Session Id : gKQgjrjK5umnImR1G9Zzn1
Power Platform Community / Forums / Power Automate - Using Connectors / SharePoint connection ...
Power Automate - Using Connectors
Unanswered

SharePoint connection failed: UnauthorizedAccessException

Like (0) ShareShare
ReportReport
Posted on 8 Dec 2022 12:24:48 by Jack13

Hi,

 

I have build a flow which generates an excel export using excel online in Sharepoint folder. The flow has worked fine up to now but since this morning I am getting the following error:

{ 
 
"917656; Access+denied.+Before+opening+files+in+this+location%2c+you+must+first+browse+to+the+web+site+and+select+the+option+to+login+automatically.",
 
}
Jack13_0-1670502201648.png

 

How and where can I enable automatic login for the sharepoint folder for all users of the power app.
I have the same question (0)
  • Prabu Profile Picture
    Prabu 55 on 09 Dec 2022 at 20:56:32
    Re: SharePoint connection failed: UnauthorizedAccessException

    Hi @Jack13 , Account used in the "Get file content" action connection should have access to the SharePoint library. Make sure the file that you're trying to access do not have unique permission, otherwise it should work without any error

  • BJ94 Profile Picture
    BJ94 264 on 13 Dec 2022 at 11:39:38
    Re: SharePoint connection failed: UnauthorizedAccessException

    Hi @Jack13 

     

     Problem seems like it was permissions related in the sharepoint datasources. One of my flow I upgraded the permissions and the flow automatically reran itself.

     

    More information here for troubleshooting this issue: Error when you turn on solution based flows in Power Automate (sharepains.com)

     

    -------------------------------------------------------------------------------------------

    Regards,

    Bharti

    Community Support Team _ Bharti
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • JojiCherian Profile Picture
    JojiCherian 6 on 14 Jul 2024 at 03:44:25
    Re: SharePoint connection failed: UnauthorizedAccessException

    Hi @Jack13  did you find the solution on this ?
    Despite of having an admin with Full control access, I am also facing same issue as you.Though I am trying to achieve using REST-API in power automate desktop.
    @ManishSolanki I would appreciate if you can help us here.The URI works well , when it is opened in browser.

    JojiCherian_0-1720928657625.png

     

  • ManishSolanki Profile Picture
    ManishSolanki 15,089 Super User 2025 Season 2 on 14 Jul 2024 at 05:16:49
    Re: SharePoint connection failed: UnauthorizedAccessException

    Hi @JojiCherian 

     

    You may directly use "SharePoint" cloud connector in PAD as those are available in latest version.

     

    Here is the list of cloud connector supported in PAD:

    Cloud Connectors in Power Automate for desktop - Power Automate | Microsoft Learn

     

     

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

  • JojiCherian Profile Picture
    JojiCherian 6 on 14 Jul 2024 at 06:58:29
    Re: SharePoint connection failed: UnauthorizedAccessException

    Hi @ManishSolanki ,
    Thank you for your prompt response .Before attempting the  PAD Web Service , I tested it with cloud SharePoint connectors  , that went well.
    However , the current requirement is to exclusively use the PAD Web Service.

    fyi:-@Expiscornovus @SpongYe 

     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 788 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 452 Moderator

#3
developerAJ Profile Picture

developerAJ 302

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans