Power Automate Deskop - How To Fill Data From Excel To Web Form (Full Tutorial)
Ғылым және технология
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
Пікірлер: 180
Thank you so much! You're a life saver!. This is absolutely incredible. Well explained and easy to follow, thanks!.
Thank you! Perfectly explained and demonstrated. Really appreciate that.
@marcelocruzrpa
9 ай бұрын
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.
@marcelocruzrpa
Ай бұрын
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!
@marcelocruzrpa
5 ай бұрын
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.
@marcelocruzrpa
Жыл бұрын
Thank you so much for your feedback. I'm glad it helped you :)
Thank you so much!
@marcelocruzrpa
Ай бұрын
You're welcome!
I was so screwed till i seen this . Many thanks , hugely appreciated !
@marcelocruzrpa
Жыл бұрын
You're welcome! 😃
incredible video, thank you! I feel so powerful with Power Automate!
@marcelocruzrpa
Жыл бұрын
Thanks for the feedback, you're welcome!
Best video so far helped me to do a small project. Very big Thank You🙌
@marcelocruzrpa
2 жыл бұрын
You're welcome Soham!
You saved my life. Thank you, sir.
@marcelocruzrpa
Жыл бұрын
You're welcome!
Great tuto we really was in need of it thank you very much
@marcelocruzrpa
2 жыл бұрын
You are welcome!
This video is fantastic, incredible! Thanks Marcelo.
@marcelocruzrpa
3 ай бұрын
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!
@marcelocruzrpa
Жыл бұрын
Thanks a lot Jonathan for the support!!!
Thank you so much! You're a life saver!
@marcelocruzrpa
9 ай бұрын
You're welcome! 😊
I really appreciate for your video, it help me a lot in my working environment. Your explanation is so clear and easy to understand
@marcelocruzrpa
2 жыл бұрын
Thanks a lot for your feedback! I'm really happy to know that this tutorial helped you😀
شكرا جدا اختصر علي شغل شاق ومتعب شكرا لك
thank you very much
Благодарю за данный видео-урок!!! Вы сделали крутой пример для заполнения веб-сайта данными из Excel, сейчас в моей работе это очень актуально!!!
@liam7623
Жыл бұрын
Same
Very very Very ............. Help full.
@marcelocruzrpa
Жыл бұрын
Thanks for the feedback!
Hey thanks Marcelo for this tutorial! :)
@marcelocruzrpa
9 ай бұрын
Hello 👋🏻 You're welcome! 😀
Perfectly demo'd. Great job and thanks.
@marcelocruzrpa
Жыл бұрын
Thanks for the feedback 😃You're welcome!
@mendezfirestation2665
Жыл бұрын
@@marcelocruzrpa hi , how about the date format?
Thank you for this very informative tutorial.
@marcelocruzrpa
Жыл бұрын
You're welcome!
Great use case, many thanks for sharing.
@marcelocruzrpa
Жыл бұрын
Thanks for the feedback, you’re welcome 😀
Thanks Man you just save my Day ✌️
@marcelocruzrpa
2 жыл бұрын
You're welcome Irshad!😃
Very helpful tutorial!
@marcelocruzrpa
Жыл бұрын
Thanks a lot for the feedback!
Thank you so much. Great job
@marcelocruzrpa
Жыл бұрын
You're welcome!
Ótimo vídeo vídeo Marcelo! Muito bom para conhecer a ferramenta
@marcelocruzrpa
2 жыл бұрын
Muito obrigado pelo feedback Pedro!
good tutorial video . thank you Marcelo
@marcelocruzrpa
Жыл бұрын
You're welcome Paul!
Thank You very very much. This video is of great!!! help to me. Before, I was struggling with my website form.
@marcelocruzrpa
Жыл бұрын
Your're welcome and thans for the feedback! I'm glad to know it helped :)
Thanks! eres el mejor en esto!!!
@marcelocruzrpa
Жыл бұрын
You're welcome Enrique! 😃
Me being a data clerk, you're about to save me hours of work 🙏😝
Thank You! Microsoft did not have a good tutorial I could find to transfer excel data to other fields.
@marcelocruzrpa
Жыл бұрын
You're welcome! :)
thank you for creating this, i was able to use your tutorial to automate user creation on my vpn network :)
@marcelocruzrpa
7 ай бұрын
You're welcome, glad to know it was helpful! :D
This video is awesome !! 5 out of 5
@marcelocruzrpa
Жыл бұрын
Thanks a lot for the feedback! :)
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.
SImply wow !!!
@marcelocruzrpa
3 ай бұрын
Thanks for the comment ! :)
thanks bro
@marcelocruzrpa
6 ай бұрын
You're welcome! :D
Awesome BRO
@marcelocruzrpa
Жыл бұрын
Thanks a lot Omkar!😃
Thank you so much. Can you show me how to attach file (example: my CV) on web form filling?
You gained a sub bro
@marcelocruzrpa
Жыл бұрын
Thank you so much Sai! :D
Thanks sir
@marcelocruzrpa
Жыл бұрын
You're welcome!
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?
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
Hi Marcelo i can use captch solver for site?
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.
Can the same process be adjusted to fill the same data into a program form instead of browser?
Great video couldn’t help but think you where teaching to your minions in despicable me
🎉
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 ?
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?
@renanrodrigues8984
8 ай бұрын
I Would add a new flow. Add a column [tick] and run those with no tick.
One of the best video on KZread , sir how can I contact you sir........
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
tenk yuuu
@marcelocruzrpa
Жыл бұрын
You're welcome!
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?
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 sir can you show the example of same Google form with dynamic ui elements
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?
@marcelocruzrpa
2 жыл бұрын
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.
@Capsule683
Жыл бұрын
@@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?
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?
how would i got about opening more than one web form on the browser?
How to check if particular column exists in excel?..when using browser js func
can we fill the form a REST API request and run 1000 requests in parallel and scrap the results from form.
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?
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?
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.
@marcelocruzrpa
2 жыл бұрын
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.
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?
anyone know a better software to automate the completion of HTML form?
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
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
@marcelocruzrpa
2 жыл бұрын
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
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.
@marcelocruzrpa
Жыл бұрын
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.
@fabioforcelini7141
Жыл бұрын
@@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.
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
@marcelocruzrpa
Жыл бұрын
Bom dia Thiago, muito obrigado pelo feedback! Em principio sim, apenas terá é que adaptar o fluxo para fazer tal!
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.
@marcelocruzrpa
2 жыл бұрын
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.
Hi Marcelo - is there a way to do something similar if you do not know how many rows / columns there will be?
@marcelocruzrpa
Жыл бұрын
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.
@scottthomson7201
Жыл бұрын
@@marcelocruzrpa thank you so much. I thought it might be the case.
What if two people want to use same power automate desktop flow? Is there a way to copy or deploy the flow?
@marcelocruzrpa
2 жыл бұрын
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.
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?
@tm1813
4 ай бұрын
I just got my issue. When I new a flow, I checked "Power Fx enabled (Preview)", so don't do that! Hope this helps.
Thanks a lot! so how to use if statement in the loop? please help me!
@marcelocruzrpa
Жыл бұрын
You're welcome! To use if statement inside the loop you can use the If action inside of it.
@nhv2607
Жыл бұрын
@@marcelocruzrpa Thanks you!
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
@hl7019
6 ай бұрын
use convert date time to text and in format to use: custom yyyyMMddHHmm
Plz make video including form containing capcha
@marcelocruzrpa
Жыл бұрын
Hello, thanks for your suggestion, I will add on my notes.
its saying its a file based error I have check the properties, all read and write scenarios are checked except special permission please help
Plz solv my problem sir Failed to assume control of charome (communication with browser failed.try reloading extension).
@marcelocruzrpa
2 жыл бұрын
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.
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.
Amazing.. What to if a pop out window comes with error.
@marcelocruzrpa
Жыл бұрын
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.
I cant use %currentitem['']% formula? Can i get some enlightment
Hello sir, will it works if the names doesnt happen to appear in first row?
@marcelocruzrpa
2 жыл бұрын
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.
Hi @Marcelo , can we do this on free version or we need to pay for it? Please tell
@marcelocruzrpa
Жыл бұрын
Hello Ayush, yes you can do on the free version.
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.
@marcelocruzrpa
2 жыл бұрын
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.
@nareshkumar-qo9qy
2 жыл бұрын
@@marcelocruzrpa tanx for the replu, but PAD did not recognize newly added row and it repeatedly go to first row
is it work with radio button?
@marcelocruzrpa
Жыл бұрын
Yes, you can use the action "Select radio button on the web page" for that!
How do i fill dropdown list or checkbox? Thank you😊😊
@marcelocruzrpa
Жыл бұрын
To select dropdown item you can try the 'Select Item' activity and for checkbox you can try the 'Check/Uncheck' or 'Click' activities :)
Will it stop the loop after excel list is complete?
@marcelocruzrpa
Жыл бұрын
Yes, it will stop after all excel rows are iterated.
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.
@marcelocruzrpa
Жыл бұрын
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?
@investmont9954
Жыл бұрын
@@marcelocruzrpa yes it's same
@investmont9954
Жыл бұрын
if you figure it out or find any way to solve this issue, please let me know thanks
How to upload otomatic image to google form
normal things are filling just fine, but the issue occurs for drop down list. could you help it in that issue.
@marcelocruzrpa
3 ай бұрын
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.
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?
after the first loop and the form is submitted it still wants to loop through the cycle why is that?
@marcelocruzrpa
Жыл бұрын
Just because there are stills rows to iterate from the data table that stores the data to input on the form.
@jonwatson9070
Жыл бұрын
@@marcelocruzrpa thank you so much for the response love u! i subbed of course and i also emailed you i will need some services
It is showing error in launching excel file please help
is it possible to automate a SharePoint survey too?
@marcelocruzrpa
3 ай бұрын
Yes for sure!
@enrysk
3 ай бұрын
Thank youuu
@marcelocruzrpa
3 ай бұрын
You're welcome!
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!
@marcelocruzrpa
2 жыл бұрын
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?
@lawrence5304
2 жыл бұрын
@@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
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.😁
@marcelocruzrpa
2 жыл бұрын
Hello Ravven, I already answered to to your email!
@ravvenhawk1110
2 жыл бұрын
@@marcelocruzrpa thanks
Voice clarity poor
@marcelocruzrpa
Жыл бұрын
Thank you for the feedback, I just bought a new microphone, hopefully it will the next tutorials will have a better voice/audio quality 🙂
@shaileshprasad-ih6qc
4 ай бұрын
Voice is 240p but content is 4k