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

Extract time from the Date time output

Hello,

 

I converted the time to the way I want. Now I want to extract just the time into a variable. 8:24 PM in a variable. 

How can I do that?

Lana_0-1596075001324.png

 

Thank you in advance!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Resident Rockstar
Resident Rockstar

@Lana 

Did you try using the Format  String to be Short Time Pattern as below ,, this will extract the time part only

Mira_Ghaly_0-1596080007887.png

If this post helps you with your problem, please mark your as Accepted solution.

 

If you like my response, please give it a Thumbs Up.

 

MG (Naturally Curious)

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

View solution in original post

3 REPLIES 3
Resident Rockstar
Resident Rockstar

@Lana 

Did you try using the Format  String to be Short Time Pattern as below ,, this will extract the time part only

Mira_Ghaly_0-1596080007887.png

If this post helps you with your problem, please mark your as Accepted solution.

 

If you like my response, please give it a Thumbs Up.

 

MG (Naturally Curious)

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

View solution in original post

You could also use the substring function to extract the portion that you want. Oddly enough, I wrote a blog post about it yesterday: https://powerplatformpod.com/2020/07/28/environment-variables-part-3-and-bonus-substring-function/

 

Another tool in the tool belt at the very least!

 

Cheers,

 

DC

Thank you so much! I had clearly overlooked that option.

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (9,319)