web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Get only hour from a s...

Power Apps

Answered

Get only hour from a split function?

(0) Share

Report

Report

Posted on by TimmyBoy

997

Hello,

I'm trying to get only the hour if the date is today

If not show date and time

But i don't get anywhere??

Last(
 FirstN(
 Split(
 ThisItem.Result,
 ";"
 ),
 1
 )
).Result
& " by " & Last(
 FirstN(
 Split(
 ThisItem.Result,
 ";"
 ),
 2
 ).Result
).Result

The data looks like:

12-07-2022 19:27:22;John Doe;test@test.com;
16-06-2022 05:17:52;John Doe;test@test.com;

So i like to get the result like:

19:27:22

Thank you

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

SagarVIS96 212 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @TimmyBoy ,
You can use following code:
Last(Split(First(Split("12-07-2022 19:27:22;John Doe;test@test.com;",";")).Result," ")).Result

It will give you output like this: 19:27:22

Thanks
TimmyBoy 997 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @SagarVIS96
Awesome, what about if the date isn't today?
How to check that and then show it completely.
Thank you

I used your first code like this Last(Split(First(Split(ThisItem.Result,";")).Result," ")).Result Thank you.

Join the conversation