How to Write Data in Sharepoint File Excel

Help Studio
1

I would like to write the data to sharepoint Excel file from local file. here the challange is in the sharepoint file is provite not public link.
I have tried to use the Excel application scope but since the file is private then how can i access it via UiPath studio.
Please help me on this…!!

2

Hi @Niyas_Kallamveettil ,
You have microsoft 365 activities for accessinbg sharepoint…please use them…you need credentials for them which your admin team cn create and provide to you

https://docs.uipath.com/activities/docs/office365-setup

https://docs.uipath.com/activities/docs/microsoft-office-365-scope

regards,
LNV

3

Hello @Niyas_Kallamveettil, try something like this:

  1. Use UiPath HTTP Request activity to make an authentication request to get an access token using MSAL.
  2. With the obtained access token, use UiPath HTTP Request activity to make API requests to update the Excel file in SharePoint.
  3. Handle authentication and API request errors with appropriate error-handling activities in UiPath.
  4. You might need to consult Microsoft Graph API documentation for details on how to format your API requests for Excel operations.

Hope it helps,
Cheers! :slight_smile: