cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TheRydad
Advocate I
Advocate I

Trying to put TypeForm timestamp in an Excel table

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?

1 ACCEPTED SOLUTION

Accepted Solutions
tpalmer
Power Automate
Power Automate

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!

View solution in original post

5 REPLIES 5
tpalmer
Power Automate
Power Automate

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!

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.

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.

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

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

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (1,886)