Answered

Survey123 datetime field is not properly transferred to excel sheet by powerautomate flow

(0) Share

Report

Posted on by karyal

I am using survey123 to collect water sample data but once the flow is successful date and time field in excel are just some random numbers. I need help on this issue. I appreciate your input

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Ed Gonzales 4,531 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@karyal
Hey there. So it looks like Survey123 is storing the date as a number of milliseconds since 1/1/1970. Weird, right?

To account for this, try inserting a Compose step above your excel step with the following expression:
addSeconds('1970-01-01', div(<DATEFIELD>, 1000))

where <DATEFIELD> is the dynamic value from your survey.

Hope that helps, please keep us posted.
-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @karyal ,

Have a good day . Has the issue been resolved?

Best Regards,

Wearsky

Was this reply helpful? Yes No
Verified answer

karyal 11 on at

Like (0)

Report
Copy link

Link copied!

That did not solve the problem yet.
However, I tweaked the excel itsself with formula creating another field and applied calculation "=F11/86400000+DATE(1970,1,1)-"06:00"'

Was this reply helpful? Yes No