nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Converting time using Power Automate and Survey123

DaveK

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.

Find more posts tagged with

Accepted answers

IsmaelChivite

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')

All comments

Ursu_Lacramioara

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

RutledgeNicholas

@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?

20231103_PowerAutomate_DateConvertedWith-THH-MM-SS-MS.png

Ursu_Lacramioara

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

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

RutledgeNicholas

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'))

20231103_PowerAutomate_DateConversion.png

20231103_PowerAutomate_Survey123_DateConversion.png

RutledgeNicholas

@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'))

IsmaelChivite

@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.

Ursu_Lacramioara

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

IsmaelChivite

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')

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.