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” […]

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

https://youtu.be/dE5EtMJ0Ksc

Write a comment