cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Celdere
Level: Powered On

Timezone conversion no longer working - I haven't touched it!

Is it possible for flows to break themselves?

 

I am trying to do a simple flow to keep track of my timecard for me. Up until a few days ago, I was using a convert timezone function to take the timestamp into both a short date and a short time (using the same input, converting twice for two outputs) and inputting them into an excel table. This was working properly up until a few days ago. Now, the time conversion is no longer working and is providing me with the UTC date and PST short time. Once I got this flow up and running a few weeks ago I haven't edited it at all! So I'm not sure why suddenly only the time converter isn't working. It shows the correct input, but for some reason, the output changes. Sample text I'm getting under "Insert Row" included. The working one is first, the broken one second. As you can see the inputs are still the same but the outputs are no longer correct.

 

INPUTS
File name
/Timecard.xlsx
Table name
Timecard
Column1
7/5/2018
Column2
6:41 PM
 
OUTPUTS
 
Column1
7/5/2018
Column2
2018-07-06T18:41:00Z
Row id
gVAt_hb0Klo
 
----------------------------------- 
 
INPUTS
File name
/Timecard.xlsx
Table name
Timecard
 
Column1
7/3/2018
Column2
6:58 PM
 
OUTPUTS
 
Column1
7/3/2018
Column2
6:58 PM
Row id
NTDbckh4EwM
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Timezone conversion no longer working - I haven't touched it!

Hi @Celdere,

 

I have made a test on my side and don't have the issue that you mentioned.

 

The screenshot of my flow as below:

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

The run details of the Insert row action as below:

Capture.PNG 

 

 

Please take a try to create a new flow and made a test on your side to see if the issue still exists.

 

Please let me know if your problem could be solved.

 

 

Best regards,

Alice

 

 

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: Timezone conversion no longer working - I haven't touched it!

Hi @Celdere,

 

Could you please share a screenshot of the configuration of your flow?

Could you please share more details about your scenes?

 

Please share more details so we would try to provide a proper workaround for you.

 

Best regards,

Alice

Celdere
Level: Powered On

Re: Timezone conversion no longer working - I haven't touched it!

Screen Shot 2018-07-10 at 10.21.31 AM.pngRun July 10. Output time formatting doesn't match input formattingScreen Shot 2018-07-10 at 10.23.35 AM.pngRun July 3, Output formatting matches input formatting.

 

Here's what I'm seeing in the flow reports. It appears that the inputs are the same on both, but something changes between input and output to give me different formatting. Flow seems to have stopped working properly between July 5 and July 6.

 

Flow configuration is below and has not been changed since it was created in June. Definitely was not changed between July 5 and 6. It just no longer works. As I said, the Excel "Insert row" function is receiving the proper inputs, so the conversion functions I have set up are working properly, but somewhere between input and output the Insert Row function is losing the formatting.

 

Screen Shot 2018-07-10 at 10.27.01 AM.png

Community Support Team
Community Support Team

Re: Timezone conversion no longer working - I haven't touched it!

Hi @Celdere,

 

I have made a test on my side and don't have the issue that you mentioned.

 

The screenshot of my flow as below:

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

The run details of the Insert row action as below:

Capture.PNG 

 

 

Please take a try to create a new flow and made a test on your side to see if the issue still exists.

 

Please let me know if your problem could be solved.

 

 

Best regards,

Alice

 

 

View solution in original post

Celdere
Level: Powered On

Re: Timezone conversion no longer working - I haven't touched it!

@v-yuazh-msft I recreated the flow and encountered the same issue when linking to the same spreadsheet. I created a new spreadsheet as a test and it worked correctly, so I guess I'll just use the new one going forward. I don't believe that I've changed the formatting of the table within the original spreadsheet, so I'm not sure what the issue is, but it's possible that there's a formatting issue on the Excel sheet that's causing the output to differ from the input. I had a hard time getting the flow set up to show the right formatting, so did change some cell formatting at the beginning that might not have kicked in until I got down to later rows.

 

Will be keeping an eye on the new one though just to see if it breaks too! And now that I better understand flow I won't need to format anything within the spreadsheet like I did before.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 291 members 4,455 guests
Please welcome our newest community members: