Retrieving Custom Column data from Sharepoint files in Studio

Help Studio
, , ,
1

Hello, I am building a process that uses files stored in Sharepoint and I want to read a custom column like this

image
image1243×283 27.4 KB

at the moment I am using a For Each File or Folder 365 activity that works correctly and outputs a currentItem with O36DriveRemoteItem but I cannot see anywhere in that currentItem my Custom Column data. I would appreciate any feedback, thank you :slight_smile:

2

Hi @idoia.fernandez

You can use Get List Item activity inside your For Each File/Folder loop. Then can you try to get output like below:

listItem.Fields(“Upload Type”).ToString

Regards.

3

Hi Tolga,

I can only find this activity for Sharepoint Lists

image
image318×281 7.97 KB

what I am using is a library with files, I can only see these activities for them

image
image281×525 7.76 KB

4

The activty is there. But you must add Integration Service connection to use it.

image
image310×282 9.86 KB

5

yes, but that is for a Sharepoint List and Im not using one

6

@idoia.fernandez

Try with get file or folder meta data activity inside your loop

Cheers

7

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