Get Data from SharePoint -invalid credentials

Like (0) Share

Report

Posted on 15 Feb 2021 11:24:05 by Teresa24486

611

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?

Categories:

Solution Explorer

Dataflows

Microsoft Dataverse

All responses (9)

Answers (0)

EricRegnier 8,714 Most Valuable Professional on 25 Oct 2021 at 22:18:34

Like (0)

Report

Re: Get Data from SharePoint -invalid credentials

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?
romankorchak1 40 on 25 Oct 2021 at 10:03:32

Like (0)

Report

Re: Get Data from SharePoint -invalid credentials

I am getting same error when trying to get data from SP list into dataverse
Any ideas what could be the problem and how to sort it?
Credentials are correct!
Thanks
EricRegnier 8,714 Most Valuable Professional on 23 Feb 2021 at 08:38:08

Like (0)

Report

Re: Get Data from SharePoint -invalid credentials

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.
Teresa24486 611 on 22 Feb 2021 at 16:51:05

Like (0)

Report

Re: Get Data from SharePoint -invalid credentials

hi @EricRegnier ,
I was allowed to Transform data and then bypassed few other screens; in the end I encounter this error:
khasia.anupam 355 on 22 Feb 2021 at 16:39:22

Like (1)

Report

Re: Get Data from SharePoint -invalid credentials

Hi @Teresa24486 ,

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

Let me know if it works.

Thanks
Anupam
(please mark as resolved if it helps you really)
EricRegnier 8,714 Most Valuable Professional on 22 Feb 2021 at 07:13:36

Like (0)

Report

Re: Get Data from SharePoint -invalid credentials

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!
Teresa24486 611 on 22 Feb 2021 at 04:50:19

Like (0)

Report

Re: Get Data from SharePoint -invalid credentials

Hi ,
Can I follow up on the request?
Teresa24486 611 on 19 Feb 2021 at 12:52:16

Like (0)

Report

Re: Get Data from SharePoint -invalid credentials

Hi @anupam8555 ,
I am getting this error for any data source I use:
khasia.anupam 355 on 15 Feb 2021 at 17:26:39

Like (0)

Report

Re: Get Data from SharePoint -invalid credentials

Hi @Teresa24486 ,

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

Thanks
Anupam