cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Teresa24486
Post Partisan
Post Partisan

Get Data from SharePoint -invalid credentials

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

 

7 REPLIES 7
anupam8555
Helper V
Helper V

Hi @Teresa24486 ,

 

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

 

Thanks

Anupam 

Hi @anupam8555 ,

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

Teresa24486_0-1613739119525.png

 

Hi ,

Can I follow up on the request?

 

EricRegnier
Super User
Super User

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!

anupam8555
Helper V
Helper V

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)

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
Super User
Super User

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

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,351)