Power Automate Desktop : Module 3 : Excel Automation - 1 (Launch Excel, Read from Excel,Close Excel)

Рет қаралды 75,082

3 жыл бұрын

#powerAutomatedesktop #microsoftpowerAutomatedesktop #powerAutomate #microsoftpowerAutomate #RPA
In this Module,
we will learn Actions in Excel Automation using Power Automate Desktop
1.Launch Excel
2.Read from Excel Work Sheet
3.Write text to a file
4.Close Excel
Microsoft Power automate Tutorials for Beginners
Module 1 : Introduction To Microsoft Power Automate • Microsoft Power Automa...
Module 2 : Sign up and sign in for Power Automate • Microsoft Power Automa...
Module 3 : Create a FLOW in Power Automate by using Templates • Microsoft Power Automa...
Module 4 : Build a first FLOW in Power Automate • Microsoft Power Automa...
Module 5 : Build a flow to connect Microsoft SQL Server • Microsoft Power Automa...
Module 6 : How To create and Use of Team Flows • Microsoft Power Automa...
Module 7 : Introduction to UI Flows Using Power Automate • Microsoft Power Automa...
Module 8 : Working with Connectors • Microsoft Power Automa...
Module 9 : How to Create An Approval Workflow (30 min- Detail) • Microsoft Power Automa...
Module 10 : Run a flow on schedule || Recurring Flows • Microsoft Power Automa...
Module 11 : Create a Manual Flow or Instant Flow • Microsoft Power Automa...
Module 12 : How to Export and Import Flows • Microsoft Power Automa...
Module 13 : Team Flows • Microsoft Power Automa...
Module 14 : Submit a flow as Template • Microsoft Power Automa...
Module 15 : Create a Flow On Mobile || Power Automate MobileApp • Microsoft Power Automa...
Module 16 : Overview of Connectors • Microsoft Power Automa...
Module 17 : Triggers & Actions of Connectors • Microsoft Power Automa...
Module 18 : UI Flows - Win Automation and Selenium IDE • Microsoft Power Automa...
●Please Subscribe Here to learn more about RPA➤
kzfaq.info...
●Join #DevOps and #RPA Face Book Group for updates➤ / 166692824556293
Thank you for Joining With us.
As Always, Please do Like, Subscribe and comment.
To Support through Donations: www.paypal.me/learningtechnol...

Пікірлер: 62

@karma40mok 3 жыл бұрын

Thank you for your lectures of power automate. According to these things, I could use RPA easily.

@LearningTechnologies 2 жыл бұрын

Thank you

@thebhaskarjoshi 2 жыл бұрын

I really appreciate your efforts towards teaching new technology

@LearningTechnologies 2 жыл бұрын

Thank you bhaskar

@steadyballer Жыл бұрын

Thanks for the tutorial, most helpful. Would like to ask if PAD can also read content from Word document? Can't find this action in PAD. Thanks for the advice.

@MelwynRodrigues 3 жыл бұрын

Nice explanation! Thank u Ameer, Thank u LT!

@LearningTechnologies 3 жыл бұрын

Thank you Melwyn

@kancharlasan 2 жыл бұрын

Sir, the explanation was crisp and clear. Really worth learning from you

@LearningTechnologies 2 жыл бұрын

Thank you sanar

@triflemonster 3 жыл бұрын

Thanks for much. Is there a way to open the most recently modified excel file in a folder ? I.e the most recent? Thanks in advance

@soldeal4422 2 жыл бұрын

great video really good, good teaching thank you

@LearningTechnologies 2 жыл бұрын

Thank you

@rohittembhare6412 3 жыл бұрын

Hello Sir, can we enter a "count of not empty rows" in the property of read from excel action at end row. if yes then please explain how we can "count the not empty rows" in excel and csv both

@FayezEneim 2 жыл бұрын

Great session

@LearningTechnologies 2 жыл бұрын

Thank you Fayez

@nomoreospf 3 жыл бұрын

Very good. Thank you

@LearningTechnologies 3 жыл бұрын

Thank you

@lisam8986 5 ай бұрын

In step #2 you chose range, can a table be used? If so would that be the third option “from selection”?

@ambrosedenny 3 жыл бұрын

Clearly Explained, Can you please create a video on Excel file consolidation to a master file.

@LearningTechnologies 3 жыл бұрын

Thank you. keep learning and keep watching

@soumibandyopadhyay2110 2 жыл бұрын

I have a csv file, which I use to separate the data into columns and then save it as the same name as csv file, but in .xlsx format. I use the Close Excel function and then Save the document as with Document Format .xlsx and the path , I want it the name of the csv without the extension. Could you suggest how to do it? Thanks in advance,

@vmohakrish Жыл бұрын

Thanks for video . Do you know how to get last row of a column

@ariehashimie 3 жыл бұрын

Hi Sir. Good video learning you post for sure. Im new into power automate and with your video gave lot of information especially handling the desktop version of power automate. And perhaps sir will it be possible for you to post on how to handle empty row in excel file. There is no video that close to how to handle it in power automate dekstop. Most of it focus more on web version. Thank you in advance sir.

@LearningTechnologies 3 жыл бұрын

Thank you

@twangt 3 жыл бұрын

Hello! Great video! :) Is it possible to maybe make an example of how to use the OCR action, to extract text from an image and output it with searchable text. Could be very useful! :) Thanks

@LearningTechnologies 3 жыл бұрын

Sure Alexander

@twangt 3 жыл бұрын

@@LearningTechnologies Great!

@withnuri6388 3 жыл бұрын

Clear

@anilyadav-rt4sr 3 жыл бұрын

Thanks

@LearningTechnologies 3 жыл бұрын

Welcome

@vigneshg9648 3 жыл бұрын

How to filter an excel data and work on the filtered data instead of original data?

@tariqraza5405 3 жыл бұрын

Fantastic Bro, can we play power automate with power query as well..?

@LearningTechnologies 3 жыл бұрын

Sure let's try

@lasaventurasdesharonagudel9745 3 жыл бұрын

Hi Learning Technologies, Thanks so much for the video, is very valuable information. Could you please guide me about, How to open different excel files in a folder? For example: I have 5 files in a folder and I need to open one at a time and read de information. I know that i need a loop, but, how to go directly to each file. Thanks

@LearningTechnologies 3 жыл бұрын

There is one action where you can get the information of files in folder i.e get files in folder. By using that you can get the information kzfaq.info/get/bejne/q915dtqA0rezemg.html

@lasaventurasdesharonagudel9745 3 жыл бұрын

@@LearningTechnologies Thanks so much

@LearningTechnologies 3 жыл бұрын

Welcome Jonathan

@ievaraj6961 2 жыл бұрын

Sir can you are explain hot to log in outlook and download attachments please

@kraken8701 5 ай бұрын

Here if i modify data in excel after run flow there is not get that data in text file , what to do for this query??

@dafysiby6469 3 жыл бұрын

But I have latest version for Power Automate. Where I can get the "Launch Excel" from the "Excel expand"?

@LearningTechnologies 3 жыл бұрын

its power automate desktop not power automate online

@niranjanbharambe4546 2 жыл бұрын

Hello Sir, Thank you for making it easy for us by your videos. could you pls help me i am stuck in one scenario, i have to read multiple xls file and save it to xlsx..which am abke to do it for a single file by launch excel and close excel . But when i do it for multiple file i used foreach loop to read all the xls and that variable i.e "currentItem" i passed it to close excel document path. the issue is file gets launch, but did not get save it in xlsx format .could you pls advice

@LearningTechnologies 2 жыл бұрын

Welcome

@analyticsadda6080 2 жыл бұрын

How to make rows and columns dynamic

@Wardlaw777 3 жыл бұрын

How do i set it to read from a specific sheet with a workbook with multiple sheets?

@sempaxbolong6259 3 жыл бұрын

Use action set active excel worksheet

@ugochukwunwabu3956 8 ай бұрын

what if you dont know the last row in the excel and you want it to read everything in the excel?

@varungupta7024 3 жыл бұрын

there is also problem with signing in account after clicling on flow

@christophedecrouy3822 8 ай бұрын

hello, can we connect for a paid consultation, I have issue in my flow with Excel? Thanks

@abeybrams2366 10 ай бұрын

Hellow Sir Where can we get the excel data?

@avinashsingh6691 3 жыл бұрын

How to make data range dynamic?

@shashankgaikwad5825 Жыл бұрын

Any clue?

@varungupta7024 3 жыл бұрын

how to create flow with no triggers option

@analyticsadda6080 2 жыл бұрын

How can we achieve this in power automate not using power automate desktop

@LearningTechnologies 2 жыл бұрын

There is connectors for excel online

@poojalalwani1226 3 жыл бұрын

Can we not use google sheets instead?

@LearningTechnologies 3 жыл бұрын

Yes. You cannuse pooja

@OnlyIasReader76 Жыл бұрын

Can you make all excel activity

@LearningTechnologies Жыл бұрын

Sure

@OnlyIasReader76 Жыл бұрын

Could you solve me ,one problem sir

@OnlyIasReader76 Жыл бұрын

Please solve it

@OnlyIasReader76 Жыл бұрын

Sir, how to convert flow into zip