My new complete Excel with Power Automate guide is here: kzfaq.info/get/bejne/htJzobx10MjbY30.html Thanks for all your support 🙌🔥

Thank you Anders. Power Automate is such an amazing software - but it is nothing to beginners like me without sophisticated trainers like you!

Before watching this, I had a feeling that implementing email notification with condition on a row in excel is so difficult. Thank you. Really cool stuff.

Do you want to get an intro to Microsoft Power Automate? Watch this Tutorial for Beginners - kzfaq.info/get/bejne/pdOBYMlyq5q1oH0.html

This video was extremely helpful. Thank you!

man your accent is sooo good to listen to.

Even timestamped the video. Absolutely clutch!

Great video! Thank you so much from Argentina!

Thanks for this detailed tutorial! Finally figured out how to make data transfer to work from SmartSheet to Excel.

This is incredible!!!! Thank you so much.

Thank you for the guide. Greetings from Peru

Hi Anders! Cheers from Buenos Aires, Argentina. Thank you so much for the video, it was super easy to understand! A couple of weeks ago, I started working with Power Automate, and I love it, although I'm going crazy because I don't have any previous training. I'm trying to follow Microsoft's learning path, but I think it's kind of complicated and sometimes the concepts aren't very clear. What do you recommend I do? I need to learn Power Automate, Power Apps, and Power BI (seems like the whole Power Platform, right? XD).

This is incredible and great stuff. thank you so much for this guidance.

thank you this is a lot easier then VBA

Hi. Really nice video! Wanted to check if we can apply logic to the format of the columns as well? So if there is text value in number column then delete the file and send notification to someone

Great ! You make a great job !!!! Thanks for the video

This tutorial is really good. I learned so much from it. I am so glad I found you. Thank you so much.

Hello Do you know, How do you extract xpath Datas From the web With Power Automate. Maybe you made a video ? It would help me a lot. Thanks again for your videos. cordially

Great Video - thanks - One question, I only want this to email on 'new entries' and not all the previous cells who meet a certain criteria, each time I schedule to run it ? can you advise /

Great stuff, I hope you have more of that 😂

Very nice stuff. Thank you so much for this guidance. I've used that on my work to control and report viscosity levels of oil lubricants and also analysis of vibration of industrial blowers's gearbox used in cooling towers.

Extremely useful demo. Thanks!

thanks a lot! Can this flow run automatically each time a value add to excel?

Thank you for the amazing tutorial. Quick question if my table in excel has a column that should contain a picture in each row (coming from a Sharepoint Document Library), how can I add that picture?

Thank you for your videos, but do you know if we could use google sheets instead? Say suppose if we have a google sheet that has the data and we want to use the data to fill in any website form fields.

Very Good explanation Jenson and i am able to replicate without any issue on my workflow. String to float convertion is major part : float(items('Apply_to_each')?['sale'])

Great video. I have a question, do you know how read an excel table and send all the data (formated) via email to someone?

Thank you. I look forward to applying these ideas.

Love your videos! I have a flow that creates a record of the subject line, email body and email receive date on an excel document on OneDrive but I want make it UPDATE a record instead of add a record if an email arrives and has the same subject line. Been trying to figure it out using a condition control for a couple of weeks but not having any luck. Any pointers?

Amazing video, thanks very much

Thank you - very helpful.

amazing video! is it possible to update the specific cell which is not the table data?

very helpful-thank you!

how do you put your manually trigger into a drop down list in sharepoint. do you have a video on that ? i did something similar like yours with a manual trigger, now i need it in the sharepoint drop down list under automate. Thank in advance.

Anders, nice video. thank you for shering it

Hello Anders Do you have any videos showing how to run a Marco in Excel With power automate?

Thanks for this! I was wondering if it's possible to trigger an email when someone adds input to an existing column and row? For example, if a column is mixing information and they're being asked to fill that in. Is that possible?

This really awesome, but can you please explain how to add a new column in data table and update information in it. Thanks

Hey Anders, Is it possible to copy and paste a column in excel using power automate? That is, what if (instead of the configuration you had in the video) I had: ID | data Name | data Sale | data is it possible to copy column 2 and paste to make it: ID | data | data Name | data | data Sale | data | data ?

thanks for the video it helpfull. i have a image upload on my form it add the data to excel with the power automate but i can't see the picture in the table can you help.

Thanks for the informative video and explaining the use of float function for converting string to integer. I will really appreciate your help here- Can we use conditions with dates for mail merge in Power Automate?

Thank you for this video, I followed these steps but i am facing issue to receive an email in the last steps, flow works well.

Can u please teach us how to automote excel sheet attachement to master excel file in SharePoint

In desktop automate , one email have multiple data to crop. I am able to successfully crop (using flag between two text) only first set of data. I not able to crop the next ...set of text data in that same email. How to do that?

Hi Anders. I have small Doubt, can we Share daily report trough the Excel Sheet and Send a mail a particular user using Power Automates. If in case It is Possible Please guide Us.

Hello! First of all thank you for this video, it helped me out to get started with a project were I am really stuck. I would like to get some extra help. I am working in a flow to email sales associates as well. But the difference is that my table has also a column specifying the concept of the sale. Something like this: ID | NAME | CONCEPT | SALE This table comes from processing another table in power bi, where I created a column telling me if the seller will get an email or not. My problem is that, if the seller got outstanding sales in more than one concepts I don't want them to get multiple emails. Instead I want them to get just one email mentioning all the categories where he got a good amount of sales. How can I approach this? Somehow a query which could let me group the concepts of the same seller or something like this, but I don't know how to do this. Regards!

Hello, Could you please make video on connect to exchange server or connect to shared mail box

Hi, thanks a lot for the video...is there a possibility to post videos to instagram/facebook from an excel spreadsheet using power automate

Thanks for the videos.. i set it up and run flow for testing .. it works fine. But it is not sending out the email notification at the scheduled time. i set this up for weekdays Mon to friday , is it like it starts from the next day after it has been set

Sir pls advice how to add attachment in table th. Power automation.

million thanks

Hi Anders, Thanks for all your videos, they are really useful! Thanks to them my productivity has potentially increased ;) I have a question where you might know a solution please... I have to create a flow like in your video, one excel that is updated every time that a form is filled and it should send an email when one condition is true. The issue that I have is creating the condition. My condition should be : every time that several fields are duplicated (same country, same element, same request) then is a duplication and a email should be sent. I am struggling adding this condition. Could you please give me a hint which would be the best way to proceed? Many thanks and all the best! Maria Victoria

Muchas gracias por tu ayuda. Excelente tutorial.

Do you work on contract if I wanted to hire you to complete and build these systems for my business? If so what is the website or email I can reach you at?

Nice video, thank you! But I cannot follow... (@3:09...) I cannot see where you define the table name "PersonalSales". It's not the file name and not the sheet name. Where do you name it?

I have created the flow for stroing the email into excel , then I have used list of rows present in a table function for sending an email , but it is going to sent an email to every one who is in that list, I just want to ask how to control it, because i am receving an email on hourly basis, but i cannt figure out the condition .. Pls Help me in thiss...

Is there anyway that you can do this where the format tables function is done in Power Automate instead of Excel. I would be receiving spreadsheets that are unformatted.

I have tried to use a MS Teams group > File Location as Location for Excel action but it does not give me any "Table" item to choose.. says no item.. Can you please help? Note: I have selected the correct "File" path

Hi, I need a help. I have an excel file with some pivots and it is connected to powerBI. I have uploaded it to Sharepoint and I want to do auto refresh all pivots tables by PowerAutomate flows. I created a script on excel web and then I created a PowerAutomate flow to run that script. but whenever I do trigger that script through powerAutomate it does not refresh the connection of excel file on sharepoint. script is workring fine if I test it on web excel but does not work when try to do that from PowerAutomate. Any suggestions Please

Hi Andres, it really helpful.. thanks for your tutorial. Do you have any idea, how to send a alert mail when certain text is find in a website, like sending an weather alert when certain type like "Server Thunderstorm, Heat wave, fire warning by align to our customized mail format...

Hey, thanks for the great vid! I had a question, is it possible to access values on the next row of a table using the "list rows present in a table" method? In this case, I'd like to send an email containing information from multiple rows in a cell, but im not sure how thats done through power automate. Thanks in advance :)

I wonder what scenarios this function helps.. I’m a bit lost as to when it’s useful

Hello! I'm trying to create a report from a Sharepoint list and send an email. Do you have a video for something like that? Thank you!

Hey man thanks for your tutorials. Wondering whether you've got any idea on how to position an address on a letter so that it shows on a window envelope using uipath.

Can we download specific excel reports or the attachments from Microsoft outlook using Microsoft Power Automate?Pls let me know if it is possible for a specific report?

How do you get the window with Dynamic content/Expression details? I follow each step and this window doesn't pop up when I remove "value", therefore can't input the formula and the flow doesn't work, obviously. Any ideas?

I don't get one drive option in document library

Hi Anders, Can you help me in extracting the tabular data from the email body? I receive emails from different vendors, which have similar details like Ids, dates, description, status etc in the table in email body. I need to track them in Excel. To parse this text using html is so difficult as I am not aware of html..do we have any other way to automate this using flow? Looking forward to your response! Thank you!

How to pull email address from excel and add that email in sharepoint people picker field list column??? I tried but it is showing me the specified person not found. Please help...

Hi Anders. How do I add multiple items from excel (so all the rows that meet the criteria) to a single email. Meaning I want to send one email with all the data required pulled from Excel.

great, but on the condition you could click to view the code and copy from inside the apply to each instead of writing the whole code :)

Hello Jensen, I have created a flow that runs monthly. What it does it grab all data from excel sheet 1 and put them into excel sheet 2. My flow looks like: Recurrence>List rows present in a table>add a row into a table. But the problem is my excel sheet 1 has 13 columns (Dr. Name, January, February, March...........December). In January, I input January data in the January column, in February, I put the February data in the February column. The flow that I have created already pulls the January data fine. But when it runs in the month of February, it pulls February data and January data too. I just want to get each months data automatically, no duplicates are expected. Could you please suggest me how can I do that using power automate?

Yeah, team Bill!

I love your videos, I am a new subscriber to your channel. I'm wondering is there a way to create a video for the following flow for a daily agenda? 1. Reoccurring email - Mon to Fri 2. For 2 people (this variable never changes) 3. Same template in the content of the email example "Hi ...please see attached for agenda" the only thing that does change in the email is the subject-- fx= addDays() 4. It will always be the same excel spreadsheet and document. (the name of the document and spreadsheet never changes.) The only thing that changes is the table (which can be manually updated). I keep getting apply to each and it sends like 12 rows of data. This may seem very simple but I am having trouble adding the attachment to the flow. It would be nice if you can make a video for that. Thank you :)

Power Automate is not pulling data from Formulated excell cell that was calculated from MS form data, pls help

Dear @Anders, I am working on a project using Flows and a little bit of guidance from your side will be very useful? How could I contact you? Many thanks for your all work.

Looking good. I am wondering if you can open any application (not necessarily MS suite one but from another vendor that is not listed in the integrated vendors' list) and check things in this app and then apply if yes/no scenarios depending on what you checked. For example examine if the check box is selected, or which drop-down menu item is selected, or what text is entered into the box etc. Say if I want a certain checkbox to be selected I cannot just open the app and select it. I first need to if it is selected or not. Then if it is not select it - select, otherwise - do nothing. This way I can ensure that every time I run the automation it is not screwing up the configuration. By doing this I can control the configuration is always consistent with my expectations and fix it if any deviations occur. I can also build new verifications and config updates if a new config is introduced later on.

Hi Anders, its a very informative video. I do have some questions. 1. Is it possible to use the information from one excel source (in table format) to have an action to fill details of say 5 different files ? 2. In terms of the excel formats, is there any restriction on the format (eg. csv, xlsx, etc)

Hello, Is there any method to get a reference value based on an index with a combination of power Automator and online excel? As an example, if I input values using flow such as name, preference, and if I need to automatically update the excel cells such as email address, contact number of that specific person. Can I use the flow to create that logic? is there same function like "VLOOKUP" (I prefer to create logic within the Automator other than within the excel)

This is great. Thank you for making power automate w excel so simple. Do you know of a solution to combine CSV or excel files together into one document from a SharePoint folder? I know I can do this in PBI and other software but I want to do this w power automate. There isn't anything out there on Google too.

can we use power automate and schedule data extract from dynamic table from a website into Excel. I'm not able to use excel webquery

Awesome video! Question - I have a table with list of offices and an email for each office. I created a Form that asks the user to select an office.. Based on their selection, I want to send a notification email to the email listed in the row of that office. Is this possible? Would love your feedback :)

Hi, great video. But I what to do someting a litlle diferent. I need by pressing a button, get some row from an excel sheet, send an email with this content, and finally add this content to an Excel database. can we do this kind of thing? thank you

Can the same be created but not from the manually triggered but when an email with an excel report is received?

hi anders. My excel files are on my desktop. Am I able to use Powerautomate cloud to read the data in this excel file and upload them into a google form?

thank you

How would I capture the changed lines of my Excel document, and send these changes to another table?

Hi Anders, In our project we manually copy data from our local excel to Excel in SharePoint repeatedly. We want to automate the task. Could you please help.

I have a query. how did you PersonalSale name appear in dropdown under table field?

Thank you! I have a question about microsoft 365. I try to get information to another onedrive (but im not the owner of this file). I remember in gmail i use importrange to get information to other excel but with microsoft i cant. Please, if you know how its really helpme a lot!

Hi Anders. Am new to Power Automate and have been looking at videos to solve a specific issue which I cannot seem to crack. We need to input information into a complicated excel sheet (some just single values, and one an array). Now the issue is that the Excel functions seems to want a well defined simple table in the Excel. What would you use if i need to add single values to certain (static) cells and also some to an array. I am passing the information to Power Automate through an API (that seems to work fine). It is getting the information into the Excel (on sharepoint) that is the problem. Thanks in advance :)

Hi Anders, How to update the excel using email (Outlook 365) subject with previous Date, and current start time, and end time.

please help me sir with this error (ActionBranchingConditionNotSatisfied. The execution of template action 'Send_me_an_email_notification' skipped: the branching condition for this action is not satisfied.)

If I use a list and add excel as an attachment. I want power automate to trigger the process and send the email based on the excel line after creating the action. Each line in the excel has had very information which I need to insert to the email.

Hi, When I use paconn login command in the power shell. getting an error saying the term paconn is not recognized as the name of a cmdlet.

Hello! Is there a possibility to send datas from Emails to Excel using Power Automate? Thanks.

Hello all, i want to create a power automate flow with two conditions in the same flow. The problem is to define the second conditions, because its a Number. As an Example: 'Value' greater than 1000. I get always a error message. Best regards Andreas

Hi Anders. First of all - Nice video. I have recently been starting to work with this along with Microsoft Forms. This may be a very simple thing for you, but i'm hoping you can help out. When creating a form, and someone replys it creates a overview and shows the number of each reply. I want to use this to sending information out, so it automatic inserts data into my row on excel which we are sharing on teams. What i want is to instead of inserting the same answer 20 times, i just want to be able to insert the number 20, and in the overview it shows 20 and not just one for like overview of how many laptops of each model we are using? is this possible ? I hope it makes sense. Thank you in advance.

How did you get Personal sales option, i am not getting that, you didn't show that part of the step

Hi @Andres Jensen could you please let me know how to filter a one column in one drive excel file.