Answered

Filling a series of Text Fields

(0) Share

Report

Posted on by victor_lion

Hello people, I'm new to Power Automate Desktop and it's web scraping tools, so I'm not figuring a way to perform a search and fill the text fields of a page with an input.

Here is an example of how the text fields look like. What I need to look for is the date before the text field so then I can fill with the input.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

fraenK 2,125 on at

Like
a
(1)

Report
Copy link

Link copied!

What you need is to extract data and fill a form, which is described here: https://docs.microsoft.com/en-us/power-automate/desktop-flows/automation-web

Was this reply helpful? Yes No
victor_lion 67 on at

Like
a
(0)

Report
Copy link

Link copied!

I can extract data, but when I use the 'populate text field' or 'focus text field' I'm not able to use the data extracted before. Do you have any tips on that? Maybe text or videos that explain this, would be very helpfull.

Was this reply helpful? Yes No
fraenK 2,125 on at

Like
a
(0)

Report
Copy link

Link copied!

Is there an error message?
Training is here: https://docs.microsoft.com/en-us/learn/paths/pad-get-started/

Was this reply helpful? Yes No
victor_lion 67 on at

Like
a
(0)

Report
Copy link

Link copied!

There is no error message, but I'm stuck on how to build correctly the 'for each' to loop over the dates column. I'm trying to parse the information exctracted to a excel file then loop the rows to find the date that I want, without any luck at the moment...
Maybe you have better ideas on how to do this.

Was this reply helpful? Yes No
fraenK 2,125 on at

Like
a
(1)

Report
Copy link

Link copied!

https://docs.microsoft.com/en-us/power-automate/desktop-flows/use-loops
https://docs.microsoft.com/en-us/power-automate/desktop-flows/variable-data-types#advanced-data-types

Was this reply helpful? Yes No
victor_lion 67 on at

Like
a
(0)

Report
Copy link

Link copied!

Doing this I end up with an excel sheet filled, but not the webpage... Can't see how I'm supposed to use that information extracted to fill out the text fields on the page.

Was this reply helpful? Yes No
fraenK 2,125 on at

Like
a
(0)

Report
Copy link

Link copied!

You need to use for each to loop through the Excel file or data table variable. Filling fields is shown here: https://docs.microsoft.com/en-us/power-automate/desktop-flows/automation-web#data-population-on-the-web

Was this reply helpful? Yes No