Microsoft Office 365 Scope With Out Integration Service

Help Integration Service
,
1

Hello,

Trying to get the file or folder names in a SharePoint site. I am able to connect using Azure App to the SharePoint site, but did not figure out on how I can write down or navigate those files or folders. I used the For Each File or Folder activity and all I could get is the number of folders in a variable. How can I get the folder names?

I am using the activity UiPath.MicrosoftOffice365.Activities.Files.ForEachFileFolderConnections inside the UiPath.MicrosoftOffice365.Activities.Office365ApplicationScope.

When I used the activity UiPath.MicrosoftOffice365.Activities.Files.ForEachFileFolder and give all the required details, it says access denied.

Wondering how I can put images in to the post for better understanding.

Thank you,
Hari

2

Hi @harikp

are you able to show how you have configured the activity?

for eg
for each driveitem in this activity, you can get the name of that folder/file by using driveitem.Name

3

Sorry. I have updated my initial post with more details. Pls check.

4

Access denied error usually means your azure app doesn’t have the required permissions. How are you connecting to o365 scope? using app id and secret? or any other auth type?

For this, you can simply take screenshot and uplod an image here. mask any confidential data(if present) before uploading.

5

Site URL given as “https://XXXXXX.sharepoint.com/sites/XXXXXX/Shared%20Documents/Forms/AllItems.aspx”

image
image1435×681 39.7 KB

This Write Line prints the number of folders present in the Documents library.

But the below activity gives me error as access denied when the Site URL is given as https://XXXXXX.sharepoint.com/sites/XXXXXX. If the same above URL is used, it says the request is malformed or incorrect.

image
image1442×867 57.3 KB

Thank you,
Hari

6

Hi @harikp

The second screenshot, you are doing it correctly.

Please note:

  1. site url only comes till sites/xxx
  2. under document library, you need to provide “Shared Documents”
7

@harikp

Welcome to the community

  1. For app id and secret connection giving account value is mandatory please provide a valid email that ha access
  2. Try with shared docuemnts to know exact name go to sharepoint site and check the name of the documents library
  3. In the folder field I hope there is only single folder

Cheers