cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fwyf
Level: Powered On

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
fwyf
Level: Powered On

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.  

fwyf
Level: Powered On

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,533)