https://community.esri.com/t5/arcgis-connectors-for-power-automate-questions/survey123-gt-automate-gt-excel-date-time/m-p/1294730#M226 <P>Hi Automaters,</P><P>New to using Microsoft Automate. Hoping this is a quick fix for someone.</P><P>I have set up a flow so when someone submits a survey123 that info gets written into a spreadsheet in Sharepoint. It's working great! Except for the date/time format in two fields...</P><P>The two fields are date fields in S123/AGOL, so I'm inputting them as dynamic content, and I want them to be in UTC + 12.</P><P>I was advised this could work- putting in an expression.&nbsp;</P><P><STRONG><EM>formatDateTime(addHours(utc<FONT color="#FF99CC">Now</FONT>(triggerOutputs()?['body/feature/attributes/Contact_date']),12),'dd/MM/yyyy&nbsp;HH:mm')</EM></STRONG></P><P>The flow is failing though, and this is the error I'm getting.</P><P><STRONG><EM>Unable to process template language expressions in action 'Add_a_row_into_a_table_-_Consult_on_effects_Contractor' inputs at line '0' and column '0': 'The template language function 'utcNow' expects its parameter to be of type string. The provided value is of type 'Integer'. Please see&nbsp;<A href="https://aka.ms/logicexpressions#utcnow" target="_blank" rel="noopener nofollow noreferrer">https://aka.ms/logicexpressions#utcnow</A>&nbsp;for usage details.'.</EM></STRONG></P><P>I posted in the Microsoft Automate Community forums on their website, but haven't gotten to the root of the problem yet. I thought maybe someone in this community has experienced it before since you're also AGOL users.</P><P>Thanks in advance for your help.</P><P>&nbsp;</P> Wed, 31 May 2023 20:28:02 GMT elpinguino 2023-05-31T20:28:02Z https://community.esri.com/t5/arcgis-connectors-for-power-automate-questions/survey123-gt-automate-gt-excel-date-time/m-p/1294730#M226 <P>Hi Automaters,</P><P>New to using Microsoft Automate. Hoping this is a quick fix for someone.</P><P>I have set up a flow so when someone submits a survey123 that info gets written into a spreadsheet in Sharepoint. It's working great! Except for the date/time format in two fields...</P><P>The two fields are date fields in S123/AGOL, so I'm inputting them as dynamic content, and I want them to be in UTC + 12.</P><P>I was advised this could work- putting in an expression.&nbsp;</P><P><STRONG><EM>formatDateTime(addHours(utc<FONT color="#FF99CC">Now</FONT>(triggerOutputs()?['body/feature/attributes/Contact_date']),12),'dd/MM/yyyy&nbsp;HH:mm')</EM></STRONG></P><P>The flow is failing though, and this is the error I'm getting.</P><P><STRONG><EM>Unable to process template language expressions in action 'Add_a_row_into_a_table_-_Consult_on_effects_Contractor' inputs at line '0' and column '0': 'The template language function 'utcNow' expects its parameter to be of type string. The provided value is of type 'Integer'. Please see&nbsp;<A href="https://aka.ms/logicexpressions#utcnow" target="_blank" rel="noopener nofollow noreferrer">https://aka.ms/logicexpressions#utcnow</A>&nbsp;for usage details.'.</EM></STRONG></P><P>I posted in the Microsoft Automate Community forums on their website, but haven't gotten to the root of the problem yet. I thought maybe someone in this community has experienced it before since you're also AGOL users.</P><P>Thanks in advance for your help.</P><P>&nbsp;</P> Wed, 31 May 2023 20:28:02 GMT https://community.esri.com/t5/arcgis-connectors-for-power-automate-questions/survey123-gt-automate-gt-excel-date-time/m-p/1294730#M226 elpinguino 2023-05-31T20:28:02Z https://community.esri.com/t5/arcgis-connectors-for-power-automate-questions/survey123-gt-automate-gt-excel-date-time/m-p/1294760#M228 <P>Survey123 appears to be passing UNIX timestamps to your DynamicContent. Try instantiating a variable that converts your UNIX integer to a string and then format that in your Timezone offset expression.</P><P><A href="https://powerusers.microsoft.com/t5/Building-Flows/Got-a-recipe-for-converting-a-unix-timestamp-to-a-utc-date/td-p/137246" target="_blank">https://powerusers.microsoft.com/t5/Building-Flows/Got-a-recipe-for-converting-a-unix-timestamp-to-a-utc-date/td-p/137246</A></P> Wed, 31 May 2023 20:51:47 GMT https://community.esri.com/t5/arcgis-connectors-for-power-automate-questions/survey123-gt-automate-gt-excel-date-time/m-p/1294760#M228 CoffeeforClosers 2023-05-31T20:51:47Z https://community.esri.com/t5/arcgis-connectors-for-power-automate-questions/survey123-gt-automate-gt-excel-date-time/m-p/1294842#M230 <P>Thank you so much&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/425367">@CoffeeforClosers</a>&nbsp;. That was doing my head in! Fixed now!</P> Thu, 01 Jun 2023 00:03:40 GMT https://community.esri.com/t5/arcgis-connectors-for-power-automate-questions/survey123-gt-automate-gt-excel-date-time/m-p/1294842#M230 elpinguino 2023-06-01T00:03:40Z