Unanswered

Using Power Automate to download hourly data

(0) Share

Report

Posted on by C_ARMSTRONG

Hi all,

I'm just starting with Power Automate. I download csv data from a website daily for work and want to figure out how to automate it with Power Automate. The website requires me to put in the data and format of data, as shown below before clicking on downloading the CSV file. What would be my best approach for this? Thanks

Categories:

Power Automate Desktop

I have the same question (0)

All responses (8)

Answers (0)

Sort by

UK_Mike on at

Like
a
(0)

Report
Copy link

Link copied!

" Populate text field on webpage ", one action per ui element.
Text to populate = Todays Date ?
I use PA (cloud version) to call the desktop on the hour, 8 hours a day, 5 days a week.

Was this reply helpful? Yes No
C_ARMSTRONG 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hye mike thanks for the response, The issue is it's calendar-based so when you select the data its through an actual calendar layout as shown below, I'm also not sure how to actually utilize values such as Current time and date in the UI flow.

Was this reply helpful? Yes No
UK_Mike on at

Like
a
(0)

Report
Copy link

Link copied!

Well current date etc is the easy part.
Write 2/13/22 in a text file etc, try copy and paste manually into that first text box, it may accept it without having to mess about with the calendar dropdown, worth a shot...

Was this reply helpful? Yes No
C_ARMSTRONG 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Good idea, Ill see if that works!

Was this reply helpful? Yes No
C_ARMSTRONG 8 on at

Like
a
(0)

Report
Copy link

Link copied!

If I use the current date function I would then have a flow variable for the CurrentDateTime. What would be the next function to make it into a text file that works with a variable? Because I essentially want this to run every hour every day so I want to automate it entirely.

Was this reply helpful? Yes No
UK_Mike on at

Like
a
(0)

Report
Copy link

Link copied!

Well the current date var is the input to type into the website textbox, thats your first mission.
Every hour / every day is mission 2, thats the easy one...

Edit : Convert datetime to text action, if that was the question 😁

Was this reply helpful? Yes No
C_ARMSTRONG 8 on at

Like
a
(0)

Report
Copy link

Link copied!

I actually figured out a better way to get around the time issue, now my problem just seems to be downloading the file and placing it in the right folder.

Was this reply helpful? Yes No
UK_Mike on at

Like
a
(0)

Report
Copy link

Link copied!

Well there are actions to download a file, more than one...
What have you tried ?

Was this reply helpful? Yes No