topic Re: Converting time using Power Automate and Survey123 in ArcGIS Survey123 Questions

Converting time using Power Automate and Survey123

DaveK — Thu, 28 Jan 2021 14:20:34 GMT

Hello!

I'm using Power Automate to send a confirmation email when a survey is submitted. I have a dateTime field within my survey and I am interested in converting the time to be understandable within an email. As I understand it the survey contains the date/time in Epoch time. I found an article explaining how to perform this conversion but I seem to be doing something wrong, because the Power Automate process throws an error on my expression.

Link to the conversion article - https://support.esri.com/en/technical-article/000023954

And here is my expression -

addSeconds('1970-1-1', Div(triggerBody()?['feature']?['attributes']?['datetime'],1000))

If anyone has done this conversion before and has information it would be appreciated!

Thanks.

Re: Converting time using Power Automate and Survey123

IsmaelChivite — Thu, 28 Jan 2021 19:49:42 GMT

I think you are just missing the format string at the end.

In Power Automate, click on the body input box of your email action
Select Dynamic Content
Switch to the Expression tab
Type addSeconds('1970-1-1',Div(
Then insert the date value from the survey (switching momentarily to dynamic content to select your date question in the survey).
Your expression will look something like this: addSeconds('1970-1-1',Div(triggerBody()?['feature']?['attributes']?['yourdatequestion']
Now add ,1000),'yyyy-MM-dd')
Your final expression will be something like this

addSeconds('1970-1-1',Div(triggerBody()?['feature']?['attributes']?['yourdatequestion'] ,1000),'yyyy-MM-dd')

Re: Converting time using Power Automate and Survey123

Ursu_Lacramioara — Mon, 20 Jun 2022 20:17:39 GMT

Hi Ismael @IsmaelChivite

I used your logic for the Date/Time and I don't get the correct time in the email. I created a test record set to Dec 25, 2021 @1pm and the email was generated for Date as Dec 24, 2021 @7pm. any suggestions? Thank you!

Lacri

Re: Converting time using Power Automate and Survey123

IsmaelChivite — Mon, 21 Aug 2023 21:45:09 GMT

@Ursu_Lacramioara Date objects in an esriFieldTypeDate column are stored in UTC. That explains the difference you see.

You can convert the time zone as shown in the diagram below. If you are using the Convert time zone module, you do not need to include the date format parameter in the addSeconds operation.

Re: Converting time using Power Automate and Survey123

RutledgeNicholas — Thu, 02 Nov 2023 18:07:00 GMT

@IsmaelChivite, I've followed your instructions but my conversion is failing using the code. Following your exact instructions are insert the following code but then showing as an invalid code. Any changes to this process or pointer for what I am doing incorrectly?

addSeconds('1970-1-1',Div(triggerBody()?['body/feature/attributes/submissionDate'],1000,'yyyy-MM-dd'))

Re: Converting time using Power Automate and Survey123

RutledgeNicholas — Fri, 03 Nov 2023 15:06:50 GMT

I'm trying to convert my date to MM-DD-YYYY format and I've followed the instructions but my conversion is failing using the code. Following the exact instructions that are written and inserting the following code, but then showing as an invalid code. Any changes to this process or pointer for what I am doing incorrectly?

addSeconds('1970-1-1',Div(triggerBody()?['body/feature/attributes/submissionDate'],1000,'yyyy-MM-dd'))

Re: Converting time using Power Automate and Survey123

Ursu_Lacramioara — Fri, 03 Nov 2023 15:14:52 GMT

Hi Nicholas - this is what i have in my flows for Add to Time:

Div(triggerOutputs()?['body/feature/attributes/SiteVisitDate'],1000)

Re: Converting time using Power Automate and Survey123

RutledgeNicholas — Fri, 03 Nov 2023 15:35:43 GMT

@Ursu_Lacramioara Thanks! This seem to have fixed my first issue. Since my Date field is a date only field, are you aware of any ways of getting the Thh:mm:ss:ms portion of the date field removed?

Re: Converting time using Power Automate and Survey123

Ursu_Lacramioara — Fri, 03 Nov 2023 15:43:57 GMT

do you have this, where Calculated Time equals to body ('Add_to_time')

Re: Converting time using Power Automate and Survey123

RutledgeNicholas — Fri, 03 Nov 2023 15:53:00 GMT

@Ursu_Lacramioara This worked perfectly! Thank you!!!