My new complete Excel with Power Automate guide is here: kzitem.info/news/bejne/saJ51I16pJSoZn4 Thanks for all your support 🙌🔥
@thehonesttruth8808
Ай бұрын
Do you do any consulting work?
@ericzheng4838
3 жыл бұрын
Thank you Anders. Power Automate is such an amazing software - but it is nothing to beginners like me without sophisticated trainers like you!
@andersjensenorg
3 жыл бұрын
Hey Eric. Wow, thanks a lot. Have you checked this: kzitem.info/news/bejne/0KOHk5p3f2aCo34 Feel free to drop me any question here in the comments. Microsoft also added an RPA tool (Power Automate Desktop) to their Power Automate: kzitem.info/news/bejne/zIOMv32ie6Wjoqg Have a great day, kind regards, Anders
@sarveshpandey1125
4 жыл бұрын
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
4 жыл бұрын
Wow, thank you, Sarvesh 😊 Kind regards, Anders
@ernestomeyer7652
3 күн бұрын
This video was extremely helpful. Thank you!
@antognani
2 ай бұрын
man your accent is sooo good to listen to.
@andersjensenorg
2 ай бұрын
Hahaha, thanks a lot 😍 A few people complained during the years - I like comments like yours! Kind regards, Anders
@jeangui001
3 жыл бұрын
Thanks for this detailed tutorial! Finally figured out how to make data transfer to work from SmartSheet to Excel.
@andersjensenorg
3 жыл бұрын
Hey jeangui. Sorry for the late response, but thanks a ton for the nice words :) Kind regards, Anders
@rets4072
2 жыл бұрын
Even timestamped the video. Absolutely clutch!
@andersjensenorg
2 жыл бұрын
Thanks a ton, Rets! 🤩
@nicolaslupo5021
2 жыл бұрын
Great video! Thank you so much from Argentina!
@shirleysmith3409
4 жыл бұрын
This is incredible!!!! Thank you so much.
@andersjensenorg
4 жыл бұрын
Thank you, Shirley 😊
@Argentinian
7 ай бұрын
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
7 ай бұрын
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
@divyanshumishra7022
8 ай бұрын
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
8 ай бұрын
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): kzitem.info/news/bejne/2Y184GGJcmiJeqQ Kind regards, Anders
@perfumer8549
2 жыл бұрын
thank you this is a lot easier then VBA
@andersjensenorg
2 жыл бұрын
Thanks a lot, Perf Umer 🤗 Your feedback helps me immensely. Kind regards, Anders
@jorgevalencia2525
4 жыл бұрын
Thank you for the guide. Greetings from Peru
@andersjensenorg
4 жыл бұрын
Thank you very much from Denmark 🙂
@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
@rasithachathurangaliyange
4 жыл бұрын
This is incredible and great stuff. thank you so much for this guidance.
@andersjensenorg
4 жыл бұрын
Wow, thank you Rasitha 🙂
@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: kzitem.info/news/bejne/2Y184GGJcmiJeqQ Kind regards, Anders
@leonardogoncalves5435
3 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@enrikekasijas705
4 ай бұрын
Great stuff, I hope you have more of that 😂
@andersjensenorg
3 ай бұрын
Haha, plenty 😅😅 Kind regards, Anders
@zebamin8791
2 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@soldeal4422
2 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@josephnasr3385
2 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@ramirotapia2217
2 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@JohnJ-fj2xe
3 жыл бұрын
Thank you. I look forward to applying these ideas.
@andersjensenorg
3 жыл бұрын
Hey John. Thank you 😊 Let me know, how it went? 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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@IndianKiwi1
Жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@LorriJefferson
2 жыл бұрын
very helpful-thank you!
@andersjensenorg
2 жыл бұрын
Hey Lorry, you're very welcome 🤗
@dharma01v
3 жыл бұрын
Thank you - very helpful.
@andersjensenorg
3 жыл бұрын
Hey Vijay. Thanks a lot - have a great week. Kind regards, Anders
@oscarjaviersanchezvillanue2478
Жыл бұрын
Anders, nice video. thank you for shering it
@andersjensenorg
Жыл бұрын
My pleasure, Oscar 🙂 Kind regards, Anders
@hashtechexpert
3 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@kren6
3 жыл бұрын
amazing video! is it possible to update the specific cell which is not the table data?
@andersjensenorg
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@efficiencydna897
4 жыл бұрын
Amazing video, thanks very much
@andersjensenorg
4 жыл бұрын
Hey EfficiencyDNA, my please 🙂
@poojalalwani1226
3 жыл бұрын
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
3 жыл бұрын
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: kzitem.info/rock/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
@chicanight69
4 жыл бұрын
This tutorial is really good. I learned so much from it. I am so glad I found you. Thank you so much.
@andersjensenorg
4 жыл бұрын
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
4 жыл бұрын
@@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!
@stevecorelli5719
2 жыл бұрын
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): kzitem.info/news/bejne/2Y184GGJcmiJeqQ Kind regards, Anders
@JeanYvesHemlin
3 жыл бұрын
Extremely useful demo. Thanks!
@andersjensenorg
3 жыл бұрын
Hey Jean-Yves. Many thanks 🙂 Kind regards, Anders
@javiedkawification
3 жыл бұрын
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
3 жыл бұрын
I have the same problem
@andersjensenorg
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. 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): kzitem.info/news/bejne/2Y184GGJcmiJeqQ Kind regards, Anders
@mukeshkumaryadav5116
3 жыл бұрын
This really awesome, but can you please explain how to add a new column in data table and update information in it. Thanks
@andersjensenorg
3 жыл бұрын
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
3 жыл бұрын
@@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!
@aquabestindian
2 жыл бұрын
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): kzitem.info/news/bejne/2Y184GGJcmiJeqQ Kind regards, Anders
@zubarmalik4672
3 жыл бұрын
Hello Anders Do you have any videos showing how to run a Marco in Excel With power automate?
@andersjensenorg
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@hballestas
2 жыл бұрын
Muchas gracias por tu ayuda. Excelente tutorial.
@andersjensenorg
2 жыл бұрын
Hey Humberto. Thanks a ton - I'll try to create more Power Automate tutorials soon :) Kind regards, Anders
@AshleelLonda31
Жыл бұрын
Hello, Could you please make video on connect to exchange server or connect to shared mail box
@andersjensenorg
11 ай бұрын
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): kzitem.info/news/bejne/2Y184GGJcmiJeqQ Kind regards, Anders
@nehashahpatel1741
2 жыл бұрын
million thanks
@andersjensenorg
2 жыл бұрын
You're very welcome, Neha! 🙂
@mohsinkhatri2136
2 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@redaabb8616
3 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@alickcampbell8915
3 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@dianamgdata
3 жыл бұрын
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
3 жыл бұрын
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: kzitem.info/rock/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
@SanjuSatheesh-uq9ek
9 ай бұрын
Can u please teach us how to automote excel sheet attachement to master excel file in SharePoint
@andersjensenorg
9 ай бұрын
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): kzitem.info/news/bejne/2Y184GGJcmiJeqQ Kind regards, Anders
@educationworld5133
2 жыл бұрын
Sir pls advice how to add attachment in table th. Power automation.
@andersjensenorg
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@victoriaaa251
3 жыл бұрын
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
3 жыл бұрын
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: kzitem.info/rock/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
@victoriaaa251
3 жыл бұрын
@@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
@doingstuffataplace3948
2 ай бұрын
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): kzitem.info/news/bejne/2Y184GGJcmiJeqQ Kind regards, Anders
@prabakaransubramaniam5892
4 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@franklina6827
19 күн бұрын
I don't get one drive option in document library
@user-nj2ro2jh1d
3 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o 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): kzitem.info/news/bejne/2Y184GGJcmiJeqQ Kind regards, Anders
@Sachinpatrafitness
3 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@SkywalkerGuitar
10 ай бұрын
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
10 ай бұрын
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): kzitem.info/news/bejne/2Y184GGJcmiJeqQ Kind regards, Anders
@venkypabbu6623
11 ай бұрын
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
9 ай бұрын
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): kzitem.info/news/bejne/2Y184GGJcmiJeqQ Kind regards, Anders
@Ask65k
3 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@ginabethea-santiago1512
5 ай бұрын
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
4 ай бұрын
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): kzitem.info/news/bejne/2Y184GGJcmiJeqQ Kind regards, Anders
@emailadmin3346
3 жыл бұрын
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
3 жыл бұрын
Hey Email. Thanks a lot for the feedback. And as we hate manual work, we should your approach :) Kind regards, Anders
@alphamackie8456
4 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@katarzynaszczepanska2474
4 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@Akki-bhau
7 ай бұрын
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
7 ай бұрын
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): kzitem.info/news/bejne/2Y184GGJcmiJeqQ Kind regards, Anders
@revatichaudhari1694
3 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@keith364
2 жыл бұрын
I wonder what scenarios this function helps.. I’m a bit lost as to when it’s useful
@andersjensenorg
2 жыл бұрын
I do a lot of Sharepoint/Excel/Outlook automation - and then there is Power Automate Desktop: kzitem.info/news/bejne/ko2b4KZ5ip6hdY4 Kind regards, Anders
@amandeep-ss4ub
3 жыл бұрын
thank you
@andersjensenorg
3 жыл бұрын
Hey Aman. You're very welcome :)
@juxingjiejie
5 ай бұрын
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
4 ай бұрын
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): kzitem.info/news/bejne/2Y184GGJcmiJeqQ 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): kzitem.info/news/bejne/2Y184GGJcmiJeqQ Kind regards, Anders
@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): kzitem.info/news/bejne/2Y184GGJcmiJeqQ Kind regards, Anders
@karolinaunderwood1039
2 жыл бұрын
Can the same be created but not from the manually triggered but when an email with an excel report is received?
@andersjensenorg
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@SaddamKhan-jd2sj
2 жыл бұрын
Power Automate is not pulling data from Formulated excell cell that was calculated from MS form data, pls help
@andersjensenorg
2 жыл бұрын
Hey Saddam Khan 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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@seantrimble9984
Жыл бұрын
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?
@andersjensenorg
Жыл бұрын
Hey Sean. Thanks a lot for the trust. I'm developing, but mostly teaching (beginner to very advanced RPA/Power Automate). You're more than welcome to write me at anders@andersjensen.org Kind regards, Anders
@andreivyrypaev5636
3 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@junedahmed1469
7 ай бұрын
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?
@andersjensenorg
6 ай бұрын
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): kzitem.info/news/bejne/2Y184GGJcmiJeqQ Kind regards, Anders
@mojpage
2 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@klausmassler6262
3 жыл бұрын
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?
@andersjensenorg
3 жыл бұрын
Hey Klaus. Sorry, my bad. You need to have it formatted as a table in Excel. Let me know, if that helps? Kind regards, Anders
@klausmassler6262
3 жыл бұрын
@@andersjensenorg First I thought it helps. - But then I saw that i cannot select the sheet name (I have called ist "PersonnalSales"), there is always the standard name "Tabelle1" in the drop downlist. - After adding a new sheet without renaming ("Tabelle1"), the dropdown list showed "Tabelle1" and "Tabelle12". - Now a new try: A new excel sheet saved as NewSales, the basic list like in the video, marked and formatted as table ... and again: I find the excel file in the library, but nothing is listed in the drop down list "Table". :(
@klausmassler6262
3 жыл бұрын
I have found your explanation how to name the table in the comments of your video "Read Excel and send video". But my Excel still makes a lot of trouble, there seems to be an update prpblem with this table-name-value. First I try to change the value, e.g. from "Tabelle 1" to PersonnalSales"...Excel always sets it back to "Tabelle 1". Then I rename the sheet, e.g. to "Test"- and suddenly the value in Table name is set to "PersonnalSales". When I rename the sheet again, back to "Tabelle1", the value in Table name is also set back to "Tabelle 1"- automatically. and so on...it's almost impossible to set the right value here.
@klausmassler6262
3 жыл бұрын
Sorry for bothering you! I have created a small video to show my naming problems: kzitem.info/news/bejne/ypCot4tqrpeHg2U But now I have found that this problems exist only in the online version of Excel. When I edit the file with the desktop app, it is ok. Thank you again for your ecamples!
@alishageorge9846
3 жыл бұрын
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
3 жыл бұрын
Hey Alisha. Yes, Check here: kzitem.info/news/bejne/0IOdqW2AiquGrYo You can make a filter or we can sort them afterwards with a condition 🙂 Kind regards, Anders
@OmaticFever
8 ай бұрын
Yeah, team Bill!
@andersjensenorg
8 ай бұрын
Thank you 😎
@GabrielStJoie
4 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@srikanthmadhunantuni2743
3 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@shayistatamkeen6342
3 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@lka55364
3 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@m3mb3r333
3 жыл бұрын
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
3 жыл бұрын
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: kzitem.info/rock/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
@barakat1651
3 жыл бұрын
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
3 жыл бұрын
Hey Barakat. I'm really not sure. Can you Google it? Kind regards, Anders
@devadimadhav3621
3 жыл бұрын
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
3 жыл бұрын
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: kzitem.info/rock/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
@TheMKTube
3 жыл бұрын
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
3 жыл бұрын
Hello! Where you able to solve this? It would help me with a project I am currently working on
@andersjensenorg
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@dbss8999
4 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@dipensoni5672
3 жыл бұрын
I have a query. how did you PersonalSale name appear in dropdown under table field?
@andersjensenorg
3 жыл бұрын
Hey Dipen. 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: kzitem.info/rock/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
@gabbrielraj8703
3 жыл бұрын
Hi Anders, How to update the excel using email (Outlook 365) subject with previous Date, and current start time, and end time.
@andersjensenorg
3 жыл бұрын
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: kzitem.info/rock/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
@ariharanr1057
3 жыл бұрын
Hi @Andres Jensen could you please let me know how to filter a one column in one drive excel file.
@andersjensenorg
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@kamacete
4 жыл бұрын
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
4 жыл бұрын
Hey Rui. Thank you 🙂 Definately. When you say Excel db in the end, what do you mean? Kind regards, Anders
@kamacete
4 жыл бұрын
@@andersjensenorg I solved. :) thank you
@andersjensenorg
4 жыл бұрын
Awesome 💪
@MrAlos87
3 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@spinachtriangle
3 жыл бұрын
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
3 жыл бұрын
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: kzitem.info/rock/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
@spinachtriangle
3 жыл бұрын
@@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
@kristofferp2751
4 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o Have a great day. Kind regards, Anders
@henryford6230
3 жыл бұрын
is there a way to open the excel in desktop version and run macro in it using UI flow?
@andersjensenorg
3 жыл бұрын
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
@daironmurciasierra9767
3 жыл бұрын
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
3 жыл бұрын
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: kzitem.info/rock/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
@JensenVlogChannel
4 жыл бұрын
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
2 жыл бұрын
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: kzitem.info/news/bejne/wIeIr2GPqGSZa4o 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
@andersjensenorg
24 күн бұрын
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 13,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): kzitem.info/news/bejne/2Y184GGJcmiJeqQ Kind regards, Anders
@djsanell
4 жыл бұрын
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
4 жыл бұрын
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
4 жыл бұрын
@@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 !
Пікірлер: 257