Microsoft Power Automate | Add data to Excel, get data from Excel, Conditions and Send Email | Guide

This video tutorial shows how to add data to Excel (add row via input form in Power Automate), get data from Excel to Power Automate, and then use a for each row on the data in a table. Finally, send an email based on the results of the conditions.
You could also watch:
🔵 Microsoft Power Automate Tutorial for Beginners - • Microsoft Power Automa...
🔵 Microsoft Power Automate Cases - • Microsoft Power Automa...
GET HELP IN MY POWER AUTOMATE GROUPS:
👨‍👩‍👧‍👦 Facebook: / 754059285247921
👥 LinkedIn: / 12566435
📚 Best Power Automate Book (affiliate) - geni.us/cKCS
00:00 Intro to this Power Automate Tutorial
Today's tutorial is about Power Automate, Excel, and Outlook. In the first use case, we update Excel tables with Power Automate, and in the second use case, we will apply conditions to Excel data and send emails based on those conditions.
00:24 Update Excel Tables with Power Automate
Creating a Power Automate flow to make data entries to an Excel table.
01:32 Add Input (manually from user - text and number)
In our manual trigger, we will define what input Power Automate should take from the user.
02:21 New Step - Excel Online (Business)
02:29 Add A Row Into A table
The 'Add A Row' will add a row into a defined Excel table.
06:15 Create a Flow (Import data from Excel, Condition and Send Mail)
How to create a Power Automate Flow, import data from Excel, and send emails based on conditions on the data from Excel.
06:55 List Rows Present In Table
The 'List Rows Present In Table' will get all the rows in an Excel table to work with them.
07:40 Apply To Each
We iterate through each row with an 'Apply To Each'.
08:15 Condition
Applying a simple condition to our data.
10:40 Send Email (notification to our self)
We send out emails based on our condition.
FOLLOW ME:
💼 LinkedIn: / andersjensenorg
🐦 Twitter: / andersjensenorg
📸 Instagram: / andersjensenorg
👨 Facebook: / andersjensenorg
👨‍👩‍👧‍👦 Discord: / discord
💌 Email Newsletter: andersjensen.org/email-newsle...
#microsoft #powerautomate #excel

[@andersjensenorg]

My new complete Excel with Power Automate guide is here: kzbin.info/www/bejne/hp2mn4x6oMeqaas Thanks for all your support 🙌🔥

[@thehonesttruth8808]

Do you do any consulting work?

[@sarveshpandey1125]

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.

[@andersjensenorg]

Wow, thank you, Sarvesh 😊 Kind regards, Anders

[@ericzheng4838]

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

[@andersjensenorg]

Hey Eric. Wow, thanks a lot. Have you checked this: kzbin.info/www/bejne/pZ60Xpl3e5mEpqs Feel free to drop me any question here in the comments. Microsoft also added an RPA tool (Power Automate Desktop) to their Power Automate: kzbin.info/www/bejne/oX65inyid9ilpdU Have a great day, kind regards, Anders

[@jeangui001]

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

[@andersjensenorg]

Hey jeangui. Sorry for the late response, but thanks a ton for the nice words :) Kind regards, Anders

[@nicolaslupo5021]

Great video! Thank you so much from Argentina!

[@leonardogoncalves5435]

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.

[@andersjensenorg]

Hey leonardo gonçalves Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@shirleysmith3409]

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

[@andersjensenorg]

Thank you, Shirley 😊

[@rasithachathurangaliyange]

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

[@andersjensenorg]

Wow, thank you Rasitha 🙂

[@antognani]

man your accent is sooo good to listen to.

[@andersjensenorg]

Hahaha, thanks a lot 😍 A few people complained during the years - I like comments like yours! Kind regards, Anders

[@JeanYvesHemlin]

Extremely useful demo. Thanks!

[@andersjensenorg]

Hey Jean-Yves. Many thanks 🙂 Kind regards, Anders

[@jorgevalencia2525]

Thank you for the guide. Greetings from Peru

[@andersjensenorg]

Thank you very much from Denmark 🙂

[@Sam-kj4kq]

I do call centre work from home and then they asked me to help other people with tech issues, so id call them and they share their screen and i fix it - really simple stuff for people not computer literate. But in the tech issues teams chat one of the guys has created tables to correlate with what issues people have and to categorise what's the most common issues, etc, so this can be used for training on specific areas to improve productivity and reduce these issues. I didn't know any of this shit until last week but it's crazy how you can implement these things from teams and then set up through emails and stuff, really interesting as well though for the potential it has. So thanks for the vid! Without vids like these on youtube it would be a lot harder to get to grips with it, instead of watching on x2 speed and clicking through a million of them before deciding what specifically it is we need to do and then looking more into that.

[@andersjensenorg]

Hey Sam Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@chicanight69]

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

[@andersjensenorg]

Hey Aracely. Thank you very much for the kind words 😊 If you got any good ideas for future videos, just post them in the discussion section and I will try to elaborate in future videos. Kind regards, Anders

[@chicanight69]

@@andersjensenorg Thank you for offering going the extra mile. I will watch it again and see if I have any questions or future questions. Thank you!

[@rets4072]

Even timestamped the video. Absolutely clutch!

[@andersjensenorg]

Thanks a ton, Rets! 🤩

[@dharma01v]

Thank you - very helpful.

[@andersjensenorg]

Hey Vijay. Thanks a lot - have a great week. Kind regards, Anders

[@JohnJ-fj2xe]

Thank you. I look forward to applying these ideas.

[@andersjensenorg]

Hey John. Thank you 😊 Let me know, how it went? Kind regards, Anders

[@fittolast2647]

Thank you so much for this - really helpful!

[@andersjensenorg]

My pleasure, thanks for the support. Kind regards, Anders 😊

[@hballestas]

Muchas gracias por tu ayuda. Excelente tutorial.

[@andersjensenorg]

Hey Humberto. Thanks a ton - I'll try to create more Power Automate tutorials soon :) Kind regards, Anders

[@LorriJefferson]

very helpful-thank you!

[@andersjensenorg]

Hey Lorry, you're very welcome 🤗

[@efficiencydna897]

Amazing video, thanks very much

[@andersjensenorg]

Hey EfficiencyDNA, my please 🙂

[@goviktor]

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

[@andersjensenorg]

Thanks a lot, Viktor Gokhberg 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 5300+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@MrinalMehra]

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?

[@andersjensenorg]

Hey Mrinal Mehra Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@perfumer8549]

thank you this is a lot easier then VBA

[@andersjensenorg]

Thanks a lot, Perf Umer 🤗 Your feedback helps me immensely. Kind regards, Anders

[@nehashahpatel1741]

million thanks

[@andersjensenorg]

You're very welcome, Neha! 🙂

[@alphamackie8456]

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.

[@andersjensenorg]

Hey Alpha Mackie Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@oscarjaviersanchezvillanue2478]

Anders, nice video. thank you for shering it

[@andersjensenorg]

My pleasure, Oscar 🙂 Kind regards, Anders

[@MrChavakoti]

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'])

[@andersjensenorg]

Hey Koteswararao. Thanks a lot and you're 100% right. Have a great weekend. Kind regards, Anders

[@enrikekasijas705]

Great stuff, I hope you have more of that 😂

[@andersjensenorg]

Haha, plenty 😅😅 Kind regards, Anders

[@Ask65k]

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...

[@andersjensenorg]

Hey Nagoor Meeran Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@Argentinian]

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).

[@andersjensenorg]

Hey Argentina - you're more than welcome in my community of 11,000 automation developers, where we discuss (and help with) these things. It's on discord and 100% free: discord.gg/iloveautomation Kind regards, Anders

[@prabakaransubramaniam5892]

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)

[@andersjensenorg]

Hey Prabakaran Subramaniam Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@divyanshumishra7022]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@amandeep-ss4ub]

thank you

[@andersjensenorg]

Hey Aman. You're very welcome :)

[@hashtechexpert]

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.

[@andersjensenorg]

Hey Hasham Khalid Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@josephnasr3385]

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?

[@andersjensenorg]

Hey Joseph Nasr Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@stevecorelli5719]

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?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 4900+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@aquabestindian]

Thanks Anders, 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.

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 5800+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@andersjensenorg]

Do you want to get an intro to Microsoft Power Automate? Watch this Tutorial for Beginners - kzbin.info/www/bejne/pZ60Xpl3e5mEpqs

[@ariharanr1057]

Kindly let me know how to filter a column details (string) in excel from onedrive.

[@zebamin8791]

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 /

[@andersjensenorg]

Hey Zeb Amin Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@poojalalwani1226]

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.

[@andersjensenorg]

Hey Pooja. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@victoriaaa251]

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

[@andersjensenorg]

Hey Victoria. Thanks for the question and the nice comment. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@victoriaaa251]

@@andersjensenorg Congrats! and enjoy your paternity leave, I finally got the solution by trying and trying :) I will keep on learning with your videos and posting my future issues at your Discord, thanks and regards, Victoria

[@TheBlackoutnow]

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 :)

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 4900+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@soldeal4422]

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

[@andersjensenorg]

Hey rachid laieb Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@redaabb8616]

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.

[@andersjensenorg]

Hey Reda Abb Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@ramirotapia2217]

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

[@andersjensenorg]

Hey ramiro tapia Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@kren6]

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

[@andersjensenorg]

Hey K Ren Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@dianamgdata]

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!

[@andersjensenorg]

Hey Diana. Thanks for the kind words and thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@Sachinpatrafitness]

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

[@andersjensenorg]

Hey Sachin Patra Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@dbss8999]

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!

[@andersjensenorg]

Hey DB SS Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@mukeshkumaryadav5116]

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

[@andersjensenorg]

Hey Mukesh. Thank you!! Highly appreciated. In Power Automate or UiPath? If the first do you mean Excel or do you have a db? Kind regards, Anders

[@mukeshkumaryadav5116]

@@andersjensenorg Hi, I am asking for Excel only . I have a situation in which i need create a column in existing table and need to update the same basis on the condition for each rows in table such as if sales >=5000, status should be "achieve" else "not achieve" Note:- if column name "status" already exist in table then we don't need to add new column and update the Information in Same. I am able to create flow for all the scenario except unable to check if "status" exist or not? Please help. This is required in Power Automate only. Thanks!

[@TheMKTube]

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 :)

[@dianamgdata]

Hello! Where you able to solve this? It would help me with a project I am currently working on

[@andersjensenorg]

Hey MKTUBE Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@playoffice4310]

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

[@andersjensenorg]

Hey Play Office Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@andreivyrypaev5636]

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.

[@andersjensenorg]

Hey Andrei Vyrypaev Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@zubarmalik4672]

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

[@andersjensenorg]

Hey Zubar Malik Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@BGMI-AshleelLonda31_Live]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@javiedkawification]

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.

[@aryannuccia]

I have the same problem

[@andersjensenorg]

Hey Ding .Sheng Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@kristofferp2751]

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.

[@andersjensenorg]

Hey Kristoffer p Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@lka55364]

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)

[@andersjensenorg]

Hey Lalitha Srilal Kannangara Arachchige Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@Unbox747]

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.

[@andersjensenorg]

Hey Peter. Thanks for the question and sorry for the late reply. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@alickcampbell8915]

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 ?

[@andersjensenorg]

Hey Alick Campbell Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@famarustudios1375]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@ariharanr1057]

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

[@andersjensenorg]

Hey Ariharan R Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@gabbrielraj8703]

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

[@andersjensenorg]

Hey Gabbriel. Thanks for the question and sorry for the late reply. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@SanjuSatheesh-uq9ek]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@alishageorge9846]

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?

[@andersjensenorg]

Hey Alisha. Yes, Check here: kzbin.info/www/bejne/pX7KdGyAht6IsLc You can make a filter or we can sort them afterwards with a condition 🙂 Kind regards, Anders

[@JensenVlogChannel]

Hi Anders. I want to get the notification from my Excel file on office 365. this notification to tell me to know have some task overdue day. Can you help me with how I can do it? I tried "List row present in the table" and when I get the mail it shows more email not only one. I just want to get one email to open the file and check the task by my self.

[@andersjensenorg]

Hey Jensen Vlog Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@kamacete]

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

[@andersjensenorg]

Hey Rui. Thank you 🙂 Definately. When you say Excel db in the end, what do you mean? Kind regards, Anders

[@kamacete]

@@andersjensenorg I solved. :) thank you

[@andersjensenorg]

Awesome 💪

[@emailadmin3346]

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 :)

[@andersjensenorg]

Hey Email. Thanks a lot for the feedback. And as we hate manual work, we should your approach :) Kind regards, Anders

[@OmaticFever]

Yeah, team Bill!

[@andersjensenorg]

Thank you 😎

[@doingstuffataplace3948]

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.

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@daironmurciasierra9767]

Hey Anders (or anybody who read this): the file from wich im gonna list the rows has just arrived as an attachment in an email that trigger my flow. So, i do not know its name already and its impossible to write it on the file name box. Is there any way to bring the name without mentiomed it explicitly, maybe coding?

[@andersjensenorg]

Hey Dairon. Thanks for the question and sorry for the late reply. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@mojpage]

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.

[@andersjensenorg]

Hey mojpage Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@educationworld5133]

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

[@andersjensenorg]

Hey EDUCATION WORLD Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@henryford6230]

is there a way to open the excel in desktop version and run macro in it using UI flow?

[@andersjensenorg]

Hey Henry. Definately, we can use Power Automate Desktop/UI flow. I am about to do an entire series about PAD and the first video will be about at tomorrow latest (files and folders, but the intuition is the same). Kind regards, Anders

[@shayistatamkeen6342]

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!

[@andersjensenorg]

Hey shayista tamkeen Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@sibiarasu5582]

Hi, I not able to download the zip file to import. Could you please help with that

[@m3mb3r333]

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?

[@andersjensenorg]

Hey Awesome. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 26th of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@GabrielStJoie]

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 :)

[@andersjensenorg]

Hey Gabriel St. Joie Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@ginabethea-santiago1512]

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!

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@mindvoice4u]

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?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@BrunoAlbuquerque-be1yu]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@spinachtriangle]

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 :)

[@andersjensenorg]

Hey Spinachtriangle. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@spinachtriangle]

@@andersjensenorg Hi Anders, thanks for getting back mate. We managed to crack the problem using Excel Scripts. Used an API to drop info into PA, Excel Scripts, and return the results to our source system. Thanks for checking! Enjoy fatherhood! If you have not check out a book called 'Manhood' by Steve Biddulph

[@venkypabbu6623]

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.

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@user-nj2ro2jh1d]

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

[@andersjensenorg]

Hey WhatsApp Status Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@katarzynaszczepanska2474]

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?

[@andersjensenorg]

Hey Katarzyna Szczepańska Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@devadimadhav3621]

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.

[@andersjensenorg]

Hey Devadi. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 26th of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@mohsinkhatri2136]

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...

[@andersjensenorg]

Hey mohsin khatri Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@Akki-bhau]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@karolinaunderwood1039]

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

[@andersjensenorg]

Hey Karolina Underwood Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@SkywalkerGuitar]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@juxingjiejie]

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.

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@djsanell]

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.

[@andersjensenorg]

Hey Senell. I don't have time for consultancy except my clients. However I gladly try to answer a lot of the questions to the videos 🙂 I am sorry, I can't help you directly. Kind regards, Anders

[@djsanell]

@@andersjensenorg Thanks anyway Anders. Just a quick one: Do you have any tutorial showing on how to automate a process to happened at each 3 months, trigger values from Excel, Use a define template, Fill up values from Excel and send that Template customized to customers. Thanks !

[@keith364]

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

[@andersjensenorg]

I do a lot of Sharepoint/Excel/Outlook automation - and then there is Power Automate Desktop: kzbin.info/www/bejne/Z4jIq6V5htGjeLs Kind regards, Anders

[@barakat1651]

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.)

[@andersjensenorg]

Hey Barakat. I'm really not sure. Can you Google it? Kind regards, Anders

[@srikanthmadhunantuni2743]

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.

[@andersjensenorg]

Hey srikanth madhunantuni Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@revatichaudhari1694]

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...

[@andersjensenorg]

Hey Revati Chaudhari Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@dhruvsingh3016]

what should i do so that my flow only reads the last row entry (from forms) and not iterate on all the rows??? pls help @Anders Jensen

[@andersjensenorg]

Hey DHRUV. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@davidlee8645]

Hi Dhruv, just wondering whether you managed to solve this issue (and if so, how you did it) please? I've created a form that is written to an excel stored in OneDrive. The excel performs some calculations and I then want to pick one of the calculations and, if it meets some criteria, post a message on a Teams chat. I can get it to write to the table but am struggling to just pick the last row entry. @Anders Jenson

[@fpereda]

Hi!, I've been looking all over the internet for an easy way to send emails with customised attachments - no luck. I need to send a certificate of participation as an attachment to 100 students (a certificate per student). How can I add a specific attachment to each email? I have the pdf files in a library in share point + the mailing list in an excel sheet.

[@andersjensenorg]

Hey Filloli. When we work with RPA/Automation, we usually want to ask ourself: "How would a human do the task?" and then do the same. So do the files have a reference to the mailing list og vice versa? I hope that make sense (and it was not to present you to a kindergarten solution, but just the approach I would usually take myself) 😊 Let me know. Kind regards, Anders

[@fpereda]

@@andersjensenorg hi Anders! Not a Kindergarten solution at all! I does make sense and that's what I've been trying with the help of this video. kzbin.info/www/bejne/Y3aYcq2ngpaSiJo. Thanks for your kind answer 😉

[@MrAlos87]

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

[@andersjensenorg]

Hey Andreas Koch Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@MrReese]

ID != idea :D

[@andersjensenorg]

Haha, yes - my English could be better 😀😀