
Announcements
Greetings to all forum members,
I am seeking guidance on creating a workflow that retrieves data from the following website: https://it.investing.com/currencies/usd-eur-historical-data and imports it into Excel.
Specifically, I'm facing a challenge when it comes to setting a custom date range in the datebox, instead of using the default date range provided by the website.
For example, I want to set the date range from 01.01.2021 to the current date, rather than the default range of the current month, as currently displayed (02.10.2023 to 30.10.2023).
Could anyone advise me on how to create this workflow in Power Automate and which specific actions I need to include or configure?
Your assistance and insights are greatly appreciated.
Thank you!
@KunZ23
One way would be if the URL reflected changes in the table however the table seems to be framed in and the URL does not change.
You would need to use PAD to put data into the field...I don't think there is a way to do this with Power Automate cloud unfortunately.