Can anyone help me on downloading a dynamic name excel report from a website?

Help Activities
, ,
1

Hi, I am trying to download an excel file according to the current month from a sharepoint site where its located. I tried to use click activity and several other options but the selector is dynamic for the report name each month and needs to be selected through a radio button. Attaching the screenshot for the reference. Please help me with a method to download it each month?

image
image1156×635 42.5 KB

2

Hi @Gaurav_Dhyani

Assuming that you can check the radio button for a file & click the download button to download each file, you can use Find Children activity to get the attribute associated with each file present in the UI block. Once you have the list (or array) of the attribute, you can iterate through each of them & click download.

A little R&D might be required, hope this helps.
Best Regards.

1 Like
3

@Gaurav_Dhyani

Welcome to the community

Firstly please if possible try using office 365 activities which can do this job from backend

And coming to front end way…We can use the search panel at the top and search for the filename after you are on the folder…then only one result will pop and it would be easy to download…And as we know the format of naming we can search for "Employe Census Report (" Now.ToString("MM-yyyy") + ").xlsx"

Alternately you can use this in the innertext property as well the selector looks like this

Can be stored in variable var = "Employe Census Report (" Now.ToString("MM-yyyy") + ").xlsx"

Then selector

Eg; <webctrl tag='div' innertext="*{{var}}" />

Hope this helps

cheers

1 Like
4

Thanks for the suggestion.

5

@Anil_G Thanks alot, this idea works for me.

1 Like
6

@Gaurav_Dhyani

Happy Automation.

Please mark solution if resolved so that others with similar question will find it, else happy to help

Cheers