Unanswered

Time minutes returning only one digit if less than 10

(0) Share

Report

Posted on by PhillKebab01

I'm 3 days in to Power Apps, so please go easy!

I've created an app which the user can select the date, hour and minute. The user then click a button which is connected to a Power Automate script and sends an email.

Below is the code used to capture the details within the app:

AddanitemtoSharePointandsendanemail.Run(DataCardValue8.Text, DataCardValue12.Text, DateValue1.SelectedDate, Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value);"mm", DataCardValue7.Text, User().FullName, User().Email);
Notify("Email has been sent");

Everything works Ok unless the user selects minutes which are less than 10. So for example, if you select 13:05, the email prints 13:5

If the user selects 15:00, the email prints 15:0. If the user select 12:30 from the app, the email prints 12:30 which is fine.

Within the SharePoint table, its stored correctly. It seems to be missing off the lead zero. I'm assuming this may be due to converting to text but can't seem to find a work around.

Any help and support would be welcome. Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Dioz 61 on at

Like (1)

Report
Copy link

Link copied!
I ran into a similar problem lately. In my case the problem was that Power Apps recognizes "mm" as well as "MM" as month, if it's not connected to hh.
Was able to resolve it by using something like:
Right( Text( TimeValue(MinuteValue1.Selected.Value), "hh:mm" ), 2 )

I can't say for sure if it helps in your case, but you might want to give it a try

Was this reply helpful? Yes No
Devvj 1,132 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @PhillKebab01
Problem seems to be that you send the Hour and Minute parameters wraped in "Value()", which basicly cast them into a number, would it be possible to wrap it in "Text()" instead, with additional formating like the example @Dioz made above?

Was this reply helpful? Yes No
PhillKebab01 6 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the support. I'm now getting an output of 13:00 if the user selects any minute from the dropdown list.

AddanitemtoSharePointandsendanemail.Run(DataCardValue8.Text, DataCardValue12.Text, DateValue1.SelectedDate, Value(HourValue1.Selected.Value), Right(Text( TimeValue(MinuteValue1.Selected.Value), "hh:mm"),2), DataCardValue7.Text, User().FullName, User().Email);
Notify("Email has been sent");

Was this reply helpful? Yes No
Devvj 1,132 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Good to hear @PhillKebab01 ,
please mark @Dioz post as the solution, to make it easier for others to find as well.

Was this reply helpful? Yes No
PhillKebab01 6 on at

Like (0)

Report
Copy link

Link copied!

Hi Devvj, Just replying to say the issue is still not fixed. It displays 13:00 no matter what value is selected from the list.
Any other ideas to try?
Thanks.

Was this reply helpful? Yes No
Devvj 1,132 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Well if it is just dropdown boxes i guess you could have a basic IF-statement to just concatinate the 0 if the value is sub 10, something like this
If(Value(MinuteValue1.Selected.Value) < 10, Contactenate("0",Text(MinuteValue1.Selected.Value)),Text(MinuteValue1.Selected.Value))

Was this reply helpful? Yes No
PhillKebab01 6 on at

Like (0)

Report
Copy link

Link copied!

Thanks Devvj, I was mulling this over in my head, exactly what I was going to try next. I will give it a go later on today and let you know.
Really appreciate the time replying back to me.

Was this reply helpful? Yes No