Google Drive search not returning results in all cases

Help
,
1

I am using the Gsuite Activity to do a search on google drive. I am wanting to search for a file that is named “This_is_the-file_name_20190722”

When i do a search using the string “name contains ‘This_is_the-file_name’” no results are returned. however if i use “name contains ‘This_is_the-file’” it will find the file and same if i search for name contains ‘This_is_the’"

Is there a reason why it is not finding the file if i do a search for the full name before the date? (This_is_the-file_name), it seems to have something to do with the -, but i cant find a way around it. Can any one make some suggestions for a workaround that will allow me to search for the full file name, minus the date?

2

Hi
Welcome back to UiPath community

May be that file alone might have such name
As it seems like the condition
Contains(“This_is_the-file”) works
And

To search for the date
Try like this in the Contains like
Yourfilenamevariable.Contains(Now.ToString(“yyyyMMdd”))

This will search for the current dates file

Hope this would help you
Cheers @Kevin_Schenk

3

@Palaniyappan

Thank you for your response, how ever i am not having a problem returning the date, my concern is that if i search for “This_is_the-file” it works, but “This_is_the-file_name” does not (see attached image for clarification)

uipathRuns
uipathRuns1512×2230 253 KB

4

Fine
Among the two files second one is a excel file with extension .xlsx
While what is the extension of the first file
I didn’t have any extension
Cheers @Kevin_Schenk

5

@Palaniyappan

The file is a google sheets file, no extensions are listed for these files on google drive.

6

Fine
May I know what is the type argument mentioned in the for each loop with input results (first loop)

@Kevin_Schenk

7

@Palaniyappan,

The type is Google.Apis.Drive.v3.Data.File