Answered

Trying to put TypeForm timestamp in an Excel table

(0) Share

Report

Posted on by TheRydad

I mapped the "Submitted date-time" and "Sent date-time" fields from a TypeForm form to columns in an Excel table. Both columns are blank following any form submission. All the user entered fields populate as expected.

Does anyone know why this is not working for me?

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Tessa Kloster Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @TheRydad - are you seeing the datetime values in the output of the TypeForm operation? A quick way to check is on the flow run itself, you can see the values that are outputted before they're passed to the Excel file. That will help narrow down whether there's an issue in the TypeForm operation or the Excel one. If you could share those detials in a direct message to me, that would be great!

Was this reply helpful? Yes No
TheRydad 17 on at

Like (0)

Report
Copy link

Link copied!

Thank you! I did not realize I could view the details of the steps in the flow.

Typeform is sending blank values for those fields. I will check on their side to see how it is supposed to work.

Was this reply helpful? Yes No
TheRydad 17 on at

Like (0)

Report
Copy link

Link copied!

Checking the flow run, the datetime values from TypeForm are not being sent. To test further, I created another flow to just create a file in OneDrive with those vlues. It, too, turns up empty for those values.

I manually connected to my TypeForm API in a web browser, and the datetime values "date_land" and "date_submit" are present for each entry I have made.

Is it possible that there is a bug in the TypeForm trigger and it is not mapping those fields correctly?

As a workaround, is there a way to get a timestamp value from when the flow itself runs? I only need the day, so the precise timestamp is not important to me.

Thank you.

Was this reply helpful? Yes No
Tessa Kloster Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@TheRydad - thanks for the details! We have reproduced the issue on our side and are investigating why the connector isn't returning the value that's coming back from TypeFrom.

There isn't a way to get the "current" time in a flow today (although please add it to our ideas page) - the closest option would be to add another action (such as "create a task" in Google, Todoist etc.) immediately after and use the time output from that. That would purely be a workaround but might unblock you while we investigate the bug!

Was this reply helpful? Yes No
TheRydad 17 on at

Like (0)

Report
Copy link

Link copied!

Thanks for verifying. This isn't a showstopping production issue for me now, but it is nice to validate the issue.

I might try one of your clever workarounds if this becomes more critical. I will also add the suggestion.

-r

Was this reply helpful? Yes No