i have a problem please solve it how can i repeat the same action with diffreant elemants in power automate? Example: like i want to select one file than copy it and then paste it in another file than again selecting a diffreant file select it and than paste it in file please help ME......
🎯 Key Takeaways for quick navigation: 00:27 *🛠️ Setting up SQL connection and connection string* - Setting up a SQL connection in Power Automate Desktop. - Creating a connection string manually for faster setup. - Utilizing variables to store the SQL connection for future use. 02:17 *📝 Executing SQL statements* - Executing SQL statements within Power Automate Desktop. - Retrieving query results and storing them in data tables. - Running and verifying SQL queries within the automation. 04:42 *📊 Working with Excel data* - Reading data from Excel sheets into Power Automate Desktop. - Setting variables dynamically to handle changing file paths. - Iterating through Excel data and performing actions based on each row. 08:25 *🔄 Updating Excel data and writing back to Excel* - Updating Excel data dynamically based on SQL query results. - Writing modified data back to Excel sheets. - Implementing conditional logic to handle different scenarios in the automation flow. Made with HARPA AI
Thank You so much, can you please do a tutorial on how to web scrape all reviews of a product from Amazon, I did everything but I face an error in UI Element. Can You pls help mee
Hi! Wonderful material!! I have a question regarding UI elements. Lets suppose that I am trying to find a specific number (IdInvoice) within a list of values in a website, what would be the solution there? Best regards and thank you again for the content!
I am in Example: Also how to handel this if this is in hello 2 Their is no attributes in it how can i check if the li contain 2 then go to second list and display hello
Hello Thanks for the video. I need to extract data from a web form and then autofill another web form. So for example form A is got fields name, post code and address. Because we get multiple forms I want power automate to say what ever is in the text box for name add it to a variable and then submit it to form B name field box
Iam using a local website having several parent links and each parent link contains different number of links i.e., one parent link contain 10 links and another one contain 15 links. How can I click last link of each parent link directly plaese reply bro
Hi I have a question, can this ways can solve any get details from webpage , for example text also can? And also if the web page updated is that the details still can get?
Thank you, this is amazing. Do you have one a little more complicated. Say you click a button (JavaScript) that opens a popup and then you need to find the element on the popup page. I can see and control the new window. But for some reason any elements are in the main window or %Browser%. How can I have it look in the newly opened window. I can select the element and adjust it as you showed, but the flow can never find it. Thank you.
Eu tinha esse problema, mas encontrei a forma de solucionar. Vai precisar alternar entre as guias do navegador. Acesse a página onde vai clicar para abrir a nova guia. Crie duas variáveis para armazenar a URL atual e a URL que vai querer controlar a nova guia aberta. Vai precisar alternar entregas guias com o comando Send Keys, também copiar por meio de atalhos com Send Keys, copiar para o clipboard e salvar na variável que vai usar. Então abra uma nova instância do navegador anexando essa nova URL a ela. Para voltar à guia anterior, pode fechar a que não vai mais usar com Control+F4, voltar a abrir nova instância do Browser com a URL fã guia que quer controlar.
![PURPEECH - นี่ฉันเองคนที่... (It's me) [Official MV]](http://i.ytimg.com/vi/NuhHd0hOOg8/mqdefault.jpg)
Thank you so much for this material! exactly what I need!
Thanks so much. This tutorial was very very helpful to me. You have a new sub👍
Thank you . Please share the channel so that others also can learn
Your video is excellent! You covered exactly the problem I was struggling with. I’ll try it now!
i have a problem please solve it
how can i repeat the same action with diffreant elemants in power automate?
Example: like i want to select one file than copy it and then paste it in another file than again selecting a diffreant file select it and than paste it in file
please help ME......
🎯 Key Takeaways for quick navigation:
00:27 *🛠️ Setting up SQL connection and connection string*
- Setting up a SQL connection in Power Automate Desktop.
- Creating a connection string manually for faster setup.
- Utilizing variables to store the SQL connection for future use.
02:17 *📝 Executing SQL statements*
- Executing SQL statements within Power Automate Desktop.
- Retrieving query results and storing them in data tables.
- Running and verifying SQL queries within the automation.
04:42 *📊 Working with Excel data*
- Reading data from Excel sheets into Power Automate Desktop.
- Setting variables dynamically to handle changing file paths.
- Iterating through Excel data and performing actions based on each row.
08:25 *🔄 Updating Excel data and writing back to Excel*
- Updating Excel data dynamically based on SQL query results.
- Writing modified data back to Excel sheets.
- Implementing conditional logic to handle different scenarios in the automation flow.
Made with HARPA AI
Hi, how about handling dynamic name? Having problem a problem clicking a button in web page form with telerik form.
Thank You so much, can you please do a tutorial on how to web scrape all reviews of a product from Amazon, I did everything but I face an error in UI Element. Can You pls help mee
I need help on if there is dynamic grid how we can get id or ui element in it ..there it will be repeating same elements. Thanks in advance
Hi! Wonderful material!! I have a question regarding UI elements. Lets suppose that I am trying to find a specific number (IdInvoice) within a list of values in a website, what would be the solution there?
Best regards and thank you again for the content!
I have a question, how to disable the edit option in PAD, TO RESTRICT THE USER EDITING BOT
Your video really helps Thanks for this video
Thank you Abdullah
I am in
Example:
Also how to handel this if this is in
hello
2
Their is no attributes in it how can i check if the li contain 2 then go to second list and display hello
Thanks!
Thank you so much ❤
Very useful.
Hello Thanks for the video. I need to extract data from a web form and then autofill another web form. So for example form A is got fields name, post code and address. Because we get multiple forms I want power automate to say what ever is in the text box for name add it to a variable and then submit it to form B name field box
Iam using a local website having several parent links and each parent link contains different number of links i.e., one parent link contain 10 links and another one contain 15 links. How can I click last link of each parent link directly plaese reply bro
Hi I have a question, can this ways can solve any get details from webpage , for example text also can? And also if the web page updated is that the details still can get?
Thank You.Obrigado.
How do you get the UI elements on the side?
How do i handle pop up windows
Thank you, this is amazing. Do you have one a little more complicated. Say you click a button (JavaScript) that opens a popup and then you need to find the element on the popup page. I can see and control the new window. But for some reason any elements are in the main window or %Browser%. How can I have it look in the newly opened window. I can select the element and adjust it as you showed, but the flow can never find it. Thank you.
Hi, did you get the solution? I am also trying something similar
Eu tinha esse problema, mas encontrei a forma de solucionar. Vai precisar alternar entre as guias do navegador. Acesse a página onde vai clicar para abrir a nova guia. Crie duas variáveis para armazenar a URL atual e a URL que vai querer controlar a nova guia aberta. Vai precisar alternar entregas guias com o comando Send Keys, também copiar por meio de atalhos com Send Keys, copiar para o clipboard e salvar na variável que vai usar. Então abra uma nova instância do navegador anexando essa nova URL a ela. Para voltar à guia anterior, pode fechar a que não vai mais usar com Control+F4, voltar a abrir nova instância do Browser com a URL fã guia que quer controlar.
How about Handle Dynamic URL and UI element?
could u help?
I too have the same issue, Its a hyper link that keeps changing, as my search value is different everytime.
do u solve? cuz i also need download data or details from webpage if the webpage updated how can i do it?
@@brewingstories
video starts at 6:00 for the fast learners
Thank you!!!!!