How to use Excel in Microsoft Power Automate Desktop

No video

How to use Excel in Microsoft Power Automate Desktop

Рет қаралды 9,557

Anders Jensen

Күн бұрын

Пікірлер: 28

@andersjensenorg Жыл бұрын

Did the video help you? - You can then help me by giving it a thumbs up 🙌❤ Thank you 😊

@ALVINMAN452 6 ай бұрын

Great great Video. I saw this video after i saw another several PAD videos (harder) from your channel. I had to sart for this one. Many many problems i had before with Excel. Now i know how to fix the Excel Problems.. Thank you Anders Jensen. Obrigado.

@andersjensenorg 6 ай бұрын

Hey Alvin, I'm so glad to hear, soon I will have new Power Automate Desktop videos going out 😊 Kind regards, Anders

@ALVINMAN452 6 ай бұрын

I´ll be waiting for them. Thank you.

@Itility_Peace_Of_Mind Жыл бұрын

Wow that explanation was so clear and precise, I'll be watching more of your videos.

@andersjensenorg Жыл бұрын

Appreciate the love, thanks, Itility 🙌😊

@Saks05 Жыл бұрын

I found a solution After seeing your video.

@andersjensenorg Жыл бұрын

I'm so glad to hear, thanks a lot 🤩 Kind regards, Anders

@eduardciobanu1380 3 ай бұрын

Hi, Great video! Do you know maybe, how to open all excel from folder(or 1 by one) and rename excel file with cell C2 from each file? Thank you

@andersjensenorg 3 ай бұрын

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 12,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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders

@celenius76 Жыл бұрын

Great video! What actions should I use when I want to refresh a data table in my Excel, copy the entire table and paste it on another sheet on the first empty row?

@andersjensenorg Жыл бұрын

Thanks a lot, celenius. Let's split your problem. I would refresh an Excel table (that's what you want right) with a VBA script (invoked from PAD). For the rest I would just read from one sheet and write to the next (can also be done with VBA). You're more than welcome to post it at my Discord (link is in the description) with a screenshot. We'll gladly help you for free, but you have to start yourself. Have a great weekend. Kind regards, Anders

@rken7201 Жыл бұрын

Thank you for sharing many useful articles about Power Automate Desktop!!! I have an Excel file (xlsm) containing VBA code, and I need to do the following steps: 1. Delete or hide the VBA code (convert to xlsx format?) 2. Restore the deleted or hidden VBA code from step 1. Is there any way to accomplish these steps? Thanks!

@andersjensenorg Жыл бұрын

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 6000+ 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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders

@SandroMochiaro Жыл бұрын

Congratulations on the video. One question please. If I had a spreadsheet with several file paths, how could I update the variable with the Excel path that is declared at the beginning?

@andersjensenorg Жыл бұрын

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 5800+ 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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders

@Jasonmadcow666 Жыл бұрын

Hi! Thanks for your videos. Quick Question; what advantage (other than debugging) to use excel with Automate Desktop instead of just a normal "cloud flow" (AKA power automate)? Thanks in advance!

@andersjensenorg Жыл бұрын

Hey Jason. Great question. If you isolate it: Not much. But in PAD you can use scripts, e.g. VBScript to automate Excel. If you want to do the same in PA, you need to utilize Office Scripts (which is limited to 1600 per day, not optimal for enterprise use). With PAD you can use an Excel file on any local or network drive, with PA it needs to be place in the cloud (e.g. SharePoint, OneDrive or Dropbox). I hope it helped a little. Kind regads, Anders

@duchien04x4 Жыл бұрын

thank for your great videos @andersjensenorg! Can we copy data from excel's cell to somewhere on website?

@andersjensenorg Жыл бұрын

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 8000+ 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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders

@nareshkumar-qo9qy Жыл бұрын

iam using local website in which i have to click a parent link containing child links which may vary in each parent link. So how can I loop through different number of child links of a parent link to scrape data. I used for loop in which starting point I put 1, and increment by 1, but I dont know end point. Experimentally i gave -1 in end point but PAD doesnt gave what I want.

@andersjensenorg Жыл бұрын

Hey naresh kumar Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzfaq.info/get/bejne/lbeCfJCK1JjMaIk.html Have a great day. Kind regards, Anders

@anaosorio5899 Жыл бұрын

Since last update of PAD the excel does not launch. I've already tried to solve by running aplication before launch excel as I tried to finish process. Do you have any other ideias to solve it?

@andersjensenorg Жыл бұрын

@markstones2291 Жыл бұрын

How can I apply a similar action to all of my excel files on a folder.

@andersjensenorg Жыл бұрын

Hey Mark. First you need to use a Get files in folder. Use *.xlsx as File filter. Then you can use a For each and itereate through each file name. Use the CurrentItem in the Launch Excel instead. Kind regards, Anders

@jfrlawal4 Жыл бұрын

I want to use power automate desktop to fill a web page with the content of an excel table . First, I will have to match the beneficiary Id from both table then take each item of the Mother DoB column of the excel table then click on update on the web page and populate. Kindly provide me with step by step guide.

@andersjensenorg Жыл бұрын