Get multiple files based on list of file info

Help Activities
, , , , ,
1

Hello everyone, I’m trying to download some files from other portals.so, when downloading I’m using activity called wait for download

In this activity , In the monitored folder node ( the path is indicated) and in the downloaded file ( I’m retrieving file info )

Next I’m adding the file info.fullname ( to the collection )

So now I have a list of file info save in a variable of type (list, string)

Now, I need to retrieve all these multiple files based on the list of file info that I have and merge into one excel and save the information of the merged Excel file to a variable.

Can anyone help how to retrieve multiple files based on the list of file info that I have ??

Thank you so much.

2

@vinni_s1,

Use below LINQ to get all file names into an array.

fileNamesArray = (From file In filesList Select file.Name).ToArray()

Thanks,
Ashok :slight_smile:

3

Hello @ashokkarale I have already stored all the file info.names into a variable to type( list string)

So, it means I have all the files paths that I need now I need to read one particular column value from each file and save that data into one variable and then delete these files.

4

@vinni_s1,

Ok, I assume you have the files in excel format. Follow these steps.

  1. Declare a string variable outside of the for each
  2. Use for each file in folder activity
  3. Use Read Range workbook activity to read only particular column value
  4. Append the value to the variable declared at step 1.
  5. Delete the file

You will have the final result in step 1 variable.

Thanks,
Ashok :slight_smile:

1 Like
5

Thank you @ashokkarale . But, can’t find for each file in Folder activity.

6

@vinni_s1 ,

Remove filter from activity panel if any. It should be there.

I’m talking about this.

Thanks,
Ashok :slightly_smiling_face: