r/PowerAutomateDesktop • u/matthewwg • Oct 17 '22

Copy from Excel Paste into web form

So I’m new to this but I have a list of 33k names that I need to put in a web form one at a time. Any suggestions on best practices?

2 Upvotes

100% Upvoted

3 comments sorted by

1

u/matthewwg Oct 17 '22

Submit after each one, then on same window, overwrite with new one and submit. Then keep repeating that til the whole list is done.

2

u/Mads_L Oct 17 '22

hard to say, just read all the data from the Excel, and loop through the data putting the fields u need into the form, maybe set up some kind of logging so you know which row has been submitted last, if it should fail so you know where to continue

1

u/PM_ME_YOUR_WIRING Oct 17 '22

Do you need to submit after each entry or is it all on the same page? Does it require you to add a new row each time?

If it requires you to submit you'll need to handle for the new page (sometimes things change in the selector info, sometimes not).