cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
carem
Advocate II
Advocate II

Wrong Time when Update from flow.

Hi guys;
I have a problem to get right time from flow to Sharepoint

I initialize a variable in Flow to hold the Time Value from Power App:

Initialize VariableInitialize Variable

And Update File Properties Action to update Payment Date metadata of Sharepoint Library File. You can see the Time is: 23/12/2019 10:15 AM

But in my Sharepoint Library, the Time is advance 7 hrs. 

23/12/2019 17:1523/12/2019 17:15

 

My country is Vietnam, and I in the Time Zone GMT+7.

How can I set the right time?

2 REPLIES 2
edgonzales
Super User
Super User

@carem 

Hi there.  It's probably just a matter of converting the timezone from the universal time (UTC), which is how all times are stored.

 

To do this, you can either use an expression with the ConvertFromUTC() function.

 

Or, look for the action "Convert Time Zone" which looks like this:

 

20191222a.PNG

 

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.

Hey @carem 

 

To add to what @edgonzales  has pointed out, you might want to change the regional settings of the SharePoint site. Scenarios here: 

1. If the flow is sending time converted to your time zone to SharePoint, change the list settings to point UTC time zone. 

2. If the flow is sending UTC time, then change the regional settings in SharePoint to your timezone.

 

I have listed this here:  https://powerusers.microsoft.com/t5/Microsoft-Flow-Community-Blog/10-MS-Flow-hacks-troubleshoots-wor... 

 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,864)