Office 365 Config and app registration from scratch

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @RPA_Learner0,

We had done a quite bit of research in our organization on this topic as due to security restrictions, not all the authentication types work for us.

Please refer below thread where I have shared in what scenarios, which with type should be used.

UiPathTeam.SharePoint.Activities Authentication exception: The sign-in name or password does not match one in the Microsoft account system

Hi @Yap_Derek , Just some more info to help you out a bit(we did have various challenges ahead of us to enable O365 package), thus sharing few learnings: Out of 4 authentication types listed below, only few options turned to be applicable to us(per our internal configurations): Interactive Token → only applicable for attended users but can be used if your organization’s internal configurations allow. Integrated Windows authentication → suitable for unattended users but can not be used if…

You should be able to use client/app id and secret by registering your SharePoint site on azure and by providing it the application level permissions.

You will need to check internally with O365 admin team to get that done.
They will most likely do it case by case. In our case, we have to get this done for every SharePoint site we want to access via O365 package as getting application level access exposes the resources to a security threat hence, it needs to be restricted.

API permissions we are using - Sites.Selected for the site we request access for.

Regards
Sonali