web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Creating a Power Autom...
Power Automate
Unanswered

Creating a Power Automate flow to extract custom data from website.

(0) ShareShare
ReportReport
Posted on by

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_1-1698669817121.png

 

 

Categories:
I have the same question (0)
  • AlexEncodian Profile Picture
    4,409 Moderator on at

    @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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 323 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 183 Most Valuable Professional

Last 30 days Overall leaderboard