Excel Automation in Power Automate Desktop | Read data from Excel in Power Automate Desktop #02
HTML-код
- Опубликовано: 27 июл 2024
- 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
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!
Was very useful. Thank you!
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!!!
Very valuable and informative video
Clear cut explanation for beginner. Kudos.
Nicely explained madam..
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 ...
You are welcome, thanks
Excellent explanation😊
THANKS! You just helped me figure something out!
Excellent video! Loving this series on Power Automate! I have also pressed the BELL icon on your Channel to see the upcoming videos immediately..!
Thank you very much for such an exciting guide!!!!!
Found the video very useful. Content was clear and explanation was very good. Thanks !!!!!
Thanks a lot ma'm , your work deserve a hats off
Hello once again good video ❤️🔥
Very much appreciated...!
Excellent tutorials i was able to follow everything. Thank you team QAL please keep up the great work.
Thank you so much! It helped me with my project and saved me hours of research.
Thank you for sharing your knowledge! Great video. Wish you will bring more 😁
Great content, thank you!
Very good video, I learnt a lot, thank you
Really useful thank you,
An well explained demonstration and a practical use case. :) I will keep my eye for upcoming demonstrations.
Thanks, please checkout the next video here - ruclips.net/video/r7RwdpkN-Fg/видео.html
Please Add more videos explaining all commands in power automation
Nice Video,
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.
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.
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?
You are welcome. You can filter excel data table using For Each and If action as shown here - ruclips.net/video/eBC3pBEZ5uc/видео.html
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.
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?
Hi, please let me know what expression you provided in If action -> First Operand ?
The same error for me
1st View
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.
Hi, please let ,me know the expression you added inside If
@@qualityassurancelab7764
Hi and thank you for replying me.
Inside my "IF" expression are
First operand: %CurrentItem['Percent']%
Operator: Less than (
Hiie, Can we read group of excel files from a folder ?
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
Hi how i can get the single column it seems %CurrentItem[""Salary"]% This is no longer working
what if my excel file is not in my drive but it is on my ONEDRIVE BUSSINES FOLDER ONLINE?
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
If you’re interested in sending the data to SharePoint or some other dataset after reading the Excel data, then check this video: ruclips.net/video/ONl7B9-9lPU/видео.html