Editing an excel sheet directly on Sharepoint

Help Studio
, ,
1

Hello,
I need to edit an Excel file directly on sharepoint. I am using microsoft office 365 scope and inside Find files and folders. But I am getting an error: Find Files And Folders: Code: generalException Message: Unexpected exception returned from the service. ClientRequestId: 4089e4f5-077b-4abe-890d-75cf4fb07cb5

The link for the file is: https://jobco-my.sharepoint.com/:x:/g/personal/mary_mack_jobco_com/EbWhx4VABgNMs8sQTLT5nTcBwkWqg165E1VgcqFPWKT0Ag?e=VuZaOD

Images of my activities are below. what do I need to do to edit directly? I will need to insert columns and delete sheet tabs on this excel file that is on the sharepoint

Thank you

This image shows a UiPath workflow setup with a Microsoft 365 Scope activity containing a "Find Files and Folders" activity, with its properties pane open and some fields filled out. (Captioned by AI)
This image shows a UiPath workflow setup with a Microsoft 365 Scope activity containing a "Find Files and Folders" activity, with its properties pane open and some fields filled out. (Captioned by AI)1692×687 82.3 KB

image
image1614×717 79.4 KB

2

@meghan.myers

please check and fill the fields proeprly

looks like drive name and all are wrong

please fill them proeprly

cheers

3

@meghan.myers,

Follow this knowledgebase.

4

How are they wrong? What should it be?

5

@meghan.myers

open the folder it is in proeprly in web and check the details

generally the first part till next for of sites in url will be the site url and the immediate next one would be drive name following with folders etc

general strcuture
https://www.sharepoint.com/sites/Sitename/Documentlibrary/Folder1/folder2/file

as per url might be till mary_mack_jobco_com might be the site url

cheers

6

you will need to find the file the same activity you use
then you can get output as one file or more, make sure which file you want to use by checking name loop through the list or array of files output

then in Microsoft package365 you are using there is more activity to append range the file, write range and so more the same like excel activities

7

Hi @meghan.myers

Try using the “Use Excel File” activity instead of “Find Files and Folders” if you already have the URL to the file. If you must search for the file dynamically ensure that the folder path and drive names are configured correctly and the user account you’re using with UiPath has the necessary permissions (read/write access) to access and modify the file in SharePoint.

Ensure Microsoft Office 365 Scope is properly configured with the right Application ID, Tenant ID and the User Account has access.