VAT Lookups with Power Automate Desktop
Intro Doing VAT lookups on a web page is a typical RPA case. Here’s how to solve it. Learning Objectives Read and write in Excel Web searches Web scraping Description Download the Excel book with sample data Navigate to https://datacvr.virk.dk and click on English in the upper right corner For each row Do a CVR […]
Table of Contents
Intro
Doing VAT lookups on a web page is a typical RPA case. Here’s how to solve it.
Learning Objectives
- Read and write in Excel
- Web searches
- Web scraping
Description
- Download the Excel book with sample data
- Navigate to https://datacvr.virk.dk and click on English in the upper right corner
- For each row
- Do a CVR lookup at https://datacvr.virk.dk
- Fill in the blank columns (except status) by doing a web scrape of the CVR lookup page
- Write the result back to Excel
- Error handling
- Try to add a row in the Excel sheet with the CVR 12345678. Handle the error.
- Log column: Write either Succesful or Failed
Hints
- Use an On block error activity for the error handling