Forum Discussion

slhangen's avatar
slhangen
Helper II
5 years ago
Solved

Getting Access is forbidden error when connecting OneDrive excel file

How do I get to the Authenticate screen to input credentials? Saw the screen once and cannot get back to it.
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    With the SharePoint Folder connector you only use the site URL and then navigate to the file with the FileName and FolderPath columns.  Delete the url text after the site level.

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

Are you using the url from when you open the file in the desktop app?  The one that ends in ?web=1 (that you delete).

In any case, it looks like you are connecting to a OneDrive file, and I would use the SharePoint folder connector instead, replacing @ and . in your email address to _ 

 

Regards,

Pat

  • slhangen's avatar
    slhangen
    Helper II
    5 years ago

    Thx so much for your help, Pat.  USed SharePoint Folder connector.

    Pasted in url, deleting the ?web=1 and got the authentication box.  Filled out box with credentials and got this error:

     

     

     

    ugh!