Power Automate Deskop - How To Fill Data From Excel To Web Form (Full Tutorial)
Вставка
- Опубліковано 31 лип 2024
- On this tutorial, we will learn how to create RPA automation with Power Automate Desktop, that fills data from Excel into web form.
Web Form: forms.gle/R64yxBKTaxfJ3F3r6
[01:16] - Introduction
[05:32] - Read excel
[07:31] - Launch browser
[08:33] - For Each Data Table Row
[15:12] - Populate form fields
[16:27] - Submit form
[16:27] - Submit another response
✅ Did you like the video?
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
✍️ Leave your comment
📢 Share with your friends
🕵 Follow me on social media ➽ linktr.ee/marcelocruz
#rpa #powerautomatedesktop - Наука та технологія
Thank you! Perfectly explained and demonstrated. Really appreciate that.
You're very welcome! Thank you so much for the feedback 😀
I thank you from the bottom of my heart. You have saved me effort and a very difficult daily routine. There are no words to explain my thanks to you with this distinguished, brief, useful explanation that I learned from a man who is not fluent in the English language. Thank you very much.
Wow that's really awesome, I'm really very glad to know that 😊 Thank you so much for such kind words
This is absolutely incredible. Well explained and easy to follow, thanks!
You're very welcome! Thanks for the feedback :)
Thank You so much Marcelo. Very nicely demonstrated and explained well. Your video was of great help to me. You got my Sub and Like. Keep up the good work.
Thank you so much for your feedback. I'm glad it helped you :)
Thank you so much! You're a life saver!. This is absolutely incredible. Well explained and easy to follow, thanks!.
Best video so far helped me to do a small project. Very big Thank You🙌
You're welcome Soham!
This video is fantastic, incredible! Thanks Marcelo.
Thank you so much for the feedback! You're welcome :)
You gained a sub bro! You’re so underrated hope you help more with your tutorials!
Thanks a lot Jonathan for the support!!!
I really appreciate for your video, it help me a lot in my working environment. Your explanation is so clear and easy to understand
Thanks a lot for your feedback! I'm really happy to know that this tutorial helped you😀
incredible video, thank you! I feel so powerful with Power Automate!
Thanks for the feedback, you're welcome!
Hey thanks Marcelo for this tutorial! :)
Hello 👋🏻 You're welcome! 😀
Great tuto we really was in need of it thank you very much
You are welcome!
Благодарю за данный видео-урок!!! Вы сделали крутой пример для заполнения веб-сайта данными из Excel, сейчас в моей работе это очень актуально!!!
Same
You saved my life. Thank you, sir.
You're welcome!
Perfectly demo'd. Great job and thanks.
Thanks for the feedback 😃You're welcome!
@@marcelocruzrpa hi , how about the date format?
Ótimo vídeo vídeo Marcelo! Muito bom para conhecer a ferramenta
Muito obrigado pelo feedback Pedro!
Thank you so much! You're a life saver!
You're welcome! 😊
Very very Very ............. Help full.
Thanks for the feedback!
Great use case, many thanks for sharing.
Thanks for the feedback, you’re welcome 😀
Thank you for this very informative tutorial.
You're welcome!
Very helpful tutorial!
Thanks a lot for the feedback!
I was so screwed till i seen this . Many thanks , hugely appreciated !
You're welcome! 😃
good tutorial video . thank you Marcelo
You're welcome Paul!
Thanks Man you just save my Day ✌️
You're welcome Irshad!😃
Thank you so much. Great job
You're welcome!
شكرا جدا اختصر علي شغل شاق ومتعب شكرا لك
Thanks! eres el mejor en esto!!!
You're welcome Enrique! 😃
Thank You very very much. This video is of great!!! help to me. Before, I was struggling with my website form.
Your're welcome and thans for the feedback! I'm glad to know it helped :)
thank you very much
This video is awesome !! 5 out of 5
Thanks a lot for the feedback! :)
thank you for creating this, i was able to use your tutorial to automate user creation on my vpn network :)
You're welcome, glad to know it was helpful! :D
Thank you so much!
You're welcome!
Thank You! Microsoft did not have a good tutorial I could find to transfer excel data to other fields.
You're welcome! :)
Awesome BRO
Thanks a lot Omkar!😃
Hello Marcelo, Thank you for this tutorial. I had one question, I was filling out a different web form and the For Each loop just kept going refilling the feilds over and over. do you know a way to stop the loop?
Me being a data clerk, you're about to save me hours of work 🙏😝
You gained a sub bro
Thank you so much Sai! :D
Awesome. Thank you. Helped a lot but now I'm stuck on entering fields that are drop down menus and calendar picks.. lol. I hope to solve my patient data entry debacle soon.
Hi Marcelo, thank you for the video. I have a data table with three rows. While testing the for each part, the solution iterates through on all rows in the first column. How did you manage to get the data only from the second row in one loop? Thank you
Thanks sir
You're welcome!
I have a question..I use it to fill form everytime, but sometimes I have different number of users to fill in for example today 4 clients, tomorrow 8 clients, if I use the "Values from a range of cell" and leave it empty, it will continue loop entering empty texts. So I changed to All available values from worksheet, but it is still the same, entering empty text after the first 4 clients finishes. Do you have any idea on this? Much appreciate.
thanks bro
You're welcome! :D
Thank you so much. Can you show me how to attach file (example: my CV) on web form filling?
Hi, i am having some problems with one field where a value of 1 is automatically filling and if i choose the replace functionality in populate text field, the whole row is deleting
SImply wow !!!
Thanks for the comment ! :)
Can the same process be adjusted to fill the same data into a program form instead of browser?
Hi Marcelo, really great demo, thanks.
Quick question, is there a way to add a feature that only reads the new rows of data since the last time the flow was ran to avoid adding duplicates in the future?
I Would add a new flow. Add a column [tick] and run those with no tick.
Hi Marcelo i can use captch solver for site?
Can you run the script on a page which you open manually before running the script instead of telling it to open chrome and go to the page in the script?
can you also add steps to attach the file to web form ? and also copy from the form and paste into excel file to ducument the completion ?
can we fill the form a REST API request and run 1000 requests in parallel and scrap the results from form.
Great tutorial, however I need help. My form contains like 30 rows which each have 3 fields that are the same. When I did the test run after your First Name step it was just repasting the date all in the first row of the form not going to the next one. So it would paste my data row 1, into row 1 of the form, then row 2 of the data into row 1 of the form and so on. Always pasting in Row 1.
How can I fix that?
Basically it's like if your form had all the fields multiple times like First Name, Last Name, Company, then repeated again in the same form First Name, Last Name, Company etc.
So how can I tell Power Automate to only fill once then go to a different set of UI elements on the next row.
The only way I could think is maybe instead to click in the first one, then Tab between each (it would be 1 tab to next one, 1 tab to next 1 then 5 tabs to get to the first one in the next row.
For reference each row input fields are named 1.min, 1.min, 1.max (not sure why the first two have the same name..so strange)
Hello, when Excel reads the values it does not put the first row as the Column Header. It does not read the CurrentItem['VALUE'] it says there is no column. PAD is loading data and auto naming columns as Column1-Columnx. I tried CurrentItem['Column1'] but that doesn't work either. Can anyone help?
How to check if particular column exists in excel?..when using browser js func
Hi Marcelo. I am copying your automation, i am doing it in a PPM system though. Not quite a classic webform but it is a page where there are fields that can be populated with text, just like a web form i would assume. I get an error though.. "Form fill with selector 'input xxxxx' not found." Do you have any idea what may go wrong here? Thank you.
Hello Daniel, there are a lot of things that can be the cause of this behavior, but I suggest to check on the elements that aren't being found if the attribute "id" changes dynamically, I see on the error that at least on the selector not found, the attribute used to find the element it's the id, so for debug, capture the element again, and check it's id, then after refresh the page/form, see if the id stills the same by inspecting the element on the browser...if the id changes, that's the cause of the error, and you will have to use another attribute(s) to find uniquely and exclusively the desired element.
What if i have 100 + columns , is there a way to automate it rater than writing every column name each time within for each loop?
🎉
tenk yuuu
You're welcome!
anyone know a better software to automate the completion of HTML form?
I was successful until I got to the populate text field on web page. When I press Run. The first field is populating over and over again going down the row of the first column until the last row. Anyway to fix this?
how would i got about opening more than one web form on the browser?
minute 4.40, allow me ask one question, if data not only G11(variable) like this month might G30, next month G10. how to config?
thank you for the video.. but i run into an error when following your steps. the error says Property 'Xxx' Of Variable 'Currentitem' Couldn't Be Evaluated. Any expert know how to resolve this? many thanks
Great video couldn’t help but think you where teaching to your minions in despicable me
Thanks, good tutorial. What if the table in Excel is dynamic and we don't know how many rows will be there in the table?
Currently, Power Automate for Desktop also has the option to read all the values from the worksheet, click on Retrieve, on the action Read from Excel worksheet,and you will notice that you the option "All available values from worksheet", which does not need to indicate the last row/column and reads all available values.
@@marcelocruzrpa can you set up your flow to automatically take a new entry in Forms whenever a new one is added and just add that one data set to a website?
Thank you very much, is it possible to open MS Edge Private window instead of ordinary chrome browser? If yes tell me please in the comment how to do so? Thanks again
I never tried on Power Automate Desktop, so I was searching on the action that launches the browser if there is some property for that, but didn't find. Fortunately, after some searching, I found how could be done, just check here the solution: powerusers.microsoft.com/t5/Power-Automate-Desktop/PAD-Open-Browser-in-Incognito-Mode/td-p/733215
One of the best video on UA-cam , sir how can I contact you sir........
Hi Marcelo, I am having trouble entering dates from csv file to web using the power automate desktop. The dates keep changing from DD-MM-YYYY to MM-DD-YYYY. I hope you can help me on this. Thanks
use convert date time to text and in format to use: custom yyyyMMddHHmm
Its working for another web form beside google form ? Like e-commerce web for order form. Actually i have a lot of data from my customer and must be have input one by one manually.
Yes it should work, the logic probably will be similar, you just have to adapt the flow to open and fill you're specific web form.
What if two people want to use same power automate desktop flow? Is there a way to copy or deploy the flow?
Yes, it's possible to deploy/export the flow. To copy , you can also do Ctrl + A to select all flow actions, then CTRL+C to copy, and then paste and the save on text file. Then to import it's just needed to copy all the text stored on the file and do CTRL+V on the new flow.
Hello sir can you show the example of same Google form with dynamic ui elements
Plz solv my problem sir
Failed to assume control of charome (communication with browser failed.try reloading extension).
Hello, do you have the Power Automate for Desktop extension installed on the browser? If no, you have to install it for Power Automate be able to communicate with the browser. To install it easily, on the flow development window, you have on top the option Tools, just click on it and then hover extensions, and select the browser that you want to use for the automation.
its saying its a file based error
I have check the properties, all read and write scenarios are checked except special permission please help
Hi there, your contribution is appreciated. However, I encountered an issue, when I use for example %CurrentItem['loginID']%, it will become exactly %CurrentItem['loginID']% on the web page, rather than its value. This is annoying. What I might did wrong? any idea?
I just got my issue. When I new a flow, I checked "Power Fx enabled (Preview)", so don't do that! Hope this helps.
why i tried this and it does not stop pasting john it would continue to paste jane so on and so forth why in your video only paste john. i followed exactly as it is.
Hi Marcelo - is there a way to do something similar if you do not know how many rows / columns there will be?
Hello Scott, yes, actually you have on the action that reads data from Excel, on the property 'Retrieve', the option 'All available values from worksheet', that reads the whole file without having to indicate number of rows/columns.
@@marcelocruzrpa thank you so much. I thought it might be the case.
Thanks a lot! so how to use if statement in the loop? please help me!
You're welcome! To use if statement inside the loop you can use the If action inside of it.
@@marcelocruzrpa Thanks you!
i am using local website in whichh after filling first row of excel data into web form, i have to click add button then second row containing several input options appears and after filling it, i have to go for third one and finally i have to click submit button. How can i fill all the rows with excel data. Please reply me.
Hello Naresh, you just have to use the same logic of the tutorial, inside of the cycle, cover all steps needed to register and submit the form, including the needed clicks to open required options.
@@marcelocruzrpa tanx for the replu, but PAD did not recognize newly added row and it repeatedly go to first row
Bom dia Marcelo, excelente conteúdo! Ve se você pode me ajudar, após preencher os meus campos de texto, preciso que para cada linha o Power automate baixe um arquivo e nomeie o mesmo com um número específico (exemplo: BRP_062021) é possível fazer isto? Obrigado
Bom dia Thiago, muito obrigado pelo feedback! Em principio sim, apenas terá é que adaptar o fluxo para fazer tal!
Hello sir, will it works if the names doesnt happen to appear in first row?
Hello, yes it will work, the robot will click on the input field, but will leave it empty if the excel cell it's empty also.
Excelente vídeo Marcelo! Me deu uma luz aqui. Fiz uma automação para lançamento de notas, teria como fazer ele ignorar caso o cadastro já exista, tipo, ignorar e ir para o próximo cadastro e assim por diante? Me ajude ou faz uma aula explicativa. Muito Grato.
Obrigado pelo feedback Fábio! Sim, poderá fazer após a criação do cadastro a validação se o mesmo foi criado com sucesso ou não. Não sei como funciona o cadastro do que está a automatizar, mas imagino que após a criação, deve haver algum feedback por parte do sistema, informando que o cadastro foi criado com sucesso, ou que o cadastro falhou. Tendo isso em conta, você pode começar por verificar na automação, após a criação do registro, se o cadastro foi criado com sucesso, ao verificar se apareçe o elemento que indica o sucesso da criação do cadastro. Para isso, se se trata de algo realizado na web, pode usar a atividade "Se a página Web contiver", que valida se determinado elemento/texto existe na página, e com isso pode validar se foi sucesso ou se falhou o cadastro, etc.
@@marcelocruzrpa Obrigado pela dica Marcelo, após quebrar um pouco a cabeça consegui implementar em uma das etapas a verificação de "se houver erro", executar um subfluxo de exclusão da linha já cadastrada, retornar à página anterior e executar outro subfluxo, reiniciando as ações novamente, mantendo a etapa duplicada no 2º subfluxo, deixando o fluxo inicial só como gatilho, ficou meio confuso mas dá certo, obrigado por responder.
normal things are filling just fine, but the issue occurs for drop down list. could you help it in that issue.
Give a try to "Set drop-down list value on web page" action. If it doesn't work for the drop down list that you're working on, you can always use click to open the dropdown + click (with dynamic selector if the value to select changes) to select the value.
I cant use %currentitem['']% formula? Can i get some enlightment
Amazing.. What to if a pop out window comes with error.
You can add validation for that after submit the form with action like "If web page contains" that checks if a element appears, and if it's the case, you can handle properly the popup and other elements.
after the first loop and the form is submitted it still wants to loop through the cycle why is that?
Just because there are stills rows to iterate from the data table that stores the data to input on the form.
@@marcelocruzrpa thank you so much for the response love u! i subbed of course and i also emailed you i will need some services
Hi @Marcelo , can we do this on free version or we need to pay for it? Please tell
Hello Ayush, yes you can do on the free version.
How do i fill dropdown list or checkbox? Thank you😊😊
To select dropdown item you can try the 'Select Item' activity and for checkbox you can try the 'Check/Uncheck' or 'Click' activities :)
Plz make video including form containing capcha
Hello, thanks for your suggestion, I will add on my notes.
Will it stop the loop after excel list is complete?
Yes, it will stop after all excel rows are iterated.
is it work with radio button?
Yes, you can use the action "Select radio button on the web page" for that!
It is showing error in launching excel file please help
How to upload otomatic image to google form
Hi bro.... i really need a a favor from you. i was tried so many times and i helpless. how do i reach you out?
Hello Marcelo,when I populate phone no. from excel onto web, there is a comma end up with the number on web, how does it happen? and how can i get rid of the web from web? Thanks!
Hello Lawrence, are you sure there is no comma on the phone numbers? What do you mean get rid of the web from the web?
@@marcelocruzrpa Hi Marcelo, thanks for your time! no,there is no comma mark at the end of phone number at all. i don't know why when PAD populates a phone number from excel onto web there will be a comma mark ends up with the phone number, now i have to add an extra sentence to PAD to delete this comma mark(my solution is sending backspace key through "mouse and keyboard action"),but i'd like to know what causes the comma marks? and how can i have PDA poputates without comma marks? I've sent Photos to your Gmail. Thank you very much!
FOR ME IT COPIES THE TEXT PARTIALLY , CAN YOU HELP ME
is it possible to automate a SharePoint survey too?
Yes for sure!
Thank youuu
You're welcome!
I really appreciate your video. I learned a lot. Could you help me for filling a decimal field from an excel sheet? Because it's only copying the digits behind the dot. I sent you a video through your email address.
Hello, I saw your video. I already faced a similar issue, just wasn't with Power Automate Desktop, could you try to change the data type to number/text and see if the behavior stills the same?
@@marcelocruzrpa yes it's same
if you figure it out or find any way to solve this issue, please let me know thanks
very low volume
Marcelo please check your youtube mailbox, I sent you an email I really need your help to move on, I am stuck, thanks again.😁
Hello Ravven, I already answered to to your email!
@@marcelocruzrpa thanks
Voice clarity poor
Thank you for the feedback, I just bought a new microphone, hopefully it will the next tutorials will have a better voice/audio quality 🙂
Voice is 240p but content is 4k