In this tutorial, it is shown, 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.<\/p>\n
You could also watch:
\n\ud83d\udd35 Microsoft Power Automate Tutorial for Beginners – https:\/\/youtu.be\/omQ-fAF4QpI
\n\ud83d\udd35 Microsoft Power Automate Cases – https:\/\/www.youtube.com\/playlist?list=PLXXz88_TPiHqGlJoWhBDCAxZ9m1N_jsB6<\/p>\n
00:06 Intro to this Power Automate Tutorial
\nToday’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 condtions.<\/p>\n
00:24 Update Excel Tables with Power Automate
\nCreating a Power Automate flow to make data entries to an Excel table.<\/p>\n
01:32 Add Input (manually from user – text and number)
\nIn our manual trigger we will define, what input Power Automate should take from the user.<\/p>\n
02:21 New Step – Excel Online (Business)<\/p>\n
02:29 Add A Row Into A table
\nThe ‘Add A Row’ will add a row into a defined Excel table<\/p>\n
06:15 Create a Flow (Import data from Excel, Condition and Send Mail)
\nHow to create a Power Automate Flow, import data from Excel and send mails based on conditions on the data from Excel.<\/p>\n
06:55 List Rows Present In Table
\nThe ‘List Rows Present In Table’ will get all the rows in an Excel table, so we can work with them.<\/p>\n
07:40 Apply To Each
\nWe iterate through each row with an ‘Apply To Each’.<\/p>\n
08:15 Condition
\nApplying a simple condition to our data.<\/p>\n
10:40 Send Email (notification to our self)
\nWe send out emails based on our condition.<\/p>\n
\ud83d\udcda Best Power Automate Book – https:\/\/geni.us\/cKCS<\/p>\n
Connect with me:
\n\ud83d\udd14 Subscribe – http:\/\/www.youtube.com\/user\/klogeanders?sub_confirmation=1
\n\ud83d\udcbc LinkedIn – https:\/\/www.linkedin.com\/in\/andersjensens\/
\n\ud83d\udc65 Facebook – https:\/\/www.facebook.com\/andersjensenorg
\n\ud83d\udc8c Email Newsletter – https:\/\/andersjensen.org\/email-newsletter\/<\/p>\n
#microsoft #powerautomate #excel<\/p>\n","protected":false},"excerpt":{"rendered":"
In this tutorial, it is shown, 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...<\/p>\n","protected":false},"author":1,"featured_media":3813,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"video","meta":[],"categories":[1042,1],"tags":[835,1080,1081,1082,1083],"youtube_video":{"channel_id":"UCPdtz4gd_iYebJFYq9N8pWA","channel_title":"Anders Jensen","title":"Microsoft Power Automate | Add data to Excel, get data from Excel, Conditions and Send Email | Guide","description":"In this tutorial, it is shown, 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.\r\n\r\nYou could also watch:\r\n\ud83d\udd35 Microsoft Power Automate Tutorial for Beginners - https:\/\/youtu.be\/omQ-fAF4QpI\r\n\ud83d\udd35 Microsoft Power Automate Cases - https:\/\/www.youtube.com\/playlist?list=PLXXz88_TPiHqGlJoWhBDCAxZ9m1N_jsB6\r\n\r\n00:06 Intro to this Power Automate Tutorial\r\nToday'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 condtions.\r\n\r\n00:24 Update Excel Tables with Power Automate\r\nCreating a Power Automate flow to make data entries to an Excel table.\r\n\r\n01:32 Add Input (manually from user - text and number)\r\nIn our manual trigger we will define, what input Power Automate should take from the user.\r\n\r\n02:21 New Step - Excel Online (Business)\r\n\r\n02:29 Add A Row Into A table\r\nThe 'Add A Row' will add a row into a defined Excel table\r\n\r\n06:15 Create a Flow (Import data from Excel, Condition and Send Mail)\r\nHow to create a Power Automate Flow, import data from Excel and send mails based on conditions on the data from Excel.\r\n\r\n06:55 List Rows Present In Table\r\nThe 'List Rows Present In Table' will get all the rows in an Excel table, so we can work with them.\r\n\r\n07:40 Apply To Each\r\nWe iterate through each row with an 'Apply To Each'.\r\n\r\n08:15 Condition\r\nApplying a simple condition to our data.\r\n\r\n10:40 Send Email (notification to our self)\r\nWe send out emails based on our condition.\r\n\r\n\ud83d\udcda Best Power Automate Book - https:\/\/geni.us\/cKCS\r\n\r\nConnect with me:\r\n\ud83d\udd14 Subscribe - http:\/\/www.youtube.com\/user\/klogeanders?sub_confirmation=1\r\n\ud83d\udcbc LinkedIn - https:\/\/www.linkedin.com\/in\/andersjensens\/\r\n\ud83d\udc65 Facebook - https:\/\/www.facebook.com\/andersjensenorg\r\n\ud83d\udc8c Email Newsletter - https:\/\/andersjensen.org\/email-newsletter\/\r\n\r\n#microsoft #powerautomate #excel","category_id":"27","category":"Education","tags":["power automate tutorial","power automate excel tutorial","power automate mail tutorial","power automate excel mail","power automate excel guide","excel power automate","microsoft power automate excel","microsoft power automate mail","microsoft power automate excel mail","microsoft power automate excel tutorial","microsoft power automate","microsoft rpa","power automate","power automate how to","power automate microsoft","power automate rpa","power automate rpa tutorial","microsoft flow"],"duration":761,"iso_duration":"PT12M41S","human_duration":"12:41","definition":"hd","thumbnails":{"default":{"url":"https:\/\/i.ytimg.com\/vi\/kbYGFIo0WGc\/default.jpg","width":120,"height":90},"medium":{"url":"https:\/\/i.ytimg.com\/vi\/kbYGFIo0WGc\/mqdefault.jpg","width":320,"height":180},"high":{"url":"https:\/\/i.ytimg.com\/vi\/kbYGFIo0WGc\/hqdefault.jpg","width":480,"height":360},"standard":{"url":"https:\/\/i.ytimg.com\/vi\/kbYGFIo0WGc\/sddefault.jpg","width":640,"height":480},"maxres":{"url":"https:\/\/i.ytimg.com\/vi\/kbYGFIo0WGc\/maxresdefault.jpg","width":1280,"height":720}},"video_id":"kbYGFIo0WGc","published":"2020-01-26T20:50:54Z","stats":{"comments":"58","views":"49383","likes":"331","dislikes":"20","favourite":"0"},"privacy":{"status":"public","embeddable":true,"license":"youtube"}},"_links":{"self":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/3812"}],"collection":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3812"}],"version-history":[{"count":1,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/3812\/revisions"}],"predecessor-version":[{"id":3851,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/3812\/revisions\/3851"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/media\/3813"}],"wp:attachment":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3812"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3812"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3812"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}