cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Label showing time of another field is unable to show time when at default value

Hi all, 

 

I need to convert time to text value and update database entry (data type: time(7))

 

A textbox is setup for text input and then a lable is setup to convert text into HH:MM Am/PM format.  Setting of the label as below:Screen Shot 2017-06-27 at 3.25.21 PM.pngScreen Shot 2017-06-27 at 3.25.40 PM.png

 

At default, the textbox is set at the current time using Now() function.

Screen Shot 2017-06-27 at 3.19.19 PM.png

 

However the lable is unable to show time when textbox is at default value.

Screen Shot 2017-06-27 at 3.24.56 PM.png

 

Very apprecaite if you can tell me how I can get the label to reflect value of the textbox when at its default value.

 

Much thanks in advanced.

 

Regards,

Freda

2 REPLIES 2
Highlighted
Regular Visitor

Re: Label showing time of another field is unable to show time when at default value

I also tried to set for the label to refer to the textbox (tiEndTime)

If( IsBlank( tiEndTime.Text ), Text(Now(), "[$-en-US]HH:MM AM/PM"), Text(TimeValue(tiEndTime.Text), "[$-en-US]hh:mm AM/PM"))

 

Not successful.  

Highlighted
Regular Visitor

Re: Label showing time of another field is unable to show time when at default value

I also tried to set for the label to refer to the textbox (tiEndTime)

If( IsBlank( tiEndTime.Text ), Text(Now(), "[$-en-US]HH:MM AM/PM"), Text(TimeValue(tiEndTime.Text), "[$-en-US]hh:mm AM/PM"))

 

Not successful.  

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (10,831)