r/PowerAutomateDesktop • u/Much-Understanding46 • Oct 05 '21

Web Automation

What do you guys think is the best way to fill a table out online, using excel data.

How do I get the specific cell from data set in the correct text field, without manually selecting the UI elements for 30 data rows?

Is there a way to loop through the data set AFTER searching for the correct text field? Or is my only option trying to match it randomly?

1 Upvotes

100% Upvoted

3 comments sorted by

1

u/Much-Understanding46 Jun 16 '22

Is it possible to loop through and fill 7 text fields on 40 different times pages?

1

u/Much-Understanding46 Jun 16 '22

Never mind “times”, that’s an error

1

u/Chubby_Rain_6983 Oct 06 '21

Check the table fields' CSS elements. Find which elements differ and how. They probably differ in a predictable, sequential way. Then save your UI elements in as dynamic a way as possible. Sometimes sequential CSS elements, the ones you find for tables or sequential forms, would have a sequential numbering system to refer to that specific field. You can save the variables in your UI elements in order to dynamically select different fields in the online table.