Return file name for files within Google Drive folder

[Shane_Curran]

Hi all,

I’m able to find a folder ID and return the names of folders within this folder ID, but it doesn’t return other files in this folder, only sub-folders.

How would I go about returning all file names.

I use a Find files and folders activity to return the folder ID to the ToUploadFolderFileList variable. Then I use the assign below to return list of files within the folder ID, but at the moment it only returns other folder.

ToUploadFileList = String.Join(“,”,ToUploadFolderFileList.AsEnumerable().Where(Function(s) s.MimeType.Contains(“application/vnd.google-apps.folder”)).Select(Function(a) a.Name))

Any help is appreciated,
Thanks!

[Gokul001 (Gokul Balaji)]

HI @Shane_Curran

Check out this tutorial

Know about G Drive steps 1

Hello Everyone Let’s Learn and Let Learn. Checkout this for knowing about working with G Drive Activities First we will do the required set up okay…,

Now checkout the steps and do the required setup also leaving a video so that you can check that too

<a href="https://forum.uipath.com/t/g-suite-guidelines/474146" class="inline-onebox">G-Suite Guidelines</a> <a href="https://www.youtube.com/watch?v=okrKQemOKN0" class="inline-onebox">How …

Regards
Gokul

[Sudharsan_Ka]

@Shane_Curran

application/vnd.google-apps.folder

Hi @Shane_Curran

The expression used will return only the folders try the below to get the files

String.Join(“,”,ToUploadFolderFileList.AsEnumerable().Where(Function(s) Not s.MimeType.Contains(“application/vnd.google-apps.folder”)).Select(Function(a) a.Name))

Regards
Sudharsan

[Shane_Curran]

Great, works perfectly! Thanks!