{"id":1636,"date":"2021-11-29T12:00:20","date_gmt":"2021-11-29T12:00:20","guid":{"rendered":"https:\/\/365stack.in\/?p=1636"},"modified":"2021-12-05T10:31:15","modified_gmt":"2021-12-05T10:31:15","slug":"how-to-add-rows-in-excel-online-using-power-automate","status":"publish","type":"post","link":"https:\/\/365stack.in\/index.php\/2021\/11\/29\/how-to-add-rows-in-excel-online-using-power-automate\/","title":{"rendered":"How to add rows in Excel online using Power Automate"},"content":{"rendered":"\n<p>Adding rows to an excel file or exporting the data in &#8220;.xlsx&#8221; format, which can be sent to users or other applications as data feed can be a common scenario. In this example, we used the <a href=\"https:\/\/docs.microsoft.com\/en-us\/connectors\/excelonlinebusiness\/\" target=\"_blank\" rel=\"noreferrer noopener\">&#8220;Excel online business&#8221;<\/a> connector to add rows to the excel file, Previously we already shared a <a href=\"https:\/\/365stack.in\/index.php\/2021\/09\/11\/import-data-from-excel-to-dataverse-sharepoint-list\/\" target=\"_blank\" rel=\"noreferrer noopener\">post <\/a>to filter the excel file and push data to the dataverse. <\/p>\n\n\n\n<p>But still, there are other excel online actions which we will explore in our future posts. Kindly read the known issues and limitations on the reference page.<\/p>\n\n\n\n<p>Create the excel template with the required columns and format it as a table. Upload it in a common location like SharePoint or Onedrive from there we can take its instance.<\/p>\n\n\n\n<div class=\"wp-block-jetpack-slideshow aligncenter\" data-effect=\"slide\"><div class=\"wp-block-jetpack-slideshow_container swiper-container\"><ul class=\"wp-block-jetpack-slideshow_swiper-wrapper swiper-wrapper\"><li class=\"wp-block-jetpack-slideshow_slide swiper-slide\"><figure><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"263\" alt=\"Create Excel\" class=\"wp-block-jetpack-slideshow_image wp-image-1656\" data-id=\"1656\" src=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-220.png?resize=640%2C263&#038;ssl=1\" srcset=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-220.png?w=1024&amp;ssl=1 1024w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-220.png?w=300&amp;ssl=1 300w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-220.png?w=768&amp;ssl=1 768w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-220.png?w=1193&amp;ssl=1 1193w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><figcaption class=\"wp-block-jetpack-slideshow_caption gallery-caption\">Create Excel<\/figcaption><\/figure><\/li><li class=\"wp-block-jetpack-slideshow_slide swiper-slide\"><figure><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"304\" alt=\"Create Table\" class=\"wp-block-jetpack-slideshow_image wp-image-1657\" data-id=\"1657\" src=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-221.png?resize=640%2C304&#038;ssl=1\" srcset=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-221.png?w=1024&amp;ssl=1 1024w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-221.png?w=300&amp;ssl=1 300w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-221.png?w=768&amp;ssl=1 768w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-221.png?w=1041&amp;ssl=1 1041w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><figcaption class=\"wp-block-jetpack-slideshow_caption gallery-caption\">Create Table<\/figcaption><\/figure><\/li><li class=\"wp-block-jetpack-slideshow_slide swiper-slide\"><figure><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"216\" alt=\"Final Table\" class=\"wp-block-jetpack-slideshow_image wp-image-1658\" data-id=\"1658\" src=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-222.png?resize=640%2C216&#038;ssl=1\" srcset=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-222.png?w=1024&amp;ssl=1 1024w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-222.png?w=300&amp;ssl=1 300w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-222.png?w=768&amp;ssl=1 768w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-222.png?w=1045&amp;ssl=1 1045w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><figcaption class=\"wp-block-jetpack-slideshow_caption gallery-caption\">Final Output<\/figcaption><\/figure><\/li><\/ul><a class=\"wp-block-jetpack-slideshow_button-prev swiper-button-prev swiper-button-white\" role=\"button\"><\/a><a class=\"wp-block-jetpack-slideshow_button-next swiper-button-next swiper-button-white\" role=\"button\"><\/a><a aria-label=\"Pause Slideshow\" class=\"wp-block-jetpack-slideshow_button-pause\" role=\"button\"><\/a><div class=\"wp-block-jetpack-slideshow_pagination swiper-pagination swiper-pagination-white\"><\/div><\/div><\/div>\n\n\n\n<p>Get the excel template.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"361\" data-attachment-id=\"1660\" data-permalink=\"https:\/\/365stack.in\/index.php\/2021\/11\/29\/how-to-add-rows-in-excel-online-using-power-automate\/screenshot-210\/\" data-orig-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-210.png?fit=1245%2C701&amp;ssl=1?v=1637930039\" data-orig-size=\"1245,701\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Screenshot-210\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-210.png?fit=300%2C169&amp;ssl=1?v=1637930039\" data-large-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-210.png?fit=640%2C361&amp;ssl=1?v=1637930039\" src=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-210-1024x577.png?resize=640%2C361&#038;ssl=1\" alt=\"Get Excel template\" class=\"wp-image-1660\" srcset=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-210.png?w=1024&amp;ssl=1 1024w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-210.png?w=300&amp;ssl=1 300w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-210.png?w=768&amp;ssl=1 768w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-210.png?w=1245&amp;ssl=1 1245w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><figcaption>Excel Template<\/figcaption><\/figure>\n\n\n\n<p>Create an excel file in onedrive using the content from the query.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"216\" data-attachment-id=\"1661\" data-permalink=\"https:\/\/365stack.in\/index.php\/2021\/11\/29\/how-to-add-rows-in-excel-online-using-power-automate\/screenshot-211\/\" data-orig-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-211-e1637930171918.png?fit=1225%2C413&amp;ssl=1?v=1637930130\" data-orig-size=\"1225,413\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Screenshot-211\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-211-e1637930171918.png?fit=300%2C101&amp;ssl=1?v=1637930130\" data-large-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-211-e1637930171918.png?fit=640%2C216&amp;ssl=1?v=1637930130\" src=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-211-e1637930171918-1024x345.png?resize=640%2C216&#038;ssl=1\" alt=\"Create Excel in Onedrive\" class=\"wp-image-1661\" srcset=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-211-e1637930171918.png?w=1024&amp;ssl=1 1024w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-211-e1637930171918.png?w=300&amp;ssl=1 300w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-211-e1637930171918.png?w=768&amp;ssl=1 768w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-211-e1637930171918.png?w=1225&amp;ssl=1 1225w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><figcaption>Create excel file<\/figcaption><\/figure>\n\n\n\n<p>Query records from a table or list, In this case, we used SharePoint list.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"414\" data-attachment-id=\"1662\" data-permalink=\"https:\/\/365stack.in\/index.php\/2021\/11\/29\/how-to-add-rows-in-excel-online-using-power-automate\/screenshot-212\/\" data-orig-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-212.png?fit=1001%2C647&amp;ssl=1?v=1637930295\" data-orig-size=\"1001,647\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Screenshot-212\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-212.png?fit=300%2C194&amp;ssl=1?v=1637930295\" data-large-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-212.png?fit=640%2C414&amp;ssl=1?v=1637930295\" src=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-212.png?resize=640%2C414&#038;ssl=1\" alt=\"Get Items\" class=\"wp-image-1662\" srcset=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-212.png?w=1001&amp;ssl=1 1001w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-212.png?w=300&amp;ssl=1 300w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-212.png?w=768&amp;ssl=1 768w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><figcaption>Query Records<\/figcaption><\/figure>\n\n\n\n<p>Inside the &#8220;Apply to each&#8221; action, construct the JSON. The column names in the excel template and JSON should be the same.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"441\" data-attachment-id=\"1663\" data-permalink=\"https:\/\/365stack.in\/index.php\/2021\/11\/29\/how-to-add-rows-in-excel-online-using-power-automate\/screenshot-213\/\" data-orig-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-213.png?fit=939%2C647&amp;ssl=1?v=1637930429\" data-orig-size=\"939,647\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Screenshot-213\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-213.png?fit=300%2C207&amp;ssl=1?v=1637930429\" data-large-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-213.png?fit=640%2C441&amp;ssl=1?v=1637930429\" src=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-213.png?resize=640%2C441&#038;ssl=1\" alt=\"Construct JSON\" class=\"wp-image-1663\" srcset=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-213.png?w=939&amp;ssl=1 939w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-213.png?w=300&amp;ssl=1 300w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-213.png?w=768&amp;ssl=1 768w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><figcaption>Construct JSON<\/figcaption><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>{\n\"no\":\"DynamicValue\",\n\"Name\":\"DynamicValue\",\n\"Location\":\"DynamicValue\",\n\"DOB\":\"DynamicValue\",\n\"Address\":\"DynamicValue\",\n\"Base Location\":\"DynamicValue\"\n}<\/code><\/pre>\n\n\n\n<p>Pass the JSON to &#8220;Add rows into a table&#8221; action.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"354\" data-attachment-id=\"1664\" data-permalink=\"https:\/\/365stack.in\/index.php\/2021\/11\/29\/how-to-add-rows-in-excel-online-using-power-automate\/screenshot-214\/\" data-orig-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-214.png?fit=997%2C551&amp;ssl=1?v=1637930822\" data-orig-size=\"997,551\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Screenshot-214\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-214.png?fit=300%2C166&amp;ssl=1?v=1637930822\" data-large-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-214.png?fit=640%2C354&amp;ssl=1?v=1637930822\" src=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-214.png?resize=640%2C354&#038;ssl=1\" alt=\"Add rows to table\" class=\"wp-image-1664\" srcset=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-214.png?w=997&amp;ssl=1 997w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-214.png?w=300&amp;ssl=1 300w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-214.png?w=768&amp;ssl=1 768w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><figcaption>Add row to table action<\/figcaption><\/figure><\/div>\n\n\n\n<p>The excel file created, can be <a href=\"https:\/\/365stack.in\/index.php\/2021\/11\/19\/how-to-add-dynamic-attachments-in-power-automate-send-email-action\/\" target=\"_blank\" rel=\"noreferrer noopener\">Sent in Email<\/a> or can be passed to a network location. Then <strong>delete the temporary exce<\/strong>l file created in OneDrive if it is not needed. Kindly see this post to <a href=\"https:\/\/365stack.in\/index.php\/2021\/12\/03\/how-to-create-csv-file-in-power-automate\/\" target=\"_blank\" rel=\"noreferrer noopener\">create CSV<\/a> and <a href=\"https:\/\/365stack.in\/index.php\/2021\/12\/05\/how-to-read-csv-file-using-power-automate\/\" target=\"_blank\" rel=\"noreferrer noopener\">read CSV.<\/a><\/p>\n\n\n\n<p>Please post your queries in the comments section. Happy Building \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Adding rows to an excel file or exporting the data in &#8220;.xlsx&#8221; format, which can be sent to users or other applications as data feed can be a common scenario. In this example, we used the &#8220;Excel online business&#8221; connector to add rows to the excel file, Previously we already shared a post to filter the excel file and push [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1664,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[8,32,4],"tags":[59,49,46,33,9,10],"class_list":["post-1636","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-automate","category-power-platform","category-sharepoint","tag-excel-online","tag-excelconnector","tag-microsoft-365","tag-power-platform","tag-powerapps","tag-powerautomate"],"jetpack_publicize_connections":[],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-214.png?fit=997%2C551&ssl=1?v=1637930822","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":1435,"url":"https:\/\/365stack.in\/index.php\/2021\/09\/11\/import-data-from-excel-to-dataverse-sharepoint-list\/","url_meta":{"origin":1636,"position":0},"title":"Import Data from Excel to Dataverse\/SharePoint List using Power Automate","author":"Hemanthkumar Rajan","date":"September 11, 2021","format":false,"excerpt":"One of the most common requirements in any business use case is to read the excel from an external system via Email or direct upload by a user. In Power Platform it can be implemented in multiple ways. Data flows Dataflows are a great way to transform data and import\u2026","rel":"","context":"In &quot;Dataverse&quot;","block_context":{"text":"Dataverse","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/powerapps\/dataverse\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/09\/Screenshot-45.png?fit=1200%2C470&ssl=1%3Fv%3D1631363241&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1678,"url":"https:\/\/365stack.in\/index.php\/2021\/11\/27\/how-to-add-microsoft-forms-responses-to-database\/","url_meta":{"origin":1636,"position":1},"title":"How to add Microsoft Forms responses to database","author":"Premkumar Perumal","date":"November 27, 2021","format":false,"excerpt":"Add Microsoft Forms responses to databases using power automate will help any person\/organization to do advanced data analytics on the responses. We can add responses to list or table using Power Automate in two different ways and create your survey using Microsoft Form as a first step. Method 1: After\u2026","rel":"","context":"In &quot;Power Automate&quot;","block_context":{"text":"Power Automate","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/power-automate\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-2021-11-26-214110.png?fit=682%2C325&ssl=1%3Fv%3D1637943130&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1640,"url":"https:\/\/365stack.in\/index.php\/2021\/12\/03\/how-to-create-csv-file-in-power-automate\/","url_meta":{"origin":1636,"position":2},"title":"How to create CSV file in Power Automate","author":"Hemanthkumar Rajan","date":"December 3, 2021","format":false,"excerpt":"Export to CSV is one of the common requirements in any application. But in this example, we are not going to show the procedure from the app that will be shared in a separate post. Here we are getting the data from Power Automate itself to support a large set\u2026","rel":"","context":"In &quot;Power Automate&quot;","block_context":{"text":"Power Automate","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/power-automate\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-229.png?fit=934%2C596&ssl=1%3Fv%3D1637940499&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1937,"url":"https:\/\/365stack.in\/index.php\/2022\/07\/01\/how-to-integrate-automation-anywhere-iq-bot-with-power-platform\/","url_meta":{"origin":1636,"position":3},"title":"How to integrate Automation Anywhere IQ Bot with Power Platform","author":"Hemanthkumar Rajan","date":"July 1, 2022","format":false,"excerpt":"This is a continuation of the OCR series, previously we showed how to extract data from PDF using Power Platform\"AI Builder\" and Azure \"Form Recognizer\". In this post, we will see how to extract data using IQ Bot. Automation Anywhere is one of the leading RPA tools, In Power Platform\u2026","rel":"","context":"In &quot;Power Automate&quot;","block_context":{"text":"Power Automate","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/power-automate\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-380.png?fit=1051%2C631&ssl=1%3Fv%3D1639057573&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2278,"url":"https:\/\/365stack.in\/index.php\/2021\/12\/28\/how-to-send-json-data-to-canvas-apps\/","url_meta":{"origin":1636,"position":4},"title":"How to send JSON data to Canvas Apps","author":"Premkumar Perumal","date":"December 28, 2021","format":false,"excerpt":"We're going to explain how to send a JSON response from Power Automate to Canvas app and how to convert the response into Collection format in Canvas app. To illustrate, we have explained a small app as example. As First step, create a new Instant flow that can be triggered\u2026","rel":"","context":"In &quot;Canvas Apps&quot;","block_context":{"text":"Canvas Apps","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/powerapps\/canvas-apps\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-2021-12-28-103100.png?fit=836%2C391&ssl=1%3Fv%3D1640667678&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1520,"url":"https:\/\/365stack.in\/index.php\/2021\/11\/19\/how-to-add-dynamic-attachments-in-power-automate-send-email-action\/","url_meta":{"origin":1636,"position":5},"title":"How to add dynamic attachments in Send Email\/Approval Action","author":"Hemanthkumar Rajan","date":"November 19, 2021","format":false,"excerpt":"In some scenarios, we may need to add attachments while sending emails to businesses, Some times the attachment files will be dynamic and it will be changed based on users or scenarios. We may get the files from SharePoint, Onedrive, Azure, or any HTTP request, In all cases we can\u2026","rel":"","context":"In &quot;Power Automate&quot;","block_context":{"text":"Power Automate","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/power-automate\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-131.png?fit=1047%2C653&ssl=1%3Fv%3D1637336922&resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/posts\/1636","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/comments?post=1636"}],"version-history":[{"count":10,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/posts\/1636\/revisions"}],"predecessor-version":[{"id":1866,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/posts\/1636\/revisions\/1866"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/media\/1664"}],"wp:attachment":[{"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/media?parent=1636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/categories?post=1636"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/tags?post=1636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}