<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Power Automate Excel update a row in ArcGIS Survey123 Questions</title>
    <link>https://community.esri.com/t5/arcgis-survey123-questions/power-automate-excel-update-a-row/m-p/1205558#M44431</link>
    <description>&lt;P&gt;I am in need of help with the update a row function. I would like to use it to determine what cell should be updated in my excel doc based on answers to Survey123 survey questions.&lt;/P&gt;&lt;P&gt;The first question would determine which row:&lt;/P&gt;&lt;DIV class=""&gt;&amp;nbsp;&lt;/DIV&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Hammers21_4-1661283775028.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/49216iD23149793590C861/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Hammers21_4-1661283775028.png" alt="Hammers21_4-1661283775028.png" /&gt;&lt;span class="lia-inline-image-caption" onclick="event.preventDefault();"&gt;Hammers21_4-1661283775028.png&lt;/span&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;The second question would determine the column:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Hammers21_5-1661283787859.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/49217i910175616C3EF8B7/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Hammers21_5-1661283787859.png" alt="Hammers21_5-1661283787859.png" /&gt;&lt;span class="lia-inline-image-caption" onclick="event.preventDefault();"&gt;Hammers21_5-1661283787859.png&lt;/span&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;And the data to be entered into the cell would be determined by answering a date question:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Hammers21_6-1661283810580.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/49218i30B834863016AF22/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Hammers21_6-1661283810580.png" alt="Hammers21_6-1661283810580.png" /&gt;&lt;span class="lia-inline-image-caption" onclick="event.preventDefault();"&gt;Hammers21_6-1661283810580.png&lt;/span&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;For reference, here's how my excel doc is set up:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Hammers21_0-1661359178758.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/49321iED3CA592A7F5C172/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Hammers21_0-1661359178758.png" alt="Hammers21_0-1661359178758.png" /&gt;&lt;span class="lia-inline-image-caption" onclick="event.preventDefault();"&gt;Hammers21_0-1661359178758.png&lt;/span&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks again for any help!&lt;/P&gt;</description>
    <pubDate>Wed, 24 Aug 2022 16:39:48 GMT</pubDate>
    <dc:creator>Hammers211</dc:creator>
    <dc:date>2022-08-24T16:39:48Z</dc:date>
    <item>
      <title>Power Automate Excel update a row</title>
      <link>https://community.esri.com/t5/arcgis-survey123-questions/power-automate-excel-update-a-row/m-p/1205558#M44431</link>
      <description>&lt;P&gt;I am in need of help with the update a row function. I would like to use it to determine what cell should be updated in my excel doc based on answers to Survey123 survey questions.&lt;/P&gt;&lt;P&gt;The first question would determine which row:&lt;/P&gt;&lt;DIV class=""&gt;&amp;nbsp;&lt;/DIV&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Hammers21_4-1661283775028.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/49216iD23149793590C861/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Hammers21_4-1661283775028.png" alt="Hammers21_4-1661283775028.png" /&gt;&lt;span class="lia-inline-image-caption" onclick="event.preventDefault();"&gt;Hammers21_4-1661283775028.png&lt;/span&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;The second question would determine the column:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Hammers21_5-1661283787859.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/49217i910175616C3EF8B7/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Hammers21_5-1661283787859.png" alt="Hammers21_5-1661283787859.png" /&gt;&lt;span class="lia-inline-image-caption" onclick="event.preventDefault();"&gt;Hammers21_5-1661283787859.png&lt;/span&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;And the data to be entered into the cell would be determined by answering a date question:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Hammers21_6-1661283810580.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/49218i30B834863016AF22/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Hammers21_6-1661283810580.png" alt="Hammers21_6-1661283810580.png" /&gt;&lt;span class="lia-inline-image-caption" onclick="event.preventDefault();"&gt;Hammers21_6-1661283810580.png&lt;/span&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;For reference, here's how my excel doc is set up:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Hammers21_0-1661359178758.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/49321iED3CA592A7F5C172/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Hammers21_0-1661359178758.png" alt="Hammers21_0-1661359178758.png" /&gt;&lt;span class="lia-inline-image-caption" onclick="event.preventDefault();"&gt;Hammers21_0-1661359178758.png&lt;/span&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks again for any help!&lt;/P&gt;</description>
      <pubDate>Wed, 24 Aug 2022 16:39:48 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-survey123-questions/power-automate-excel-update-a-row/m-p/1205558#M44431</guid>
      <dc:creator>Hammers211</dc:creator>
      <dc:date>2022-08-24T16:39:48Z</dc:date>
    </item>
  </channel>
</rss>

