Flow / Power Automate - Retrieve Data from a Web Page and Include it in Excel Tutorial

Learn how to use Power Automate Desktop to extract information from a website and transfer it into an Excel spreadsheet. With a step-by-step tutorial, you'll create a flow, customize variable names, and initiate a loop to delete and retrieve web data. Discover how to efficiently automate the process, saving you from multiple manual operations. Watch the tutorial now to streamline your data extraction and management tasks!

04:35
11 views

Available in Microsoft365

00:00:03

we will learn how to use power automate desktop to extract

00:00:07

information from a website and transfer it into an Excel spreadsheet

00:00:13

to start create a new flow in power automate desktop.

00:00:16

Since the flow is more complex, there are no predefined templates.

00:00:20

So we will begin with a blank canvas

00:00:23

name your flow and confirm

00:00:27

once in the canvas space filter,

00:00:29

the action column on the left and list the browser actions.

00:00:33

The first action is to open Microsoft edge in our case,

00:00:37

dragon drop the action and enter the URL of the desired platform by

00:00:41

choosing to open it in expanded mode equivalent to a maximized window.

00:00:46

Next move to the Excel actions to open your target file

00:00:52

which in this example is on the synchronized onedrive.

00:00:56

Each action will generate one or more auto named variables.

00:01:00

It is advisable to customize the variable names

00:01:03

for easier flow maintenance and element identification.

00:01:07

For this tutorial,

00:01:08

we will customize only a few variable names by double clicking on them

00:01:12

to allow multiple executions of the flow.

00:01:14

Make sure to clear the content of the

00:01:16

Excel table before injecting updated data into it.

00:01:20

Add an action to read the table content by retrieving data from

00:01:24

the file and storing it in a variable named Excel data.

00:01:28

This will allow for initiating a loop to delete each row,

00:01:33

initialize the loop variable at two to start from the second row

00:01:37

and set the loop end at the count of rows in the Excel data variable.

00:01:42

For example, if your file contains 50 rows,

00:01:45

you will need to create 49 deletion loops.

00:01:48

The header row being preserved,

00:01:51

add the Excel row,

00:01:52

deletion action which will delete row two at each loop and do this 49 times.

00:01:58

If your file contains 50 rows

00:02:02

to retrieve web data, use the extract data from web page action.

00:02:08

Once in the properties window switch to the

00:02:11

previously opened browser page on the web URL

00:02:14

A power automate web assistant should appear

00:02:17

when hovering over page elements.

00:02:19

A red box delimiting a detected area will appear right, click and select

00:02:24

extract element value. Then text

00:02:28

repeat this action three times on the items to be retrieved corresponding

00:02:32

to the columns of the Excel file trainer name and details.

00:02:39

Power automate will automatically detect recurring elements on the entire

00:02:43

page saving you from individually clicking on each block.

00:02:47

This is also visible in the power automate preview.

00:02:51

Then

00:02:52

define the navigation arrow at the bottom of the page as the page selector

00:02:59

next set the number of pages to process to capture the first five pages.

00:03:04

The data will be stored in a variable named data from web page.

00:03:10

You can now write this data into your spreadsheet.

00:03:17

Starting from cell A two first column, second row,

00:03:22

add an action to automatically resize the columns based on the data present,

00:03:30

finalized by closing Excel

00:03:35

and your browser instance.

00:03:40

Save the flow, then test it.

00:03:45

You will see on your screen that actions are being performed.

00:03:50

And after a few seconds, you can verify that your Excel file is correctly populated.

00:03:57

To have the option of choosing the number of pages to extract,

00:04:00

initialize an input dialogue box.

00:04:02

At the beginning of the flow,

00:04:05

customize the title and content

00:04:09

in the web extraction action,

00:04:10

replace the value for the number of pages to

00:04:13

extract with the one entered in the dialogue box.

00:04:17

Test the flow again to ensure everything works correctly.

00:04:21

By following these steps,

00:04:22

you can efficiently extract information from your website

00:04:25

and transfer it into an Excel spreadsheet,

00:04:28

saving you from numerous manual copy paste operations.

DiLeaP AI: THIS MIGHT BE HELPFUL

Teams Premium - Activate the features of Teams Premium

In this video, you will learn how to activate the features of Teams Premium.
The video covers the necessary steps to fully enjoy all that Teams Premium has to offer.
It explains that Teams Premium requires an additional paid license, which must be assigned to a user in Microsoft 365 administration.
The video demonstrates how to join the admin and access the team-specific admin center, where you can manage Teams settings such as meetings, webinars, messaging, and security.
It also highlights the administration app in the Teams navigation menu, which includes a dashboard with additional settings.
To access the new features specific to Teams Premium, you can find them directly in your Teams application.
If some features don't appear, it is recommended to restart Teams and check for software updates.
Activating Teams Premium will enhance your Teams experience and provide access to advanced features.

3:48
10763 views

Outlook - How do I share a document securely with Outlook?

In this video, you will learn how to securely share a document with Outlook.
Instead of attaching the document to your email, it is safer to add it to your OneDrive or SharePoint library.
This allows you to set permissions for who can view and edit the document.
When you share the link to your document from Outlook, the permissions you set in OneDrive or SharePoint are retained.
You can easily change the sharing permissions in the attachment drop-down menu.
Regularly checking and updating the permissions ensures the safety of your document.
This tutorial will help you securely share documents using Outlook in Microsoft 365.

1:49
2900 views

Project Online - Discovering the interface

In this video, you will learn about the intelligent search feature in Microsoft 365. The video covers the search tools in Microsoft 365, including searching on your computer, using Microsoft Search, finding content and people in SharePoint, searching your emails, and more.
This will help you save time and easily find documents, information, and people within the Microsoft 365 suite.

4:51
4293 views

FindTime - Create a scheduling poll

Discover how to create a meeting poll in this video titled "Creating a scheduling poll" This resource is designed for intermediate-level learners looking for effective ways to communicate and manage their time.

You will learn how to create an interactive poll to gather opinions and preferences from meeting participants. This skill will enable you to facilitate decision-making and organize more productive meetings.

Don't miss this opportunity to enhance your communication and time management skills.

4:12
4111 views

Outlook - How do I recognize a fraudulent email?

In this video, you will learn how to recognize a fraudulent email and protect yourself from phishing attacks.
Phishing emails often mimic legitimate ones, using logos and information from reputable companies.
However, there are usually spelling errors, a haphazard layout, or inconsistencies with the company's graphic design.
Pay attention to the sender's email address, as it may not match the company's domain.
Be cautious if the sender's name consists of random letters and numbers.
Avoid clicking on links that ask you to renew your account or provide personal or banking information.
Even clicking on a link can install malware on your computer.
If you have any doubts, contact the company using secure contact information from their official website.
This knowledge will help you stay safe online and protect your personal information.

2:01
2567 views

RELATED COURSES This tutorial is part of the following courses

Microsoft Video Training Power Automate – From discovery to mastering automation

Boost your productivity with our Power Automate course! Learn to automate your tasks and seamlessly integrate various Microsoft 365 services.

Your trainer for this course
Cours E-learning

3 Views

ALL COURSES