Power Automate Desktop: Read Excel and Web Search

Power Automate Desktop: Read Excel and Web Search - Beginners Tutorial

Рет қаралды 14,758

Күн бұрын

Пікірлер: 58

@andersjensenorg 8 ай бұрын

Thanks for all your likes and support 🔥🙌 I've created a 100% free community with 12,000 RPA developers: discord.gg/iloveautomation Here we network and help each other with solutions.

@Okanbrk 3 ай бұрын

dıscord lınk ıs doesnt work sır

@mylovelyhimachal 19 сағат бұрын

Thank you for this video! I am from New Delhi.

@mik32165 4 ай бұрын

This is exactly what I was looking for. Easy to understand without unnecessary information. Thank you!

@andersjensenorg 3 ай бұрын

My pleasure, glad you liked it 😊🙌 Kind regards, Anders

@jazzbrew68 7 ай бұрын

I am in the process of learning Power Automate Desktop and your videos have been extremely helpful. Thanks for what you are doing for the community. Side note - you have an very calming voice!

@andersjensenorg 7 ай бұрын

Hey Jazz, thanks a ton for the nice comment - I'm glad to play a little role in your learning journey 😊 Kind regards, Anders

@JerryEduardo 8 ай бұрын

I started doing my flows two months ago watching your videos. Thank you very much for your teachings and your patience in teaching.

@andersjensenorg 8 ай бұрын

Hey Jerry, I'm so glad to hear - I try to do a mix of beginner and advanced stuff, so expect some different videos in the coming months 😊 Kind regards, Anders

@skjones91199 8 ай бұрын

Hey Anders! Watching in the U.S. (Indiana). Great video, as always! Finishing your PL-500 playlist to help prepare for the test in a couple of weeks! Thanks again!

@andersjensenorg 8 ай бұрын

Hey skjones, thank you so much 😊 The PL-500 playlist could be a lot better, I just didn't had the time to finish it, sorry. Kind regards, Anders Ps. Advanced PAD videos coming soon!

@skjones91199 6 ай бұрын

@@andersjensenorg I earned the PL-500 cert in June! Your material was very helpful in my studying! Thanks so much!

@filipatan 3 ай бұрын

Thank you for an excellent tutorial, your Best Practice tips are very valuable!

@andersjensenorg 3 ай бұрын

1000x thanks for the very nice comment 😊 Kind regards, Anders

@rodrigocelestino6549 2 ай бұрын

Congratulations! Very well!! I'm from Brazilian!!

@andersjensenorg 2 ай бұрын

Thanks a lot for the nice comment, kind regards, Anders (from Denmark) 😊

@philippkowalski1105 7 ай бұрын

😁awesome video, Anders. What a great addition to the automation and data arsenal. You're one of my goto teachers.

@andersjensenorg 6 ай бұрын

Hey Philipp - thank you so much 🥷😍 Kind reards, Anders

@grzegorzzielinski1263 8 ай бұрын

Very informative and inspiring. Keep up the good work, Anders.

@andersjensenorg 8 ай бұрын

Many thanks 😊 Kind regards, Anders

@wandavazquez6320 2 ай бұрын

Awesome job. I learned so much. Thank you!

@andersjensenorg 2 ай бұрын

I'm so glad to hear, did you build it all yourself? Kind regards Anders 😊

@stuartdempster9186 2 ай бұрын

@@andersjensenorg No I'm using it to try to create a loop for data into Excel and then out again. I have built a loop but I'm just looking for tricks to make it better. I'm currently stuck on how to write data from an Excel table row after row into the same Excel line and then copy the results before I write over it with the second line. Your videos have brought me alot closer to that . Do you have extended power Automate training that I could get through in a week - happy to go paid content if I can stretch to the cost. I'm from Brisbane, Australia.

@carlosnavarro6665 23 күн бұрын

You are the greatest!!

@andersjensenorg 21 күн бұрын

Thanks a lot, Carlos 🙏🥳🦾 Kind regards, Anders

@davemotz1139 23 күн бұрын

Hello Anders, your videos are fantastic. Do you have a video that you can recommend to help me with the following: I have an excel list of URLs and want to create a flow that reads each URL from my excel table, then writes the data in the corresponding open columns (e.g. First Name, Last Name, etc.). Do you have a video that shows me how I can accomplish this? Thank you!

@andersjensenorg 21 күн бұрын

Hey Dave, thanks a ton ⭐😎 Yes, I think so: kzbin.info4zmviNtOFwA I streamed the video 2 years ago. Kind regards, Anders

@davemotz1139 17 күн бұрын

@@andersjensenorg thank you so much. your video's are amazing!

@FranciscoSantis-t5v Ай бұрын

THANK YOU SO MUCH , You save me !!

@robertgreen5842 5 ай бұрын

Thank you, Anders. Is it possible to search a website to look for a string and then write back if the string has been found or not?

@andersjensenorg 4 ай бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 13,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

@pthree9449 8 ай бұрын

Thank you so much for sharing :) , Small suggestion...can you please increase screen size. It will help us to see clearly.

@andersjensenorg 8 ай бұрын

Thank you so much for the nice comment. The video is available in anything up to 4K. Can you click the cog wheel on the video and increase the solution? I just tried it on both my 4K setup and on a 720p laptop. Kind regards, Anders

@AlexanderMeusel-w5j 2 ай бұрын

Hello, nice Video 👍🏼 Can you help me? I created a flow in power automate. Its called "create order". the flow looks like this: A user creates an order in my share point list "create order". He also states his information like company name, address, articles and so on. after that, my flow creates a word document, based on a template word doc. later on, that document is also converted into a PDF. now to the issue: all the information is placed into the doc via quick entry blocks BUT it doesnt do that with paragraphs separating the info, so it looks like (NAME,ADDRESS,ARTICLES) instead of COMPANY ADDRESS ARTICLES Is there a function to separate the info with paragraphs or any other solution?

@andersjensenorg 2 ай бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 14,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

@YudiWahyudinoke Ай бұрын

Menyala abangku, sangat bermanfaat..

@furkansimsek33 8 ай бұрын

Thank you so much for sharing :) Can you also make a tutorial, which guide us on how to utilize ChatGPT functions in Power Automate?

@andersjensenorg 8 ай бұрын

Thank you so much 😊 Have you seen this: kzbin.info/www/bejne/mZrIhIWEit6erNE Kind regards, Anders

@austinbright-j3o 4 ай бұрын

What about the case where the result is not always in the same place and I need to “scroll” and find a specific element containing text. Click the url containing the text. Then scrolling to required information and extract data off that second webpage?

@andersjensenorg 4 ай бұрын

@juliofeliu6617 7 ай бұрын

A question, please 🙏: Can the same procedure be used for spreadsheets of google drive ? I'm basically trying to do the same thing, but with a spreadsheet hosted in my drive account. but I have some problems with it :s

@andersjensenorg 7 ай бұрын

Hey Julio, extractly. Either we can work in the UI (not recommended) or we can connect throught he google API. You're more than welcome to post the problem on my discord (100% free) and I'm sure we can help you: discord.gg/iloveautomation Kind regards, Anders

@juliofeliu6617 7 ай бұрын

@@andersjensenorg thx dude 👌

@RelatorioDiariodeCampo 2 күн бұрын

Hi Anders, I'm following your guidelines, but the result that's coming back is %CurrentItem['ID']%, and not the value of this column. It is possible to guide. I have version 2.51.349.24355 of Power Automate Desktop

@andersjensenorg Күн бұрын

Have you forgot the %'s? or did you use '? Kind regards, Anders

@VIJAY-ou2wu 8 ай бұрын

Hey Andreas, I just wanted to know how to extract multiple values/data from web and store it into an excel in the same row??

@andersjensenorg 8 ай бұрын

Hey Vijay, kindly check this: kzbin.info/www/bejne/hoDJfGV3bc6Kd9U 😊

@ElanMarc 5 ай бұрын

Dear Anders Sir, can show how to use "Get Empty Cell"? Because currently im facing a problem when Power Automate Desktop fill the excel into SAP, those "Blank" cell Power Automate desktop also copyover to SAP too. But what i want is those "Blank" cell i want to skip instead of copy. Do you have idea?

@andersjensenorg 5 ай бұрын

@ajaylearningcentre8898 5 ай бұрын

Hello 👋 sir u can make short videos around 5 to 10 minutes.. on power automate.. people will love ❤️ them for sure... tiny videos...

@andersjensenorg 5 ай бұрын

Hey Ajay, great suggestion, which I will start to implement. Thanks a lot 😍 Kind regards, Anders

@asisiphokali333 Ай бұрын

I am from South Africa

@DEEPAKVERMA-x3m 8 ай бұрын

hello Anders Jensen

@andersjensenorg 8 ай бұрын

Hey and thanks for the greeting 😊 How was the video? Kind regards, Anders

@aikikaiparaguay 6 ай бұрын

Great Anders, good job, I have a difficulty extracting the data from the capital, this is the message, can you help me please: Correlation ID: 9ae77903-19a0-4219-b201-56ff1470fdc5 Data extraction element not found.: Microsoft.Flow.RPA.Desktop.Modules.SDK.Extended.Exceptions.InternalActionException: Data extraction element not found. ---> Microsoft.Flow.RPA.Desktop.UIAutomation.WebAutomation.Core.DataExtraction.WebExtractionException: Data extraction element not found. at Microsoft.

@andersjensenorg 6 ай бұрын