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 / Get Data from SharePoi...
Power Apps
Unanswered

Get Data from SharePoint -invalid credentials

(0) ShareShare
ReportReport
Posted on by 613

Hi,

While using the Get Data feature from Solutions, I am unable to authenticate to the SharePoint connector or even excel connector. It only works with Get Data from Excel. Is this a bug? 

Teresa24486_0-1613388101117.png

 

I have the same question (0)
  • Anupam.Khasia Profile Picture
    368 on at

    Hi @Teresa24486 ,

     

    What error are you receiving while importing data from excel or SharePoint ? Please post screenshot or error details. 

     

    Thanks

    Anupam 

  • Teresa24486 Profile Picture
    613 on at

    Hi @anupam8555 ,

    I am getting this error for any data source I use:

    Teresa24486_0-1613739119525.png

     

  • Teresa24486 Profile Picture
    613 on at

    Hi ,

    Can I follow up on the request?

     

  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    Hi @Teresa24486,

    Instead of pasting the URL of the SharePoint list, paste only the base URL like "org.sharepoint.com". Then on the following page you would be able to select the desired list.

    Let me know how that goes!

  • Anupam.Khasia Profile Picture
    368 on at

    Hi @Teresa24486 ,

     

    You should be able to connect with sharepoint . Please try "orgname.sharepoint.com" .  

     

    anupam8555_0-1614011916140.png

     

    Let me know if it works. 

     

    Thanks

    Anupam

    (please mark as resolved if it helps you really)

  • Teresa24486 Profile Picture
    613 on at

    hi @EricRegnier ,

    I was allowed to Transform data and then bypassed few other screens; in the end I encounter this error:

    Teresa24486_0-1614012647467.png

     

  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    It's hard to tell exactly what the cause of the error is. Would it be possible to try with a simple Dataflow with little/no transformation to isolate the issue? Where you able to save the Dataflow and did it fail during a run? If so, go to Dataflows section in make.powerapps.com and click the little warning icon to see the error message.
    2020-06-13_8-19-14.png

     

  • romankorchak1 Profile Picture
    47 on at

    I am getting same error when trying to get data from SP list into dataverse 

    InvalidCredentials.PNG

    Any ideas what could be the problem and how to sort it?

    Credentials are correct!

    Thanks

  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    It's hard to tell exactly what the cause of the error is. Would it be possible to try with a simple Dataflow with little/no transformation to isolate the issue with a brand new connection. I would also check with your IT dpearment to ensure no firewall/proxy in place to block these connections. Another thing to check is your rights/roles. Are you a SP admin?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 493 Most Valuable Professional

#2
11manish Profile Picture

11manish 479

#3
Haque Profile Picture

Haque 328

Last 30 days Overall leaderboard