Excel Automation in Power Automate Desktop | Read data from Excel in Power Automate Desktop #02

This video explains multiple scenarios to read data from excel file in Power Automate Desktop
0:27 - Create a flow in Power Automate Desktop
0:48 - Launch Excel
2:37 - Read data from Excel
4:10 - Get first free row or column
7:54 - Close excel
8:32 - Write data to text file
13:21 - For Each Loop
14:34 - If Condition
=========================================================
Microsoft Power Automate Desktop Tutorial Playlist:
• Power Automate Desktop...
Microsoft Power Automate Tutorial Playlist:
• Power Automate Tutoria...
Automation Anywhere A11 Tutorial Playlist:
• Automation Anywhere A1...
Automation Anywhere A2019 Tutorial Playlist:
• Automation Anywhere A2019
UiPath Tutorial Playlist:
• UiPath Tutorial
JMeter Tutorial Playlist:
• JMeter Tutorial
Git and GitHub Tutorial Playlist:
• Git and GitHub Tutorial
Subscribe for more tutorials - / @qualityassurancelab7764
Connect with me for some interesting updates here -
LinkedIn - / quality-assurance-lab-...
Facebook - / quality-assurance-lab-...
Twitter - / labassurance
Medium - / labassurance
Join Channel Membership - / @qualityassurancelab7764

[@qualityassurancelab7764]

Hi Guys! Hope you found this video useful. Please like, share and subscribe to my channel. This will motivate me to create more good contents. Thanks!

[@tele2662]

Was very useful. Thank you!

[@rpjlee]

The only video that actually teaches you how not to "hardcode" last column and row. The rest of the videos with millions of views are just "hard-coding" the columns and rows. Thank you for this amazing videos. It should have 4.76 million views. Seriously!!!

[@gangadayal4585]

Very valuable and informative video

[@codebychetan]

Clear cut explanation for beginner. Kudos.

[@pavankumar-tm8dr]

Thank you very much you done great job 👏 For helping people who wants learn And more over you have such good teaching skills nice explanation with examples Tq ...

[@qualityassurancelab7764]

You are welcome, thanks

[@greggapowell67]

THANKS! You just helped me figure something out!

[@iMadeThisThat]

Excellent video! Loving this series on Power Automate! I have also pressed the BELL icon on your Channel to see the upcoming videos immediately..!

[@jamesyao8288]

Thank you so much! It helped me with my project and saved me hours of research.

[@aminvogue]

Thanks a lot ma'm , your work deserve a hats off

[@mharish83]

Very much appreciated...!

[@notonurnelly]

Really useful thank you, An well explained demonstration and a practical use case. :) I will keep my eye for upcoming demonstrations.

[@qualityassurancelab7764]

Thanks, please checkout the next video here - kzbin.info/www/bejne/qGi1qJemoLNgfMk

[@avneet50500]

Found the video very useful. Content was clear and explanation was very good. Thanks !!!!!

[@knightz273]

Excellent tutorials i was able to follow everything. Thank you team QAL please keep up the great work.

[@nuinhuin7325]

Thank you for sharing your knowledge! Great video. Wish you will bring more 😁

[@sandeepallaka1988]

Excellent explanation😊

[@goviktor]

Thank you very much for such an exciting guide!!!!!

[@RC-nn1ld]

Very good video, I learnt a lot, thank you

[@mlhtest5928]

Great content, thank you!

[@joswadsouza9849]

Hello once again good video ❤️🔥

[@shashikkantlohar1163]

Nicely explained madam..

[@guatkiemtan2557]

Hi, thanks, this is really useful. do you have any video that explain how to copy data from one excel and append it into another excel? i could not find it in your video list.

[@sathishbe2010]

Please explain get cells contents as text in read excel activities

[@umanggulati6840]

Thanks for the great video. Is there a way we can filter the excel data table? Either while reading from excel or filter the datatable in Power Automate Desktop?

[@qualityassurancelab7764]

You are welcome. You can filter excel data table using For Each and If action as shown here - kzbin.info/www/bejne/m3OmZKN4er9oq8U

[@aquabestindian]

Thanks, this is great! Could you please help me with a problem, Whenever a new Excel file is placed in a SharePoint folder, I want to read its contents and send emails accordingly. Each Excel file will have a different name, but the table design in it will be the same.

[@smadasamy81]

Nice Video,

[@sravanipula8642]

Please Add more videos explaining all commands in power automation

[@udaykumarsayala5034]

Hi , Videos are very useful to me to learn the Power automate. I want an scenario which you read the excel file. For example if there are 255 columns and 20 rows based on this 255 columns I 1O columns information along with rows data as well. Like that column names like A, B , C,D, E, F, G, H , I, J , K, L M, N, O, P ,Q for this columns we have rows values are also available in that columns I want columns like A, B,C,F,I only. Can you help me how to filter this values.

[@yogeethasusparsha4547]

Thank you!! Very useful video.. I tried to create the same workflow and I get If Action error that says - 'Column or property 'Salary' not found.' I do have this column in my excel workbook. Can you please help me on this?

[@qualityassurancelab7764]

Hi, please let me know what expression you provided in If action -> First Operand ?

[@RescueismyfavBreed]

The same error for me

[@kaditya4902]

Hiie, Can we read group of excel files from a folder ?

[@dicksontantacksinn3493]

Hi and thank you for your video. I have tried to create a sample use case like yours, but i got a error message on the function "IF". The error message told me that "Column or property 'Percent' is not found. But in my excel file, I got input data under 'Percent' but it still mentions that could not be found. Can you please help me on this? Thank you\ and stay safe.

[@qualityassurancelab7764]

Hi, please let ,me know the expression you added inside If

[@dicksontantacksinn3493]

@@qualityassurancelab7764 Hi and thank you for replying me. Inside my "IF" expression are First operand: %CurrentItem['Percent']% Operator: Less than (

[@lookman06]

Hi, how do you get the excel file to open automatically ? for my case the excel only pops up in the shortcut taskbar but it does not open

[@amruteshammu8245]

I have a doubt that if we create a new header column as status and if salary is greater than 10k it should display as red otherswise it should display as green can you please say how to do it

[@tylerkolota]

If you’re interested in sending the data to SharePoint or some other dataset after reading the Excel data, then check this video: kzbin.info/www/bejne/hX_PaHVvYp6fhrc

[@sathishbe2010]

One doubt all value of variables used in read from excel activities

[@soumyadas02012]

1st View

[@RenoTrader]

what if my excel file is not in my drive but it is on my ONEDRIVE BUSSINES FOLDER ONLINE?

[@neerajkhadilkar2329]

Hi how i can get the single column it seems %CurrentItem[""Salary"]% This is no longer working