Form Filling using Power Automate | Power Automate Tutorial

Welcome to RPA Hub in this video we will discuss  about how to fill the form using Microsoft power   automate so let's run this flow and then I will  show you how to build a slow from scratch now   execution has been started this will start filling  out the form based on the xlc Theta so if you can   see here it is entering rigorously all the data  which is available into the Excel sheet and   submitting the details so here we have used Excel  sheet for data and from the xse data the bot will   fetch the data from the Excel set and fill out  the complete form on fraction of second so this   is very much useful when we have to enter or fill  the complete form for multiple user till the time   the data will not finish then it will continue  to execute the process and submit the form thank you now the data will be finished and we are  done with the execution part so if you can   see here complete data will be failed and  if you want to see the complete stats about   this form we we have to navigate into the  response sections and from there we can see   the data is filled or not so we'll show you  how we can see the complete stats so here in   response sections you can see these all data  is successfully filled so we'll see here how   to generate this complete flow from scratch  using Microsoft power automate which is in   find RPA based tool used for Enterprise  cases for doing their automation need so this is my Excel file which contains first  name last name company name role in company   address email and phone number so by using this  detail our bot will fill the form and then bot   will close the file so let's close this file and  delete the complete sections now I am deleting all   the steps we have created so first step we should  have the data so let's create the data based on   this column and we have also created this form so  this form will help us to fill out the complete   form to store the responses now in Microsoft  power automate that is desktop Beast automation   tool we are using here that is called as pad power  automate desktop version so first steps I want to   drag and drop launch Excel so which launch Excel  file for fetching the data so we'll drag and drop   here and here we'll use the documentations as of  now as store this documents in our download folder   and this is for the read-only mode if we want  we can uh enable it otherwise we can keep it as   it is it will create the Excel instance variable  and here we are not using any password protective   value so if our Excel is password productive  we have to define the password for this Excel   and based on that it will start executing the  process when we are dragging dropping any activity   in Microsoft power automate this will create  auto variable that with the name Excel instance   for this activity next one we have to train the  bot in such a way this will read the Excel file   read from Excel worksheet just drag  and drop and now here it will select   the exact same Excel instance which is  created in previous step so we we want to   give the range from which range to which range  this bot will read the data so here we have column A to column G and Row 1 to row 11.  so here I will give a start with column one column G is ending and end with row 11. so first line of range contains column name so  that's why I I will enable this and click on   save this will save all my Excel data  here so if I will run and execute the   process I will get all the data will  be stored here so let me execute it   now this will launch Excel file and you can  see 10 rows and seven columns has been added   successfully next we want to launch Chrome  or any browser where we want to show the file   so launch browser activity now I am using  Chrome so I will drag and drop and here   we have to define the path so exactly same  path we'll use here Ctrl C and paste it to   here which is my initial URL and here we have to  give the maximized this will create a new variable   with the name browser and click on Save after  that we have set of data so we have to use the   loop for this we will use forage so value to be  iterated here we will give the Excel data variable   because we will use this accelerator value to be  iterated next we want to populate the value in   Excel so populate text field in form filling so  this is form filling activity which we are using   here we want to use this one now web browser  instance we are using this UI element we will   add it here so once I'll click on this and it will  navigate into this page simply select left click   and press Ctrl now this will add the variable  here but we want to add the current item so we'll   select this and after that we will Define the name  for which name we are going to use so this name   should match with our column name so here we will  copy and paste this name and single code so that   this value will be selected in square bracket  exactly same thing we have to perform it for   the other areas or other columns then add UI  element and then add the selector for last name   again we will use current item and from here  we will add last name copy and paste this value   save it next we want company  name again add UI element   and then current item select then add  here single code copy company name click on Save again extract populate  text field on beach web page   add UI element and this time  we will use scroll in company current item and then address just put the item this time we'll use address email again select current item and then add email and last one is with phone number click on Save now we are done with this so let  me close this now so this flow will run till   submission of the firm we have not selected the  submit button so once we'll add the submit button   we will just click on click button activity  so this will click on submit button now this is done and next one we have to click on  submitter so let's save this and run the process okay there is a typo error so here we  will give re save it and run it again now we have not built the flow for  the further steps so we have to again   add one more activity of  click so here we will select   click link on web page drag and drop left  click and then we will validate on UI now   our automation is perfect and this time this will  see all the values into Excel and pose that if you   want to close the Excel we can add the close  axle activity so here we will add close Excel you can save now run the flow now you can see till the time value is not empty  or this bot will not fill all this data we will   continue our bot will continue to fill out the  form till the value all the values are done thank you foreign has stopped filling out the form so that's  all from this video Let's recap we have   started with filling out the form on Google  Drive form and we have added launch Excel   then read the Excel data and add it into  form and close that Excel application so   that's all from this video hope you  enjoyed the content if you think so   this will be useful don't forget to share  within your circle thank you for watching

Channel: RPA Hub

Views: 12,463

Keywords:

Id: fb5QfAmwri8

Length: 16min 5sec (965 seconds)

Published: Thu Dec 01 2022