cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
akbarmahfuzalam
Post Prodigy
Post Prodigy

UTC Time zone to Local Time Zone

Hi Team,

 

I am building a flow with Trigger of a button wherein I am capturing the Date Time but it's giving me UTC Time. Whereas I have an audience in different countries like Austria, Singapore, Manila, Srilanka, etc. After getting their data I want to send a consolidated report which is stored in SP List.

 

As of Now in the expression, I am using UTCNOW()

 

The attached image is the ref of the FLOW

I want the local time zone to be capture when a person triggers the button from their Mobile it needs to capture the local time of his country.

 

Please guide me on the steps or formula which can be used to overcome this huddle.

 

UTCNOW.JPG

Akbar Alam

Thanks in advance

6 REPLIES 6
gamoraes
Memorable Member
Memorable Member

Hi @akbarmahfuzalam 

 

When we use buttons we have a hidden property that calls  'key-button-timestamp', this property get the current timestamp from user that triggered the button

 

Look my flow below, the first action is user's time and the second is the utc time

 
 

image.png

 

To get this property just use this expression triggerBody()?['key-button-timestamp']

 

Your flow should be like this

 

image.png

 

 

hope this helps

 

Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


Hi Gustavo,

 

What action do I need to select after I trigger

 

Is it variable which I need to-  set variable or initialize variable

Or Current Time

Because I do not find the Timestamp for user as an action.

If you have template which I can copy as a clipboard.

 

 Variable.JPG

 

Hi Gustavo,

 

Please help me I am new to flow, your guide will help me to learn more.

 

I somehow come to the conclusion that I need to use the Compose function. But the formula you asked me to paste it's somehow showing a bit different.

 

I used the same output in the title- Create Items.

 

On my TrigerButton Flow, there are few ask for the User to input... all are in text with dropdown.

 

 

 

Variable.JPG

Hi @akbarmahfuzalam sorry for late response, its mothers day 😄

 

 

Your compose's formula is right, you triggered the flow by the phone?

 

Because this property only are filled when triggered by the phone button.

 

If your flow will be triggered by PC we'll need to make some changes.

 

Best Regards


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


Happy Mother Day!

 

What would be the changes because a  large audience is using the web version of my flow?

And I tried that on my Mobile to run the button. But it doesn't give me the result that I wanted.

If you could share that part only on email at akbarmahfuzalam@gmail.com so that I can use the as a clipboard and try to see the result. 

 Help is appreciated 

 

I have just checked and found it.. it works absolutely fine with mobile. But my queries still remain the same how would I achieve both.

Because my large audience is it on a Web browser in so many countries.

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (26,267)