How to do Web Automation in Power Automate Desktop
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” […]
Table of Contents
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