cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KirstenACS
New Member

Converting Time in Microsoft Form Submission Time

I am trying to create a flow that enters data into an excel sheet. 

When the submission time is entered it is in the incorrect time zone. 

When I add the convert time zone setting the flow fails & I get the following error:

Evaluation of inputs for the expression action of kind 'ConvertTimeZone' failed: 'Required property 'baseTime' expects a value but got null. Path ''.'.

Any idea?

*P.S I have blocked out the location & file (however it is input in the flow)

Flow.png

1 REPLY 1
Ler
Advocate I
Advocate I

Hi @KirstenACS 

 

that way is working for me , but in a loop. i don't know if it doesn't mater about that.

but you still can use utcNow() to get the time when a new response. 

2021-01-28 14_10_45-编辑你的流 _ Power Automate 和另外 9 个页面 - 工作 - Microsoft​ Edge.png

 

BR

Ler

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.

Users online (3,603)