How to read excel file from sharepoint using Sharepoint package

Help Studio
1

Hello,

I need to read Excel file from Sharepoint in UiPath. I have already installed the Sharepoint package from Manage Package and used “Get file or Folder” activity. However, I am receiving error message stating that " Integration service is not available" .

Could you please suggest how to resolve the issue? Any guidelines or
suggestions would be helpful.

Thanks,
Nawaz.

2

Hi @mohammed_nawazuddin1

You are receiving this error message because you first need to create the SharePoint integration connection in Orchestrator. It will then become available for you to use in Studio.

This is how you do it. Firstly, go to Orchestrator folder and the click on Connections tab - and then “Add connection”

image
image1626×614 34.5 KB

After this, search for SharePoint and configure it:

image
image1627×830 43.5 KB

Once complete. Go into Studio and select the integration connection from the activity dropdown (it should now show).

Let me know if this helps.

3

Hello @mohammed_nawazuddin1 ,
If the issue is still not resolved, you can try the below steps

The error “Integration Service is not available” usually occurs when the UiPath Integration Service is not enabled or the tenant/license does not support it.

Steps:

  1. Verify that your UiPath Automation Cloud tenant has Integration Service enabled.
  2. Go to Automation Cloud → Admin → Licenses and check if Integration Service is available in your plan.
  3. Ensure you are signed in to the correct UiPath account and tenant in UiPath Assistant/Studio.
  4. Update UiPath Studio and SharePoint package to the latest version.
  5. Try creating a new SharePoint connection from Integration Service → Connections.
  6. If using on-prem Studio, restart UiPath Assistant and Studio after reconnecting.

If the issue still persists, please share the exact activity name and package version being used.

Thanks Sayali.

4

Hi @mohammed_nawazuddin1

Before you are going to use SharePoint activities, you need to first create the connection by using integration services.
To connect integration services refer below video,
After successfully connection you can download the excel file from SharePoint and you can whatever actions that you need to perform on excel.

OR

You can office365 activities as well to read the excel from SharePoint. install office 365 package then you can see set of activities under Office 365

17794781433055458469681728677816
17794781433055458469681728677816375×367 5.25 KB

Happy automation
Yk

5

Hello All,

As suggested I tried to connect with Integration services but in my client UiPath orchestrator I dont have that option to create connection. Also I dont have the attached 9 dots to select integration services as attached in screenshot in my client orchestrator.

Connection
Connection305×162 7.34 KB

Could you suggest any other approach to read excel file from sharepoint.

Thanks,
Nawaz.

6

It seems that you are using an on-premise orchestrator, which doesn’t have the Integration Service.

In that case, you are limited in using the UiPath.MicrosoftOffice365.Activities package, and you need to have an Azure App registration configured to work with Sharepoint activities.

7

Hi @mohammed_nawazuddin1

When you use modern SharePoint activities like Get File/Folder, they require an active Integration Service connection.

To fix this, go to Automation Cloud → Integration Service, create a connection for Microsoft 365 / SharePoint, and sign in with your account. After that, come back to UiPath Studio and select this connection in your activity. If Integration Service is not available in your tenant, then you need to either enable it or use classic SharePoint/Office 365 activities with credentials instead.

8

@mohammed_nawazuddin1

Is your on prem or cloud?

In cloud connections are moved to orchestrator folders itself so you can create there

If on prem then you can use app id secret or any other auth without integration services as well

Cheers