Intro

Always being automatically updated with currency rates is important and a perfect case for Microsoft Power Automate Desktop. Here’s how to do it.

Learning Objectives

• Geting started with Power Automate Desktop
• Automate browser work
• Automate Excel

Description

• Download the Excel book for the case
• Inspect the data in the sheet named “1. US dollars”
  • We want to fill in C2 and D2 – Date and Rate for US dollars
•  Create a robot in Power Automate Desktop, that
  • Navigate to https://nationalbanken.dk/en
  • Click “More currencies”
  • Scrape the US dollar rate and the date for the rate
  • Write the results back to Excel

Hints

• Creating a variable for the project path is best practice
  • It’s then easy and robust, when we choose to more the folder

Video Guide