{"id":1462762,"date":"2022-02-06T18:42:17","date_gmt":"2022-02-07T02:42:17","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1462762"},"modified":"2022-02-07T16:10:47","modified_gmt":"2022-02-08T00:10:47","slug":"instantly-load-survey123-data-in-excel-with-microsoft-power-automate","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate","title":{"rendered":"Load Survey123 data into Excel instantly with Microsoft Power Automate"},"author":5861,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[37131],"tags":[27481,252272,761682,31861,42371],"industry":[],"product":[36691],"class_list":["post-1462762","blog","type-blog","status-publish","format-standard","hentry","category-constituent-engagement","tag-automation","tag-email","tag-power-automate","tag-smart-form","tag-survey123","product-survey123"],"acf":{"short_description":"A step-by-step guide to help you instantly load Survey123 records into a Microsoft Excel spreadsheet using Microsoft Power Automate","flexible_content":[{"acf_fc_layout":"content","content":"<p>Using the ArcGIS Survey123 connector for Microsoft Power Automate you can automate tasks when a survey is submitted. Typical tasks include:<\/p>\n<ul>\n<li><strong>Automatic notifications<\/strong>: Survey submitted, email sent! You can also send an SMS, add a message to a Teams channel or send a push notification.<\/li>\n<li><strong>Instant data transfer<\/strong>: Load Survey123 data into a spreadsheet, a cloud folder, a database, and more.<\/li>\n<li><strong>Data enrichment<\/strong>: Use data sent by the user to populate extra attributes in your GIS records. For example, take the location of an observation and automatically calculate the closest street address and postal code.<\/li>\n<\/ul>\n<p>This step-by-step guide you will show you how to instantly load data from Survey123 into a Microsoft Office workbook.<\/p>\n<p>In this particular scenario, we will pretend a severe weather event has hit our city. You will create a public online survey to help citizens document damage to their property. Using Microsoft Power Automate you will take data submitted via Survey123 and instantly load it into an existing Microsoft Office workbook.<\/p>\n<p>Ready to start? Following this step-by-step guide should not take you more than 20 minutes.<\/p>\n"},{"acf_fc_layout":"content","content":"<h2>Prerequisites<\/h2>\n<p>To follow this guide you will need an ArcGIS Online account with publishing permissions and a subscription to Microsoft Office 365.<\/p>\n"},{"acf_fc_layout":"content","content":"<h2>It all starts with a survey, let&#8217;s create one<\/h2>\n<p>There is not much you can automate without a survey , so let&#8217;s get that going first:<\/p>\n<ul>\n<li>Sign in to <a href=\"https:\/\/survey123.arcgis.com\">survey123.arcgis.com <\/a><\/li>\n<li>Click on <em>New survey<\/em> and open the gallery of templates<\/li>\n<li>Use the <em>Property Damage Report<\/em> template to create a new survey<\/li>\n<\/ul>\n"},{"acf_fc_layout":"image","image":{"ID":1474602,"id":1474602,"title":"001_Survey123_Create_Property_Damage_Report","filename":"001_Survey123_Create_Property_Damage_Report.gif","filesize":2603963,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/01\/001_Survey123_Create_Property_Damage_Report.gif","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate\/001_survey123_create_property_damage_report","alt":"This image shows how to create a survey from a template","author":"5861","description":"","caption":"","name":"001_survey123_create_property_damage_report","status":"inherit","uploaded_to":1462762,"date":"2022-02-05 18:09:30","modified":"2022-02-05 22:25:58","menu_order":0,"mime_type":"image\/gif","type":"image","subtype":"gif","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1600,"height":750,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/01\/001_Survey123_Create_Property_Damage_Report-213x200.gif","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/01\/001_Survey123_Create_Property_Damage_Report.gif","medium-width":464,"medium-height":218,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/01\/001_Survey123_Create_Property_Damage_Report.gif","medium_large-width":768,"medium_large-height":360,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/01\/001_Survey123_Create_Property_Damage_Report.gif","large-width":1600,"large-height":750,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/01\/001_Survey123_Create_Property_Damage_Report-1536x720.gif","1536x1536-width":1536,"1536x1536-height":720,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/01\/001_Survey123_Create_Property_Damage_Report.gif","2048x2048-width":1600,"2048x2048-height":750,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/01\/001_Survey123_Create_Property_Damage_Report-826x387.gif","card_image-width":826,"card_image-height":387,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/01\/001_Survey123_Create_Property_Damage_Report.gif","wide_image-width":1600,"wide_image-height":750}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>This survey allows residents of the city to report damage to their home.\u00a0 Contact information, details of the property and a description of the damage are part of the form. You may make adjustments to the survey such as adding new questions, rewording existing ones or changing its look and feel. For this exercise, we will proceed to publish and share it publicly.<\/p>\n<ul>\n<li>Publish the survey<\/li>\n<li>Switch to the Collaborate tab<\/li>\n<li>Share your survey with Everyone and click Save<\/li>\n<\/ul>\n"},{"acf_fc_layout":"image","image":{"ID":1474632,"id":1474632,"title":"001_Survey123_Publish_Share","filename":"001_Survey123_Publish_Share.gif","filesize":2207860,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/001_Survey123_Publish_Share.gif","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate\/001_survey123_publish_share","alt":"This image shows how to publish and publicly share a survey","author":"5861","description":"","caption":"","name":"001_survey123_publish_share","status":"inherit","uploaded_to":1462762,"date":"2022-02-05 19:09:24","modified":"2022-02-05 22:26:21","menu_order":0,"mime_type":"image\/gif","type":"image","subtype":"gif","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1600,"height":750,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/001_Survey123_Publish_Share-213x200.gif","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/001_Survey123_Publish_Share.gif","medium-width":464,"medium-height":218,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/001_Survey123_Publish_Share.gif","medium_large-width":768,"medium_large-height":360,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/001_Survey123_Publish_Share.gif","large-width":1600,"large-height":750,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/001_Survey123_Publish_Share-1536x720.gif","1536x1536-width":1536,"1536x1536-height":720,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/001_Survey123_Publish_Share.gif","2048x2048-width":1600,"2048x2048-height":750,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/001_Survey123_Publish_Share-826x387.gif","card_image-width":826,"card_image-height":387,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/001_Survey123_Publish_Share.gif","wide_image-width":1600,"wide_image-height":750}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>If you now share your survey link with others, they will be able to submit data. Do you want to do that now? I don&#8217;t think so!<\/p>\n<h2>We need a spreadsheet too<\/h2>\n<p>Next, we are going to create a new workbook in Microsoft Office 365 and add columns matching the information collected in the survey:<\/p>\n<ul>\n<li>Login into Microsoft Office 365 and create a new blank Microsoft Excel workbook<\/li>\n<li>Add the following columns: <em>Report ID, First and last name, phone, email, street address, city, postal code, primary residence?, insured?, damage description<\/em><\/li>\n<li>Select all the header columns you added an click on <em>Format as table<\/em> from the <em>Home<\/em> ribbon<\/li>\n<li>Select a table style. Check the <em>My table as headers<\/em> option and click <em>OK<\/em><\/li>\n<li>Rename the file to <em>Damage Reports City of Cilantro<\/em><\/li>\n<\/ul>\n"},{"acf_fc_layout":"image","image":{"ID":1474672,"id":1474672,"title":"003_Excel_Create","filename":"003_Excel_Create.gif","filesize":3328098,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/003_Excel_Create.gif","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate\/003_excel_create","alt":"This image shows how to create an Excel spreadshet in Microsoft Office 365","author":"5861","description":"","caption":"","name":"003_excel_create","status":"inherit","uploaded_to":1462762,"date":"2022-02-05 19:34:40","modified":"2022-02-05 22:26:56","menu_order":0,"mime_type":"image\/gif","type":"image","subtype":"gif","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1600,"height":750,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/003_Excel_Create-213x200.gif","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/003_Excel_Create.gif","medium-width":464,"medium-height":218,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/003_Excel_Create.gif","medium_large-width":768,"medium_large-height":360,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/003_Excel_Create.gif","large-width":1600,"large-height":750,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/003_Excel_Create-1536x720.gif","1536x1536-width":1536,"1536x1536-height":720,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/003_Excel_Create.gif","2048x2048-width":1600,"2048x2048-height":750,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/003_Excel_Create-826x387.gif","card_image-width":826,"card_image-height":387,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/003_Excel_Create.gif","wide_image-width":1600,"wide_image-height":750}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>Ok. We are almost ready to have some fun with Microsoft Power Automate!<\/p>\n<h2>First steps with Microsoft Power Automate<\/h2>\n<p>Microsoft Power Automate includes a Survey123 module. We will use it to connect our survey with the workbook you just created.<\/p>\n<ul>\n<li>In Microsoft Office 365, open Power Automate<\/li>\n<li>From the left panel, click on <em>Create<\/em><\/li>\n<li>Select the Automated cloud flow option<\/li>\n<li>Give your flow a name such as P<em>roperty Damage Reports to Excel<\/em><\/li>\n<li>Choose Survey123 as your flow&#8217;s trigger and click <em>Create<\/em><\/li>\n<\/ul>\n"},{"acf_fc_layout":"image","image":{"ID":1474872,"id":1474872,"title":"004_Create_Cloud_Automated_Workflow","filename":"004_Create_Cloud_Automated_Workflow.gif","filesize":2152317,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/004_Create_Cloud_Automated_Workflow.gif","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate\/004_create_cloud_automated_workflow","alt":"Shows how to configure a cloud automated workflow with Survey123","author":"5861","description":"","caption":"","name":"004_create_cloud_automated_workflow","status":"inherit","uploaded_to":1462762,"date":"2022-02-07 02:09:01","modified":"2022-02-07 02:09:20","menu_order":0,"mime_type":"image\/gif","type":"image","subtype":"gif","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1600,"height":776,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/004_Create_Cloud_Automated_Workflow-213x200.gif","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/004_Create_Cloud_Automated_Workflow.gif","medium-width":464,"medium-height":225,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/004_Create_Cloud_Automated_Workflow.gif","medium_large-width":768,"medium_large-height":372,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/004_Create_Cloud_Automated_Workflow.gif","large-width":1600,"large-height":776,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/004_Create_Cloud_Automated_Workflow-1536x745.gif","1536x1536-width":1536,"1536x1536-height":745,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/004_Create_Cloud_Automated_Workflow.gif","2048x2048-width":1600,"2048x2048-height":776,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/004_Create_Cloud_Automated_Workflow-826x401.gif","card_image-width":826,"card_image-height":401,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/004_Create_Cloud_Automated_Workflow.gif","wide_image-width":1600,"wide_image-height":776}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h2>Configuring the workflow<\/h2>\n<p>In the next steps, you will configure the Survey123 module to trigger your workflow when a new response is submitted. You will also add a second module to add new records into your Microsoft Excel workbook.<\/p>\n<ul>\n<li>Sign in to create a new connection to Survey123<\/li>\n<li>Select the <em>Property Damage Report<\/em> survey that you authored previously<\/li>\n<li>Click on <em>New Step<\/em> and select the <em>Excel Online (Business)<\/em> module<\/li>\n<li>Select the <em>Add row into a table action<\/em><\/li>\n<li>Navigate to the location of your workbook and select <em>Table1<\/em><\/li>\n<\/ul>\n"},{"acf_fc_layout":"image","image":{"ID":1474892,"id":1474892,"title":"005_Confgure_Modules001b","filename":"005_Confgure_Modules001b-1.gif","filesize":1601540,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_Confgure_Modules001b-1.gif","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate\/005_confgure_modules001b-2","alt":"Shows how to configure the Survey123 and Excel modules","author":"5861","description":"","caption":"","name":"005_confgure_modules001b-2","status":"inherit","uploaded_to":1462762,"date":"2022-02-07 02:31:47","modified":"2022-02-07 02:32:08","menu_order":0,"mime_type":"image\/gif","type":"image","subtype":"gif","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1600,"height":776,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_Confgure_Modules001b-1-213x200.gif","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_Confgure_Modules001b-1.gif","medium-width":464,"medium-height":225,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_Confgure_Modules001b-1.gif","medium_large-width":768,"medium_large-height":372,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_Confgure_Modules001b-1.gif","large-width":1600,"large-height":776,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_Confgure_Modules001b-1-1536x745.gif","1536x1536-width":1536,"1536x1536-height":745,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_Confgure_Modules001b-1.gif","2048x2048-width":1600,"2048x2048-height":776,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_Confgure_Modules001b-1-826x401.gif","card_image-width":826,"card_image-height":401,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_Confgure_Modules001b-1.gif","wide_image-width":1600,"wide_image-height":776}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>Once a table is selected, the Add row into a table module will display all the columns you added into the spreadsheet. One by one, we will instruct Microsoft Power Automate to populate the values using data from the Survey123 record that triggered the workflow.<\/p>\n<ul>\n<li>Place your cursor over the Report ID input.<\/li>\n<li>From the Dynamic Content window, select the <em>feature result objectid<\/em> value<\/li>\n<li>Repeat the process with the remaining cells<\/li>\n<li>Click Save<\/li>\n<\/ul>\n"},{"acf_fc_layout":"image","image":{"ID":1474742,"id":1474742,"title":"005_Confgure_Modules002","filename":"005_Confgure_Modules002.gif","filesize":2753561,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_Confgure_Modules002.gif","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate\/005_confgure_modules002","alt":"This image shows how to map Survey123 dynamic content into the Microsoft Power Automate Excel module","author":"5861","description":"","caption":"","name":"005_confgure_modules002","status":"inherit","uploaded_to":1462762,"date":"2022-02-05 20:21:20","modified":"2022-02-05 22:28:43","menu_order":0,"mime_type":"image\/gif","type":"image","subtype":"gif","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1600,"height":750,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_Confgure_Modules002-213x200.gif","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_Confgure_Modules002.gif","medium-width":464,"medium-height":218,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_Confgure_Modules002.gif","medium_large-width":768,"medium_large-height":360,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_Confgure_Modules002.gif","large-width":1600,"large-height":750,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_Confgure_Modules002-1536x720.gif","1536x1536-width":1536,"1536x1536-height":720,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_Confgure_Modules002.gif","2048x2048-width":1600,"2048x2048-height":750,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_Confgure_Modules002-826x387.gif","card_image-width":826,"card_image-height":387,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_Confgure_Modules002.gif","wide_image-width":1600,"wide_image-height":750}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h2>Time to test!<\/h2>\n<p>Once the Power Automate workflow is saved, your Property Damage Report survey will be connected to your workflow.\u00a0 At that moment, every time you submit a record from your survey, the Microsoft Power Automate workflow will be triggered.<\/p>\n<ul>\n<li>Go back to the survey123.arcgis.com website<\/li>\n<li>Launch your survey in a web page (you could also download it into the Survey123 field app if you prefer)<\/li>\n<li>Complete your form and submit it<\/li>\n<li>Open your Excel workbook and you will see your Survey123 record be added right away!<\/li>\n<\/ul>\n"},{"acf_fc_layout":"image","image":{"ID":1474752,"id":1474752,"title":"005_First_Test","filename":"005_First_Test.gif","filesize":2562311,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_First_Test.gif","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate\/005_first_test","alt":"This image shows how Microsoft Power Automate adds data from Survey123 into the spreadsheet after a record is submitted","author":"5861","description":"","caption":"","name":"005_first_test","status":"inherit","uploaded_to":1462762,"date":"2022-02-05 20:35:52","modified":"2022-02-05 22:29:34","menu_order":0,"mime_type":"image\/gif","type":"image","subtype":"gif","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1600,"height":643,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_First_Test-213x200.gif","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_First_Test.gif","medium-width":464,"medium-height":186,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_First_Test.gif","medium_large-width":768,"medium_large-height":309,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_First_Test.gif","large-width":1600,"large-height":643,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_First_Test-1536x617.gif","1536x1536-width":1536,"1536x1536-height":617,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_First_Test.gif","2048x2048-width":1600,"2048x2048-height":643,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_First_Test-826x332.gif","card_image-width":826,"card_image-height":332,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/005_First_Test.gif","wide_image-width":1600,"wide_image-height":643}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h2>What&#8217;s next?<\/h2>\n<p>Collecting data is just the beginning. It is only when you get data into the hands of people who need it that magical things happen.\u00a0 Every time someone submits data through your survey, a new record is created in an ArcGIS layer. You can build web maps, real time dashboards and web applications to help people work with your data.\u00a0 Thanks to your Microsoft Power Automate workflow, your data is also instantly loaded into an Excel spreadsheet. Excel is a favorite for many people, and for good reasons.<\/p>\n<p>With Microsoft Power Automate and its Survey123 module, you can do much more. I encourage you to explore other <a href=\"https:\/\/powerautomate.microsoft.com\/en-US\/connectors\/details\/shared_survey123\/survey123\/\">Survey123 templates<\/a>.\u00a0 An an Esri user you can also access this <a href=\"https:\/\/www.esri.com\/training\/catalog\/5c392a12dd8b97414e076ae8\/automate-e-mail-notifications-with-survey123-for-arcgis\/\">55 minute training seminar<\/a>.\u00a0 Do not hesitate posting your questions to the <a href=\"https:\/\/community.esri.com\/t5\/arcgis-survey123\/ct-p\/arcgis-survey123\">Survey123 Esri Community<\/a>.<\/p>\n"}],"related_articles":[{"ID":1287542,"post_author":"229722","post_date":"2021-07-09 09:32:21","post_date_gmt":"2021-07-09 16:32:21","post_content":"","post_title":"Create ArcGIS Workflow Manager Jobs Using Survey123 Webhooks","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"create-arcgis-workflow-manager-jobs-using-survey123-webhooks","to_ping":"","pinged":"","post_modified":"2025-06-27 10:39:41","post_modified_gmt":"2025-06-27 17:39:41","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1287542","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"1","filter":"raw"},{"ID":1390972,"post_author":"5861","post_date":"2021-11-05 14:04:52","post_date_gmt":"2021-11-05 21:04:52","post_content":"","post_title":"Crowdsourcing oiled wildlife reports with ArcGIS Survey123","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"crowdsourcing-oiled-wildlife-reports-with-arcgis-survey123","to_ping":"","pinged":"","post_modified":"2021-11-08 12:51:44","post_modified_gmt":"2021-11-08 20:51:44","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1390972","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":861511,"post_author":"5311","post_date":"2020-05-13 11:16:35","post_date_gmt":"2020-05-13 18:16:35","post_content":"","post_title":"New White Paper: Discovering and Limiting Access to Public Survey123 Results","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"discovering-and-limiting-access-to-public-survey123-results","to_ping":"","pinged":"","post_modified":"2020-05-13 11:22:22","post_modified_gmt":"2020-05-13 18:22:22","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=861511","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":586992,"post_author":"9232","post_date":"2019-08-19 09:38:03","post_date_gmt":"2019-08-19 16:38:03","post_content":"","post_title":"Ten tips for using Survey123 and Esri Story Maps in your classroom","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"10-practical-tips-for-incorporating-survey123-and-esri-story-maps-into-your-classroom","to_ping":"","pinged":"","post_modified":"2020-02-19 08:49:01","post_modified_gmt":"2020-02-19 16:49:01","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=586992","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":1438762,"post_author":"5861","post_date":"2021-12-15 10:43:07","post_date_gmt":"2021-12-15 18:43:07","post_content":"","post_title":"What's new in ArcGIS Survey123 (December 2021)","post_excerpt":"","post_status":"publish","comment_status":"closed","ping_status":"closed","post_password":"","post_name":"whats-new-in-arcgis-survey123-december-2021","to_ping":"","pinged":"","post_modified":"2021-12-15 11:06:37","post_modified_gmt":"2021-12-15 19:06:37","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1438762","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":1403792,"post_author":"5861","post_date":"2021-11-18 11:43:07","post_date_gmt":"2021-11-18 19:43:07","post_content":"","post_title":"What's new in ArcGIS Survey123 (November 2021)","post_excerpt":"","post_status":"publish","comment_status":"closed","ping_status":"closed","post_password":"","post_name":"whats-new-in-arcgis-survey123-november-2021","to_ping":"","pinged":"","post_modified":"2021-11-18 11:45:46","post_modified_gmt":"2021-11-18 19:45:46","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1403792","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"}],"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/survey123_workflow-1.png","wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/Bannr-2.png","authors":[{"ID":5861,"user_firstname":"Ismael","user_lastname":"Chivite","nickname":"Ismael Chivite","user_nicename":"ismael","display_name":"ismael","user_email":"ichivite@esri.com","user_url":"","user_registered":"2018-03-02 00:17:40","user_description":"Ismael Chivite joined Esri in 2002. A geographer by training, he loves helping people leverage GIS to improve the way they work. As a Senior Product Manager, Ismael is always looking for ideas to create new and improve existing Esri products. Outside working hours: Legos, rock climbing, Romanesque architecture and jamon iberico. On occasion, he enjoys jamon during working hours too.","user_avatar":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/376b1b661ebce7bc9d8fb4d600a7ed5a7b86615461ac4065a1df7e0f43b61ceb?s=96&#038;d=blank&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/376b1b661ebce7bc9d8fb4d600a7ed5a7b86615461ac4065a1df7e0f43b61ceb?s=192&#038;d=blank&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' loading='lazy' decoding='async'\/>"}]},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v25.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Instantly load Survey123 data in Excel with Microsoft Power Automate<\/title>\n<meta name=\"description\" content=\"A step by step guide to help you instantly load Survey123 records into a Microsoft Excel spreadsheet using Microsoft Power Automate\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Load Survey123 data into Excel instantly with Microsoft Power Automate\" \/>\n<meta property=\"og:description\" content=\"A step by step guide to help you instantly load Survey123 records into a Microsoft Excel spreadsheet using Microsoft Power Automate\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate\" \/>\n<meta property=\"og:site_name\" content=\"ArcGIS Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-08T00:10:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esri.com\/arcgis-blog\/wp-content\/uploads\/2022\/02\/survey123_workflow.png\" \/>\n\t<meta property=\"og:image:width\" content=\"960\" \/>\n\t<meta property=\"og:image:height\" content=\"538\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/survey123_workflow.png\" \/>\n<meta name=\"twitter:site\" content=\"@ESRI\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate\"},\"author\":{\"name\":\"ismael\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/b5d3660d7f1c5da053c76a44442152dd\"},\"headline\":\"Load Survey123 data into Excel instantly with Microsoft Power Automate\",\"datePublished\":\"2022-02-07T02:42:17+00:00\",\"dateModified\":\"2022-02-08T00:10:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate\"},\"wordCount\":10,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"Automation\",\"email\",\"power automate\",\"smart form\",\"Survey123\"],\"articleSection\":[\"Constituent Engagement\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate\",\"name\":\"Instantly load Survey123 data in Excel with Microsoft Power Automate\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2022-02-07T02:42:17+00:00\",\"dateModified\":\"2022-02-08T00:10:47+00:00\",\"description\":\"A step by step guide to help you instantly load Survey123 records into a Microsoft Excel spreadsheet using Microsoft Power Automate\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Load Survey123 data into Excel instantly with Microsoft Power Automate\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"name\":\"ArcGIS Blog\",\"description\":\"Get insider info from Esri product teams\",\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\",\"name\":\"Esri\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"width\":400,\"height\":400,\"caption\":\"Esri\"},\"image\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/esrigis\/\",\"https:\/\/x.com\/ESRI\",\"https:\/\/www.linkedin.com\/company\/5311\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/b5d3660d7f1c5da053c76a44442152dd\",\"name\":\"ismael\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/376b1b661ebce7bc9d8fb4d600a7ed5a7b86615461ac4065a1df7e0f43b61ceb?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/376b1b661ebce7bc9d8fb4d600a7ed5a7b86615461ac4065a1df7e0f43b61ceb?s=96&d=blank&r=g\",\"caption\":\"ismael\"},\"description\":\"Ismael Chivite joined Esri in 2002. A geographer by training, he loves helping people leverage GIS to improve the way they work. As a Senior Product Manager, Ismael is always looking for ideas to create new and improve existing Esri products. Outside working hours: Legos, rock climbing, Romanesque architecture and jamon iberico. On occasion, he enjoys jamon during working hours too.\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/ismael\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Instantly load Survey123 data in Excel with Microsoft Power Automate","description":"A step by step guide to help you instantly load Survey123 records into a Microsoft Excel spreadsheet using Microsoft Power Automate","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate","og_locale":"en_US","og_type":"article","og_title":"Load Survey123 data into Excel instantly with Microsoft Power Automate","og_description":"A step by step guide to help you instantly load Survey123 records into a Microsoft Excel spreadsheet using Microsoft Power Automate","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2022-02-08T00:10:47+00:00","og_image":[{"width":960,"height":538,"url":"https:\/\/www.esri.com\/arcgis-blog\/wp-content\/uploads\/2022\/02\/survey123_workflow.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/survey123_workflow.png","twitter_site":"@ESRI","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate"},"author":{"name":"ismael","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/b5d3660d7f1c5da053c76a44442152dd"},"headline":"Load Survey123 data into Excel instantly with Microsoft Power Automate","datePublished":"2022-02-07T02:42:17+00:00","dateModified":"2022-02-08T00:10:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate"},"wordCount":10,"commentCount":4,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["Automation","email","power automate","smart form","Survey123"],"articleSection":["Constituent Engagement"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate","name":"Instantly load Survey123 data in Excel with Microsoft Power Automate","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2022-02-07T02:42:17+00:00","dateModified":"2022-02-08T00:10:47+00:00","description":"A step by step guide to help you instantly load Survey123 records into a Microsoft Excel spreadsheet using Microsoft Power Automate","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/survey123\/constituent-engagement\/instantly-load-survey123-data-in-excel-with-microsoft-power-automate#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Load Survey123 data into Excel instantly with Microsoft Power Automate"}]},{"@type":"WebSite","@id":"https:\/\/www.esri.com\/arcgis-blog\/#website","url":"https:\/\/www.esri.com\/arcgis-blog\/","name":"ArcGIS Blog","description":"Get insider info from Esri product teams","publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization","name":"Esri","url":"https:\/\/www.esri.com\/arcgis-blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","width":400,"height":400,"caption":"Esri"},"image":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/esrigis\/","https:\/\/x.com\/ESRI","https:\/\/www.linkedin.com\/company\/5311\/"]},{"@type":"Person","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/b5d3660d7f1c5da053c76a44442152dd","name":"ismael","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/376b1b661ebce7bc9d8fb4d600a7ed5a7b86615461ac4065a1df7e0f43b61ceb?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/376b1b661ebce7bc9d8fb4d600a7ed5a7b86615461ac4065a1df7e0f43b61ceb?s=96&d=blank&r=g","caption":"ismael"},"description":"Ismael Chivite joined Esri in 2002. A geographer by training, he loves helping people leverage GIS to improve the way they work. As a Senior Product Manager, Ismael is always looking for ideas to create new and improve existing Esri products. Outside working hours: Legos, rock climbing, Romanesque architecture and jamon iberico. On occasion, he enjoys jamon during working hours too.","url":"https:\/\/www.esri.com\/arcgis-blog\/author\/ismael"}]}},"text_date":"February 6, 2022","author_name":"ismael","author_page":"https:\/\/www.esri.com\/arcgis-blog\/author\/ismael","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/02\/Bannr-2.png","primary_product":"ArcGIS Survey123","tag_data":[{"term_id":27481,"name":"Automation","slug":"automation","term_group":0,"term_taxonomy_id":27481,"taxonomy":"post_tag","description":"","parent":0,"count":38,"filter":"raw"},{"term_id":252272,"name":"email","slug":"email","term_group":0,"term_taxonomy_id":252272,"taxonomy":"post_tag","description":"","parent":0,"count":3,"filter":"raw"},{"term_id":761682,"name":"power automate","slug":"power-automate","term_group":0,"term_taxonomy_id":761682,"taxonomy":"post_tag","description":"","parent":0,"count":7,"filter":"raw"},{"term_id":31861,"name":"smart form","slug":"smart-form","term_group":0,"term_taxonomy_id":31861,"taxonomy":"post_tag","description":"","parent":0,"count":11,"filter":"raw"},{"term_id":42371,"name":"Survey123","slug":"survey123","term_group":0,"term_taxonomy_id":42371,"taxonomy":"post_tag","description":"","parent":0,"count":66,"filter":"raw"}],"category_data":[{"term_id":37131,"name":"Constituent Engagement","slug":"constituent-engagement","term_group":0,"term_taxonomy_id":37131,"taxonomy":"category","description":"","parent":0,"count":391,"filter":"raw"}],"product_data":[{"term_id":36691,"name":"ArcGIS Survey123","slug":"survey123","term_group":0,"term_taxonomy_id":36691,"taxonomy":"product","description":"","parent":36591,"count":179,"filter":"raw"}],"primary_product_link":"https:\/\/www.esri.com\/arcgis-blog\/?s=#&products=survey123","_links":{"self":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1462762","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/types\/blog"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/users\/5861"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=1462762"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1462762\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=1462762"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=1462762"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=1462762"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=1462762"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=1462762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}