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!!!
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 ...
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?
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.
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.
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.
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 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 and thank you for replying me. Inside my "IF" expression are First operand: %CurrentItem['Percent']% Operator: Less than (
If you’re interested in sending the data to SharePoint or some other dataset after reading the Excel data, then check this video: ua-cam.com/video/ONl7B9-9lPU/v-deo.html
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 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!!!
Clear cut explanation for beginner. Kudos.
Excellent video! Loving this series on Power Automate! I have also pressed the BELL icon on your Channel to see the upcoming videos immediately..!
Found the video very useful. Content was clear and explanation was very good. Thanks !!!!!
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
THANKS! You just helped me figure something out!
Excellent tutorials i was able to follow everything. Thank you team QAL please keep up the great work.
Thank you very much for such an exciting guide!!!!!
Excellent explanation😊
Thanks a lot ma'm , your work deserve a hats off
Thank you so much! It helped me with my project and saved me hours of research.
Very valuable and informative video
Thank you for sharing your knowledge! Great video. Wish you will bring more 😁
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 - ua-cam.com/video/r7RwdpkN-Fg/v-deo.html
Great content, thank you!
Hello once again good video ❤️🔥
Very good video, I learnt a lot, thank you
Very much appreciated...!
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 - ua-cam.com/video/eBC3pBEZ5uc/v-deo.html
Please Add more videos explaining all commands in power automation
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.
Nicely explained madam..
Please explain get cells contents as text in read excel activities
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.
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.
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
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 ?
If you’re interested in sending the data to SharePoint or some other dataset after reading the Excel data, then check this video: ua-cam.com/video/ONl7B9-9lPU/v-deo.html
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 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
what if my excel file is not in my drive but it is on my ONEDRIVE BUSSINES FOLDER ONLINE?
Hi how i can get the single column it seems %CurrentItem[""Salary"]% This is no longer working
One doubt all value of variables used in read from excel activities
1st View