Office 365 Config and app registration from scratch

Hi All,

I want to access SharePoint download and upload excel file.
Using Microsoft Graph > Delegated permissions, connect with client id and secret only.

Please suggest the App registration configuration and office 365 properties details required data.

I provide the official UiPath link for delegate permission, but they are not much understanding so provide only required all steps.
Please help - @loginerror , @ashokkarale , @Yoichi , @Anil_G , @lakshman , @pikorpa , @Jon_Smith , @marian.platonov

Note: We are developing for the client and above config, he has also security concent so only required permission & data they will provide.

@RPA_Learner0

Follow below post. here mentioned step by step

Happy Automation!!

Hi @yedukondaluaregala
thanks for response, but this is not relevant for my case.
I want to connect through client and secret ID.

@RPA_Learner0

App ID and secret basically is supported for application scope and not delegated

ideally the way you can control app scope is by setting up accesses on the vm and id’s in azure and give app scope for accessing from UiPath..azure team can help you better understand this

this is one such example to control access..similarly at each level app access can be controlled

cheers

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.

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

Hi @sonaliaggarwal47
I have tried all but unable to get access.

Please check screenshot

@RPA_Learner0

This issue was occurring due to access issue, please check for proper access should be having for that account and connect with devops team whether they are allowing to access the sharepoint or not

If the access issue resolved then you wont get this issue.

I have access , i can access manually but not using UiPath

Check with you devops team mostly they are restricting permissions.

Hi @RPA_Learner0,

Which version of O365 package you are using?

Also, can you check in your app registrations by going to view api permissions, which permissions have been granted to you?

Also can you show me properties of your 0365 scope? I need to see what options you have selected there.

Please note that you need to use client id, secret and also tenant in your Microsoft scope for authentication.

Regards
Sonali

Hi @RPA_Learner0

Please check with AD team and Infra team. Might be some access issue.
For more check below link,

Happy Automation!

Hi @RPA_Learner0

were you able to resolve this error?

Regards
Sonali

The Azure App registration (UiPathStudioO35App) does not have the API permission set for the Graph API.

I think our docs are really good about this.

See:

What I recommend is to have your admin setup the API permissions for applicationID and Secret.

If you are using your own App registration or Default UiPath O365 application, make sure that for the first time your Azure admin user logs in and to approve the application access.

Later, the other non admin users can use the automation.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.