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

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
  • 402 views

Objectifs :

This tutorial aims to teach users how to utilize Power Automate Desktop to extract information from a website and transfer it into an Excel spreadsheet, streamlining data management and reducing manual entry tasks.

Chapitres :

  1. Introduction to Power Automate Desktop
    In this tutorial, we will learn how to use Power Automate Desktop to extract information from a website and transfer it into an Excel spreadsheet. This process will help automate data collection, making it more efficient.
  2. Creating a New Flow
    To start, create a new flow in Power Automate Desktop. Since the flow is more complex, there are no predefined templates available, so we will begin with a blank canvas. Name your flow and confirm your choice.
  3. Setting Up the Canvas
    Once in the canvas space, filter the action column on the left to list the browser actions. The first action is to open Microsoft Edge. Drag and drop this action onto the canvas and enter the URL of the desired platform, choosing to open it in expanded mode (maximized window).
  4. Opening the Excel File
    Next, move to the Excel actions to open your target file, which in this example is synchronized with OneDrive. Each action will generate one or more auto-named variables, but it is advisable to customize these variable names for easier flow maintenance and element identification.
  5. Customizing Variable Names
    For this tutorial, we will customize only a few variable names by double-clicking on them. This allows for multiple executions of the flow. Make sure to clear the content of the Excel table before injecting updated data into it.
  6. Reading Table Content
    Add an action to read the table content by retrieving data from the file and storing it in a variable named 'Excel data'. This will allow for initiating a loop to delete each row. Initialize the loop variable at two to start from the second row and set the loop end at the count of rows in the 'Excel data' variable.
  7. Deleting Rows
    For example, if your file contains 50 rows, you will need to create 49 deletion loops, preserving the header row. Add the Excel row deletion action, which will delete row two at each loop, repeating this 49 times.
  8. Extracting Web Data
    To retrieve web data, use the 'Extract data from web page' action. Once in the properties window, switch to the previously opened browser page. A Power Automate web assistant should appear when hovering over page elements, with a red box delimiting a detected area.
  9. Selecting Elements to Extract
    Right-click and select 'Extract element value' for the desired items. Repeat this action three times for the items to be retrieved, corresponding to the columns of the Excel file (trainer name and details). Power Automate will automatically detect recurring elements on the entire page, saving you from individually clicking on each block.
  10. Defining Navigation and Data Storage
    Define the navigation arrow at the bottom of the page as the page selector. Next, set the number of pages to process to capture the first five pages. The data will be stored in a variable named 'data from web page'.
  11. Writing Data to Excel
    You can now write this data into your spreadsheet, starting from cell A2 (first column, second row). Add an action to automatically resize the columns based on the data present, and finalize by closing Excel and your browser instance.
  12. Testing the Flow
    Save the flow and then test it. You will see on your screen that actions are being performed, and after a few seconds, you can verify that your Excel file is correctly populated.
  13. Customizing Page Extraction
    To have the option of choosing the number of pages to extract, initialize an input dialogue box at the beginning of the flow. Customize the title and content in the web extraction action, replacing the value for the number of pages to extract with the one entered in the dialogue box.
  14. Conclusion
    By following these steps, you can efficiently extract information from your website and transfer it into an Excel spreadsheet, saving you from numerous manual copy-paste operations. Test the flow again to ensure everything works correctly.

FAQ :

What is Power Automate Desktop used for?

Power Automate Desktop is used to automate repetitive tasks and workflows on your computer, allowing you to save time and reduce manual effort.

How do I create a flow in Power Automate Desktop?

To create a flow, open Power Automate Desktop, start with a blank canvas, name your flow, and then add actions from the action column to build your workflow.

Can I customize variable names in Power Automate?

Yes, it is advisable to customize variable names for easier flow maintenance and element identification. You can do this by double-clicking on the variable names.

How do I extract data from a website using Power Automate?

You can extract data by using the 'Extract Data from Web Page' action, selecting the elements you want to retrieve, and defining the navigation for multiple pages if needed.

What should I do if my Excel file is not updating correctly?

Ensure that you clear the content of the Excel table before injecting updated data and check that your flow is correctly configured to read and write data.

Is it possible to choose the number of pages to extract data from?

Yes, you can initialize an input dialogue box at the beginning of the flow to allow users to specify the number of pages to extract.

Quelques cas d'usages :

Automating Data Entry from Web to Excel

A marketing team can use Power Automate Desktop to extract customer data from a website and automatically populate an Excel spreadsheet, saving time on manual data entry.

Monthly Reporting Automation

An analyst can set up a flow to extract sales data from a web portal and update an Excel report monthly, ensuring that the report is always up-to-date without manual intervention.

Data Cleanup and Management

A data manager can automate the process of cleaning up an Excel file by deleting unnecessary rows and updating it with fresh data from a website, improving data accuracy and efficiency.

Web Scraping for Market Research

A researcher can use Power Automate to scrape data from multiple web pages for market analysis, storing the results in Excel for further analysis and reporting.

Glossaire :

Power Automate Desktop

A Microsoft application that allows users to automate repetitive tasks and workflows on their desktop by creating flows.

Flow

A series of automated actions that are executed in a specific order to accomplish a task in Power Automate.

Variable

A storage location in programming that holds data that can be changed during the execution of a flow.

Excel Actions

Specific commands in Power Automate that allow users to interact with Excel files, such as opening, reading, and writing data.

Loop

A programming construct that repeats a block of code a certain number of times or until a condition is met.

Extract Data from Web Page

An action in Power Automate that allows users to retrieve specific information from a web page.

Input Dialogue Box

A user interface element that prompts the user to enter information, which can then be used in the flow.

Synchronized OneDrive

A cloud storage service from Microsoft that allows users to store files and access them from multiple devices.

résultat(s)
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.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:02
Neste tutorial,
00:00:03
vamos aprender a usar o power automate desktop para extrair
00:00:07
informação de um website e transferi-la para uma folha de cálculo do Excel
00:00:13
para começar a criar um novo fluxo no Power Automate Desktop.
00:00:16
Uma vez que o fluxo é mais complexo, não existem modelos predefinidos.
00:00:20
Então, vamos começar com uma tela em branco
00:00:23
nomeie o seu fluxo e confirme
00:00:27
uma vez no filtro de espaço da tela,
00:00:29
a coluna de ação à esquerda e lista as ações do navegador.
00:00:33
A primeira ação é abrir o Microsoft edge no nosso caso,
00:00:37
dragão solte a ação e insira o URL da plataforma desejada por
00:00:41
escolher abri-lo em modo expandido equivalente a uma janela maximizada.
00:00:46
Em seguida, vá para as ações do Excel para abrir o seu ficheiro de destino
00:00:52
que neste exemplo está no onedrive sincronizado.
00:00:56
Cada ação irá gerar uma ou mais variáveis com nomes automáticos.
00:01:00
Aconselha-se a personalização dos nomes das variáveis
00:01:03
para facilitar a manutenção do fluxo e a identificação dos elementos.
00:01:07
Para este tutorial,
00:01:08
personalizaremos apenas alguns nomes de variáveis clicando duas vezes neles
00:01:12
permitir múltiplas execuções do fluxo.
00:01:14
Certifique-se de limpar o conteúdo do
00:01:16
Tabela Excel antes de injetar dados atualizados nela.
00:01:20
Adicione uma ação para ler o conteúdo da tabela, recuperando dados de
00:01:24
o ficheiro e armazená-lo numa variável chamada dados do Excel.
00:01:28
Isto permitirá iniciar um loop para eliminar cada linha,
00:01:33
inicializar a variável de loop às duas para começar a partir da segunda linha
00:01:37
e defina o final do loop na contagem de linhas na variável de dados do Excel.
00:01:42
Por exemplo, se o seu ficheiro contiver 50 linhas,
00:01:45
terá de criar 49 loops de eliminação.
00:01:48
A linha de cabeçalho a ser preservada,
00:01:51
adicionar a linha do Excel,
00:01:52
acção de eliminação que irá apagar a linha dois em cada loop e fazê-lo 49 vezes.
00:01:58
Se o seu ficheiro contiver 50 linhas
00:02:02
para recuperar dados da Web, use a ação extrair dados da página da Web.
00:02:08
Uma vez na janela de propriedades, mude para a
00:02:11
página do navegador aberta anteriormente no URL da Web
00:02:14
Deve aparecer um assistente web power automatize
00:02:17
ao passar o mouse sobre os elementos da página.
00:02:19
Uma caixa vermelha delimitando uma área detectada aparecerá com a direita, clique e selecione
00:02:24
extrair o valor do elemento. Em seguida, texto
00:02:28
repita esta acção três vezes nos itens a recuperar correspondentes
00:02:32
às colunas do nome e detalhes do formador de ficheiros Excel.
00:02:39
O Power Automate detectará automaticamente elementos recorrentes na totalidade
00:02:43
página que o poupa de clicar individualmente em cada bloco.
00:02:47
Isso também é visível na pré-visualização do Power Automate.
00:02:51
Então
00:02:52
definir a seta de navegação na parte inferior da página como o seletor de página
00:02:59
em seguida, defina o número de páginas a processar para capturar as primeiras cinco páginas.
00:03:04
Os dados serão armazenados numa variável denominada data da página web.
00:03:10
Agora pode escrever estes dados na sua folha de cálculo.
00:03:17
A partir da célula A, duas primeiras colunas, segunda linha,
00:03:22
adicionar uma acção para redimensionar automaticamente as colunas com base nos dados presentes,
00:03:30
finalizado com o fecho do Excel
00:03:35
e a instância do seu navegador.
00:03:40
Salve o fluxo e teste-o.
00:03:45
Irá ver no ecrã que as acções estão a ser executadas.
00:03:50
E depois de alguns segundos, pode verificar se o seu ficheiro Excel está correctamente preenchido.
00:03:57
Para ter a opção de escolher o número de páginas a extrair,
00:04:00
inicializar uma caixa de diálogo de entrada.
00:04:02
No início do escoamento,
00:04:05
personalizar o título e o conteúdo
00:04:09
na acção de extração web,
00:04:10
substitua o valor do número de páginas para
00:04:13
extrair com o inserido na caixa de diálogo.
00:04:17
Teste o fluxo novamente para garantir que tudo funcione corretamente.
00:04:21
Seguindo estes passos,
00:04:22
pode extrair informações do seu website de forma eficiente
00:04:25
e transferi-lo para uma folha de cálculo do Excel,
00:04:28
poupando-o de numerosas operações manuais de copiar e colar.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:02
In questo tutorial,
00:00:03
impareremo come usare power automate desktop per estrarre
00:00:07
informazioni da un sito Web e trasferirle in un foglio di calcolo Excel
00:00:13
per iniziare, crea un nuovo flusso in power automate desktop.
00:00:16
Poiché il flusso è più complesso, non ci sono modelli predefiniti.
00:00:20
Quindi inizieremo con una tela bianca
00:00:23
assegna un nome al flusso e conferma
00:00:27
una volta nel filtro Canvas Space,
00:00:29
la colonna delle azioni a sinistra ed elenca le azioni del browser.
00:00:33
La prima azione è aprire Microsoft edge nel nostro caso,
00:00:37
trascina l'azione e inserisci l'URL della piattaforma desiderata con
00:00:41
scegliendo di aprirla in modalità estesa equivalente a una finestra ingrandita.
00:00:46
Quindi passa alle azioni di Excel per aprire il file di destinazione
00:00:52
che in questo esempio si trova su OneDrive sincronizzato.
00:00:56
Ogni azione genererà una o più variabili con nome automatico.
00:01:00
È consigliabile personalizzare i nomi delle variabili
00:01:03
per facilitare la manutenzione del flusso e l'identificazione degli elementi.
00:01:07
Per questo tutorial,
00:01:08
personalizzeremo solo alcuni nomi di variabili facendo doppio clic su di essi
00:01:12
per consentire più esecuzioni del flusso.
00:01:14
Assicurati di cancellare il contenuto di
00:01:16
Tabella Excel prima di inserirvi dati aggiornati.
00:01:20
Aggiungi un'azione per leggere il contenuto della tabella recuperando i dati da
00:01:24
il file e memorizzandolo in una variabile denominata dati Excel.
00:01:28
Ciò consentirà di avviare un ciclo per eliminare ogni riga,
00:01:33
inizializza la variabile loop a due per iniziare dalla seconda riga
00:01:37
e imposta la fine del ciclo in base al conteggio delle righe nella variabile di dati Excel.
00:01:42
Ad esempio, se il file contiene 50 righe,
00:01:45
dovrai creare 49 cicli di cancellazione.
00:01:48
La riga di intestazione viene mantenuta,
00:01:51
aggiungi la riga di Excel,
00:01:52
azione di cancellazione che eliminerà la seconda riga di ogni ciclo e lo farà 49 volte.
00:01:58
Se il file contiene 50 righe
00:02:02
per recuperare i dati web, usa l'azione estrai dati dalla pagina web.
00:02:08
Una volta nella finestra delle proprietà, passa a
00:02:11
pagina del browser aperta in precedenza sull'URL web
00:02:14
Dovrebbe apparire un assistente web power automate
00:02:17
quando si passa con il mouse sugli elementi della pagina.
00:02:19
Apparirà un riquadro rosso che delimita un'area rilevata, fai clic e seleziona
00:02:24
estrai il valore dell'elemento. Quindi testo
00:02:28
ripeti questa azione tre volte sugli elementi da recuperare corrispondenti
00:02:32
alle colonne del nome e dei dettagli del file Excel trainer.
00:02:39
Power automate rileverà automaticamente gli elementi ricorrenti sull'intero
00:02:43
pagina che ti evita di fare clic individualmente su ciascun blocco.
00:02:47
Questo è visibile anche nell'anteprima di power automate.
00:02:51
Quindi
00:02:52
definisci la freccia di navigazione nella parte inferiore della pagina come selettore di pagina
00:02:59
quindi imposta il numero di pagine da elaborare per acquisire le prime cinque pagine.
00:03:04
I dati verranno archiviati in una variabile denominata data from web page.
00:03:10
Ora puoi scrivere questi dati nel tuo foglio di calcolo.
00:03:17
A partire dalla cella A, due prime colonne, seconda riga,
00:03:22
aggiungi un'azione per ridimensionare automaticamente le colonne in base ai dati presenti,
00:03:30
finalizzato chiudendo Excel
00:03:35
e l'istanza del tuo browser.
00:03:40
Salva il flusso, quindi testalo.
00:03:45
Vedrai sullo schermo che le azioni vengono eseguite.
00:03:50
E dopo pochi secondi, puoi verificare che il tuo file Excel sia compilato correttamente.
00:03:57
Per avere la possibilità di scegliere il numero di pagine da estrarre,
00:04:00
inizializza una finestra di dialogo di input.
00:04:02
All'inizio del flusso,
00:04:05
personalizza il titolo e il contenuto
00:04:09
nell'azione di estrazione web,
00:04:10
sostituisci il valore del numero di pagine con
00:04:13
estrai con quello inserito nella finestra di dialogo.
00:04:17
Prova nuovamente il flusso per assicurarti che tutto funzioni correttamente.
00:04:21
Seguendo questi passaggi,
00:04:22
puoi estrarre in modo efficiente informazioni dal tuo sito web
00:04:25
e trasferiscile in un foglio di calcolo Excel,
00:04:28
risparmiandoti numerose operazioni manuali di copia e incolla.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:02
В этом уроке
00:00:03
мы узнаем, как использовать рабочий стол power automate для извлечения
00:00:07
информацию с веб-сайта и перенос ее в электронную таблицу Excel
00:00:13
чтобы начать создавать новый поток в настольных компьютерах power automate.
00:00:16
Поскольку процесс более сложный, нет готовых шаблонов.
00:00:20
Итак, мы начнем с чистого холста
00:00:23
назовите свой поток и подтвердите
00:00:27
попав в фильтр пространства холста,
00:00:29
столбец действий слева и список действий браузера.
00:00:33
Первое действие — открыть Microsoft edge в нашем случае,
00:00:37
dragon отбросьте действие и введите URL-адрес нужной платформы с помощью
00:00:41
выбрав открыть его в расширенном режиме, эквивалентном максимальному окну.
00:00:46
Затем перейдите к действиям Excel, чтобы открыть целевой файл
00:00:52
который в данном примере находится на синхронизированном OneDrive.
00:00:56
Каждое действие будет генерировать одну или несколько переменных с автоматическим именем.
00:01:00
Желательно настроить имена переменных
00:01:03
для упрощения обслуживания потока и идентификации элементов.
00:01:07
В этом учебном пособии
00:01:08
мы настроим только несколько имен переменных, дважды щелкнув по ним
00:01:12
чтобы разрешить многократное выполнение потока.
00:01:14
Обязательно очистите содержимое поля
00:01:16
Перед вводом в нее обновленных данных таблицу Excel.
00:01:20
Добавьте действие для чтения содержимого таблицы путем извлечения данных из
00:01:24
файл и сохранение его в переменной с именем «Данные Excel».
00:01:28
Это позволит запустить цикл для удаления каждой строки,
00:01:33
инициализируйте переменную цикла с двух, чтобы начать со второй строки
00:01:37
и задайте в качестве конца цикла количество строк в переменной данных Excel.
00:01:42
Например, если файл содержит 50 строк,
00:01:45
вам нужно будет создать 49 циклов удаления.
00:01:48
Сохраняемая строка заголовка,
00:01:51
добавьте строку Excel,
00:01:52
действие удаления, которое удалит две строки в каждом цикле и выполните это 49 раз.
00:01:58
Если ваш файл содержит 50 строк
00:02:02
для извлечения веб-данных используйте действие «Извлечь данные с веб-страницы».
00:02:08
В окне свойств переключитесь на
00:02:11
ранее открытая страница браузера на веб-URL-адресе
00:02:14
Должен появиться мощный автоматический веб-помощник
00:02:17
при наведении курсора на элементы страницы.
00:02:19
Появится красное поле, ограничивающее обнаруженную область, нажмите и выберите
00:02:24
извлеките значение элемента. Затем текст
00:02:28
повторите это действие три раза с соответствующими элементами, которые нужно извлечь
00:02:32
к столбцам имени и сведений о файловом тренере Excel.
00:02:39
Power Automate автоматически обнаружит повторяющиеся элементы в целом
00:02:43
страница, избавляющая вас от индивидуального нажатия на каждый блок.
00:02:47
Это также видно в предварительном просмотре power automate.
00:02:51
Затем
00:02:52
определите стрелку навигации в нижней части страницы в качестве средства выбора страниц
00:02:59
затем задайте количество страниц, которые необходимо обработать для захвата первых пяти страниц.
00:03:04
Данные будут храниться в переменной с именем data from web-страницы.
00:03:10
Теперь вы можете записать эти данные в электронную таблицу.
00:03:17
Начиная с ячейки A, два первых столбца, вторая строка,
00:03:22
добавьте действие для автоматического изменения размера столбцов в зависимости от имеющихся данных,
00:03:30
завершено закрытием Excel
00:03:35
и экземпляр вашего браузера.
00:03:40
Сохраните поток, а затем протестируйте его.
00:03:45
На экране вы увидите, что действия выполняются.
00:03:50
И через несколько секунд вы сможете убедиться, что ваш файл Excel заполнен правильно.
00:03:57
Чтобы иметь возможность выбрать количество страниц для извлечения,
00:04:00
инициализируйте диалоговое окно ввода.
00:04:02
В начале потока
00:04:05
настройте заголовок и контент
00:04:09
в действии извлечения информации из Интернета,
00:04:10
замените значение количества страниц на
00:04:13
извлечение на значение, введенное в диалоговом окне.
00:04:17
Еще раз проверьте поток, чтобы убедиться, что все работает правильно.
00:04:21
Выполнив следующие шаги,
00:04:22
вы можете эффективно извлекать информацию со своего веб-сайта
00:04:25
и перенесите ее в электронную таблицу Excel,
00:04:28
избавив вас от многочисленных операций копирования и вставки вручную.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:02
En este tutorial,
00:00:03
aprenderemos cómo usar Power Automate Desktop para extraer
00:00:07
información de un sitio web y transferirla a una hoja de cálculo de Excel
00:00:13
para empezar a crear un nuevo flujo en Power Automate Desktop.
00:00:16
Como el flujo es más complejo, no hay plantillas predefinidas.
00:00:20
Así que vamos a empezar con un lienzo en blanco
00:00:23
asigne un nombre a su flujo y confirme
00:00:27
una vez en el filtro de espacio del lienzo,
00:00:29
la columna de acciones de la izquierda y una lista de las acciones del navegador.
00:00:33
La primera acción es abrir Microsoft Edge en nuestro caso,
00:00:37
arrastra la acción e introduce la URL de la plataforma deseada mediante
00:00:41
eligiendo abrirla en modo expandido, equivalente a una ventana maximizada.
00:00:46
A continuación, pase a las acciones de Excel para abrir el archivo de destino
00:00:52
que en este ejemplo está en el onedrive sincronizado.
00:00:56
Cada acción generará una o más variables con nombre automático.
00:01:00
Es recomendable personalizar los nombres de las variables
00:01:03
para facilitar el mantenimiento del flujo y la identificación de los elementos.
00:01:07
Para este tutorial,
00:01:08
personalizaremos solo algunos nombres de variables haciendo doble clic sobre ellos
00:01:12
para permitir múltiples ejecuciones del flujo.
00:01:14
Asegúrese de borrar el contenido del
00:01:16
Tabla de Excel antes de inyectarle datos actualizados.
00:01:20
Agregue una acción para leer el contenido de la tabla recuperando datos de
00:01:24
el archivo y almacenándolo en una variable denominada datos de Excel.
00:01:28
Esto permitirá iniciar un ciclo para eliminar cada fila,
00:01:33
inicialice la variable de bucle en dos para empezar desde la segunda fila
00:01:37
y establezca el final del bucle en el recuento de filas de la variable de datos de Excel.
00:01:42
Por ejemplo, si el archivo contiene 50 filas,
00:01:45
tendrá que crear 49 bucles de eliminación.
00:01:48
La fila de encabezado que se conserva,
00:01:51
añadir la fila de Excel,
00:01:52
acción de eliminación que eliminará la fila dos en cada bucle y lo hará 49 veces.
00:01:58
Si su archivo contiene 50 filas
00:02:02
para recuperar datos web, utilice la acción extraer datos de la página web.
00:02:08
Una vez en la ventana de propiedades, cambie a
00:02:11
página de navegador previamente abierta en la URL web
00:02:14
Debería aparecer un asistente web de Power Automate
00:02:17
al pasar el ratón por encima de los elementos de la página.
00:02:19
Aparecerá un cuadro rojo que delimita el área detectada con el botón derecho, haga clic y seleccione
00:02:24
extraer el valor del elemento. Luego envía un texto
00:02:28
repita esta acción tres veces en los elementos a recuperar correspondientes
00:02:32
a las columnas del nombre y los detalles del entrenador de archivos de Excel.
00:02:39
Power Automate detectará automáticamente los elementos recurrentes en todo el sistema
00:02:43
página que evita que hagas clic individualmente en cada bloque.
00:02:47
Esto también está visible en la vista previa de Power Automate.
00:02:51
Entonces
00:02:52
defina la flecha de navegación en la parte inferior de la página como selector de páginas
00:02:59
a continuación, defina el número de páginas a procesar para capturar las cinco primeras páginas.
00:03:04
Los datos se almacenarán en una variable denominada data from web page.
00:03:10
Ahora puedes escribir estos datos en tu hoja de cálculo.
00:03:17
A partir de la celda A, la primera columna, la segunda fila,
00:03:22
añadir una acción para cambiar automáticamente el tamaño de las columnas en función de los datos presentes,
00:03:30
finalizado cerrando Excel
00:03:35
y la instancia de su navegador.
00:03:40
Guarde el flujo y, a continuación, pruébelo.
00:03:45
Verá en la pantalla que se están realizando las acciones.
00:03:50
Y después de unos segundos, podrás comprobar que tu archivo de Excel está correctamente rellenado.
00:03:57
Para tener la opción de elegir el número de páginas a extraer,
00:04:00
inicialice un cuadro de diálogo de entrada.
00:04:02
Al principio del flujo,
00:04:05
personaliza el título y el contenido
00:04:09
en la acción de extracción web,
00:04:10
sustituya el valor por el número de páginas por
00:04:13
extraiga por el introducido en el cuadro de diálogo.
00:04:17
Vuelva a probar el flujo para asegurarse de que todo funciona correctamente.
00:04:21
Al seguir estos pasos,
00:04:22
puede extraer información de su sitio web de manera eficiente
00:04:25
y transferirlo a una hoja de cálculo de Excel,
00:04:28
ahorrándole numerosas operaciones manuales de copiar y pegar.

No elements match your search in this video....
Do another search or back to content !

 

Mandarine AI: CE QUI POURRAIT VOUS INTÉRESSER

RELATED COURSES This video is part of the following courses

252 Views

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...

ALL COURSES

An Error Has Occurred

Impossible de sauvegarder votre progression. Veuillez recharger la page, vous connecter, et essayer de nouveau. Si le problème persiste, merci de contacter un administrateur.

Close

Reminder

Show

/

Join Live Training Session