cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Automate Chrome Data Download

Hi Community,

 

I just came to know about automate from Microsoft. I am interested to download data from the following website .
 
 
Here I wish to download data for each state, for each district from 1-Jan-2010 til 31-Dec-2019 at 1 month interval. Here maximum allowed difference between 2 consecutive dates is 1 month.
 
I wish to download the data as excel files which I can then extract data from file using power query in excel.
 
Kindly guide me with the above for step-by-step tutorial and show me the power of Automate.
11 REPLIES 11

Hi @Anonymous 

 

Is there an API that you can connect to for the mentioned site and get the data? If so, you can use an HTTP action to invoke the api and get the data 

 

Else, you might want to create a UI Flow and record steps to download the data and then perform the consecutive actions. 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Anonymous
Not applicable

Hi @yashag2255 ,

 

I don't know about API. Kindly have a look at the link I provided earlier and guide me to do the required steps.

 

Regards

Hi @Anonymous 

 

If there is no API, then you can use UI Flows of type web for this. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Anonymous
Not applicable

Hi @yashag2255

I don't know how to use power automate for web.

Kindly take my example case and show step wise if possible.

Regards

Hi @Anonymous 

 

You can follow the tutorial here to get started on this: https://www.youtube.com/watch?v=OJLoypP78Ak

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Anonymous
Not applicable

Hi  @yashag2255 

 

Thanks for the video link.

 

I followed the video. My query is different. Here is the Screenshot of the Web page

 

Mfms Wholesaler sales Landing page.jpg

 

 

 

 

 

 

 

 

 

 

 

 

I wish to do the following:

 

  1. Open the website: https://reports.dbtfert.nic.in/mfmsReports/GenCompanySaleDashboardListing
  2. Select State Name: Punjab
  3. Select District Name: Amritsar
  4. Select From Date: 1-Jan-2010
  5. Select To Date: 31-Jan-2010 (Maximum allowed difference between 2 dates is 1 Month)
  6. In option
     
     Select “View” View as opiton MFMS.JPG

     

  7. Upload the data shown (from all the pages of the viewed data shown) from Webpage to a google drive file.
  8. Or Download the data as excel and Automate to copy the data from downloaded file to google drive file.
  9. Repeat Steps 2&3
  10. Change From Date: 1-Feb-2010 (First day of next month)
  11. Change To Date: 28-Feb-2020 (Last date of next month)
  12. Repeat steps 6&7 and paste the new data below the previous pasted data.

Note:

1. The District Sequence must continue till the last district of the particular state. e.g. Tarn Taran for Punjab State

2. The dates sequence has to continue till 31-Dec-2019

Please guide how this can be done.

 

P.S.  @Jon Levesque. Pls guide in too.

Hi @Anonymous 

 

That is a very specific usecase that you are trying to build. You might want to refer more videos and material available to set up screen recording and then data scraping on the website for this one. 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Anonymous
Not applicable

@efialttes@abm

Pls guide

@Anonymous 

As @yashag2255 suggested, you should try UI Flows. The material he shared is a really good starting point

THanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



I have a similar case: Go to a webportal, login, navigate to document section, downlad and save a file on a network share.

 

With UI Flow I can record the interactions in the web (with the Selenium IDE), but it does not record the saving of the document. ANy ideas how to solve that?

 

Thank you,

Jerome

Anonymous
Not applicable

Hi,

 

Run the recorded flow again and press the Save button twice. Sometimes, Flow doesn't register it once.

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,686)