Excel file download and upload in SharePoint List after filtering the list

Help Activities
, ,
1

Dear ALL ,

I have created Sharepoint connector to UiPath instance and using Get list item activity in Microsoft office package to extract the list data from sharepoint list but unable to get the needed file to download using Find Folder activity as it extracts the file directly from the sharepoint list without filtering the list.

So I am unable to send the results of Get list filtered value to download the excel file using find file activity.

Please help to resolve the issue.
Thanks in advance.

2

Are you getting any error?

3

Hi ,

No Error. I was telling that the download file activity can download file from document library but I need to perform filter in the custom column in the sharepoint list before download. how to perform both the actions by the bot .

Thanks

4

Must appreciate on any help in resolving the issue . Still figuring out the resolution.

5

Hello @Rajna ,

If you are using the activity from the below documentation,

Then ideally output will be populated as a data table. To filter the data table you can make use of ‘Filter Data Table activity’.

Thanks,
Gautham.

6

You should use the “Get List Items” action in UiPath to retrieve SharePoint list items. You can then use a loop to iterate through each element of the list and get a link to the file. Then using this link you can download the file and upload it.