How to inject time value separately in datetime value?

(0) Share

Report

Posted on by Dave Wi

Hello,

I require to update the date time value while submitting the date with specific time in the SharePoint list, for which I use the following formula Where "Label8" == "10:30 AM"

Label2.Text = Text( DateTimeValue( dTableDates.Selected.Date ), "[$-en-US]mm/dd/yyyy" & Label8.Text )

However, Label2.Text shows blank value in above case, however if I remove "& Label8.Text" in above formula, it shows correct Date value without time.

I have also tried to append time value "& TimeValue( "10:30:00 AM" )" as follows

Label2.Text = Text( DateTimeValue( dTableMeetingSlots.Selected.Date ), "[$-en-US]mm/dd/yyyy" & TimeValue( "10:30:00 AM" ) )

However still Label2.Text shows blank value - Can you please share, how can I show value "4/20/2021 10:30 AM" in Label2.Text ?

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report
Hi @dave8 :

Please try this formula:

Text(DateTimeValue( dTableDates.Selected.Date ), "[$-en-US]mm/dd/yyyy") & " " & Label8.Text

Best Regards,

Bof

Was this reply helpful? Yes No