This series is fantastic! It is both shown and explained, clearly, and it covers a lot of extremely useful functions. One of the absolute best Power Automate tutorials I've seen anywhere, including in the MS Documentation. Thank you!
I have a web page which does not allow pasting the values from Excel. We have to type manually. Is there any way we can do that with the power automate?
hello sir, thank you for sharing your knowledge. Is there a way to extract data from PDFs and then fill it into a web application for the corresponding fields ? I have a use case where organisation users mostly use paper forms and then scanned as PDFs. But the same information has to be fed into a web application.
Hello！I saw in video， in read from excel worksheet, you define the start row and end row, but in my actual case, each time the end row is different, how to let power automate read all rows without define end row ?
How to select ui element corresponding to excel data value in for each loop. For example how can we select a call track number which is available in the web page corresponding for the value in which for each loop is running.
Hello Is it possible to create a command on Power Automate for data enytry in websites by select. I dont want to use it for fill a form i need to use it for selecting from webpage
i am using local server in which after filling single row data from excel into a row of online form, i have to click add button then another row containing same form options appears then i have to fill second row of excel data into newly appeared row in online form how can i do it. Please reply me
Hello! I am trying to add a UI element on a internal company webpage that we use to perform web filling tasks but for some reason the cursor is not reconizing the field that i want to add, could this be due to some security block? is any way to allow the cursor to add that UI element or that function is limited on some webpages due to security reasons?
Thank you first of all for coming up with such a great content . I am trying to automate the same but after reading the excel data from range of cell ,I cannot retrieve the data "column" wise while looping through each row . I see in the vedio you are using the variable %CurrentEmployee['Column1']% but the same doesn't works for me . Please let me know where am I going wrong .The error msg says the column or property "Column1" not found .
Got the correct way, 1. you need to make the excel as a table format 2. Check your column name captured by PAD in that Flow variable section, Click on that eye button to view the Excel columns, there you will find the column names :)
I have an issue where when PAD enters the data from column 2, it also pastes in data from column one so it looks like Column1Data, Column2 data in one field but all the other fields are populating correctly. Any ideas?
@9:48 set dropdown list from web page action in option names can i use filter options for example in location column i have ban instead of bangolore so that i can use if statement in option names in this action like if %currentitem[column1]% = 'ban' then 'bangolore' Like this way in option names itself instead of using if action in power automate
Got the correct way, 1. you need to make the excel as a table format 2. Check your column name captured by PAD in that Flow variable section, Click on that eye button to view the Excel columns, there you will find the column names :)
@@robin.vision Hi.. I can see the column name as Column1 only. But still it is showing error that Variable doesn't exist. Could you please guide me on that? Thanks
I'm trying to do following exactly your steps, But I'm not getting right. I'm not able to make the first pass, which is to fill in the first field on the web. Can I send to you video about 2 min to show to you my problem? If You have an email.
Hello Basha! Thank you for the detailed tutorial. Can you please demonstrate how you set up "Populate Text Field on web page" at 6:37? You don't show it in the previous video (you only showed how to insert some hard coded text here ua-cam.com/video/6K1qQLp9VH8/v-deo.html not how to do it with excel) nor in this one. For example, how did you set it up so the result is (as it shows at 6:37) : Populate text field 'Empname' with CurrentEmployee ['Column1'] using emulated typingPopulate text field 'Empname' with CurrentEmployee ['Column1'] without using emulated typing Following your tutorial I currently have: Populate text field 'xxx' with using emulated typing How do I make it so it is like you? Where the CurrentEmployee variable come from at 6:21? At 6:14 A1 cell has EmployeeName, not CurrentEmployee. So I don't understand how to do it. Why do you name the variable CurrentEmployee and not EmployeeName? How does PAD detects it if you coall it CurrentEmployee. Please, clear the confusion thanks! Thanks a lot! Or if you would prefer, can you do the same tutorial from scratch without talk but just showing every steps you take until the success at the end. That way we could see every steps in a single video. Kind regards, Frank
Awesome, now it works. I needed to save the excel sheet with format as table (Home > "Format as table" with 1st row as Header. Then instead of the CurrentEmployee, just keep the default CurrentItem (%CurrentItem['Column1']%) (instead of %CurrentEmployee['Column1']%) (then (%CurrentItem['Column2']%) (instead of %CurrentEmployee['Column2']%) etc. for each "Populate text field on web page" flow step ) from the loop at 3:48 in the Text field of the "Populate text field on web page" flow step. Very exciting, how powerful that app is is staggering! You rock Basha! Be well!
Hi Sir, pls share contact no , I want to ask question regarding automatically web filling data entry project, My question is can I change our ip address & delete cookies after fill one data.
Got the correct way, 1. you need to make the excel as a table format 2. Check your column name captured by PAD in that Flow variable section, Click on that eye button to view the Excel columns, there you will find the column names :)
This series is fantastic! It is both shown and explained, clearly, and it covers a lot of extremely useful functions. One of the absolute best Power Automate tutorials I've seen anywhere, including in the MS Documentation. Thank you!
Thank you Roemerman
I have a web page which does not allow pasting the values from Excel. We have to type manually. Is there any way we can do that with the power automate?
hello sir, thank you for sharing your knowledge. Is there a way to extract data from PDFs and then fill it into a web application for the corresponding fields ? I have a use case where organisation users mostly use paper forms and then scanned as PDFs. But the same information has to be fed into a web application.
I'm curious to know what if a Record/User is already existing in the system and whats the work around that?
Is it possible to enter data for different users at the same time?
Can you please help how handle blank excel values while import data to sql serve table in Power Automate?
Hello！I saw in video， in read from excel worksheet, you define the start row and end row, but in my actual case, each time the end row is different, how to let power automate read all rows without define end row ?
How to select ui element corresponding to excel data value in for each loop. For example how can we select a call track number which is available in the web page corresponding for the value in which for each loop is running.
Hi,
How do you get the current employee to show up as a variable under the for each loop?
I figured it out, you add a variable, name it and set it to the complete table of excel data :D
@@deidretrimberger4760 , I am very new to this. Please describe the steps in more detail. Thanks
Hello
Is it possible to create a command on Power Automate for data enytry in websites by select. I dont want to use it for fill a form i need to use it for selecting from webpage
i am using local server in which after filling single row data from excel into a row of online form, i have to click add button then another row containing same form options appears then i have to fill second row of excel data into newly appeared row in online form how can i do it. Please reply me
Hi. Excellent your tutorials. I'm learning a lot.
Thanks for sharing your knowledge.
Thank you john
My son 10years old best institute reper pls and learning power automate desktop
Nice tutorial on a important PA feature! Thank u!
Glad it was helpful!
Hello! I am trying to add a UI element on a internal company webpage that we use to perform web filling tasks but for some reason the cursor is not reconizing the field that i want to add, could this be due to some security block? is any way to allow the cursor to add that UI element or that function is limited on some webpages due to security reasons?
Same issue
Great time to spent with your videos 😊... I would like and looking in to the key stroke level.... How to do press enter key please guide us bro
Thank you first of all for coming up with such a great content . I am trying to automate the same but after reading the excel data from range of cell ,I cannot retrieve the data "column" wise while looping through each row . I see in the vedio you are using the variable %CurrentEmployee['Column1']% but the same doesn't works for me . Please let me know where am I going wrong .The error msg says the column or property "Column1" not found .
Thank you for your appreciation.let me check
same error for me also, any help?
Got the correct way,
1. you need to make the excel as a table format
2. Check your column name captured by PAD in that Flow variable section,
Click on that eye button to view the Excel columns, there you will find the column names :)
I have an issue where when PAD enters the data from column 2, it also pastes in data from column one so it looks like Column1Data, Column2 data in one field but all the other fields are populating correctly. Any ideas?
Hello Sir, I wanted to ask how to add only the newly added records but not the whole records from start ???
@9:48 set dropdown list from web page action in option names can i use filter options for example in location column i have ban instead of bangolore so that i can use if statement in option names in this action like
if %currentitem[column1]% = 'ban' then 'bangolore'
Like this way in option names itself instead of using if action in power automate
Can you put link to practice this exercise?
Very well explained!! Keep up the good work.
Thank you Badhikari
I have this error, VariableExcelData' doesn't have a property 'Column1', how can I fix this? Your help is much appreciated
Got the correct way,
1. you need to make the excel as a table format
2. Check your column name captured by PAD in that Flow variable section,
Click on that eye button to view the Excel columns, there you will find the column names :)
@@robin.vision What do you mean by "that Flow variable section"? Where is it? Where is the "eye button"? Thanks.
@@robin.vision Hi.. I can see the column name as Column1 only. But still it is showing error that Variable doesn't exist. Could you please guide me on that? Thanks
Plz solv my problem sir
Failed to assume control of charome (communication with browser failed.try reloading extension).
Plz reply sir
Provide me the details with screenshot
@@LearningTechnologies sir youtube pr to screen shot nahi bhej pa rha hu isaliye aapke Instagram I'd pr bheji
Why no one shows about Date field entry?
Hi... can you share about selector builders?
Hi, first of all thanks for awesome video. Very helpful :)
May I know from which reference you have used "CurrentEmployee"?
Thank you Ankit. Keep learning keep watching and keep sharing for daily learning updates.
Amazing.
Thanks very much Ameer.
How did you learn that?
All alone?
Best channel my friend.
Thanks to you Felipe
Hi, please give me the form Employeeregistration
I'm trying to do following exactly your steps, But I'm not getting right. I'm not able to make the first pass, which is to fill in the first field on the web.
Can I send to you video about 2 min to show to you my problem? If You have an email.
Yes you can
Which software is this?
Microsoft Power automate desktop
Hello Basha! Thank you for the detailed tutorial. Can you please demonstrate how you set up "Populate Text Field on web page" at 6:37? You don't show it in the previous video (you only showed how to insert some hard coded text here ua-cam.com/video/6K1qQLp9VH8/v-deo.html not how to do it with excel) nor in this one.
For example, how did you set it up so the result is (as it shows at 6:37) :
Populate text field 'Empname' with CurrentEmployee ['Column1'] using emulated typingPopulate text field 'Empname' with CurrentEmployee ['Column1'] without using emulated typing
Following your tutorial I currently have:
Populate text field 'xxx' with using emulated typing
How do I make it so it is like you?
Where the CurrentEmployee variable come from at 6:21? At 6:14 A1 cell has EmployeeName, not CurrentEmployee. So I don't understand how to do it. Why do you name the variable CurrentEmployee and not EmployeeName? How does PAD detects it if you coall it CurrentEmployee. Please, clear the confusion thanks!
Thanks a lot!
Or if you would prefer, can you do the same tutorial from scratch without talk but just showing every steps you take until the success at the end. That way we could see every steps in a single video.
Kind regards,
Frank
Awesome, now it works. I needed to save the excel sheet with format as table (Home > "Format as table" with 1st row as Header. Then instead of the CurrentEmployee, just keep the default CurrentItem (%CurrentItem['Column1']%) (instead of %CurrentEmployee['Column1']%) (then (%CurrentItem['Column2']%) (instead of %CurrentEmployee['Column2']%) etc. for each "Populate text field on web page" flow step ) from the loop at 3:48 in the Text field of the "Populate text field on web page" flow step.
Very exciting, how powerful that app is is staggering!
You rock Basha!
Be well!
Hi Sir, pls share contact no , I want to ask question regarding automatically web filling data entry project,
My question is can I change our ip address & delete cookies after fill one data.
Please contact on my email address
@@LearningTechnologies please let me know your email address
I have this error, VariableExcelData' doesn't have a property 'Column1', how can I fix this? Your help is much appreciated
You don't have name column1 in excel
Got the correct way,
1. you need to make the excel as a table format
2. Check your column name captured by PAD in that Flow variable section,
Click on that eye button to view the Excel columns, there you will find the column names :)