Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Need help Please

Posted on 22 Nov 2024 04:27:28 by 4
Hi
 
I have a column  "Last Updated on" in my Sql Server Database, as Date Time.  I am trying to update it on my Power App, which is working well for the other fields ( Text, Number, ...).
When I add the "Last Updated On" in my application. it displays as below, in 3 segments:
 
How can I get it to only One data field with the Date and Time concatenated using the Now() function. Thanks to advise me. I have been stuck on this for some time despite looking for videos. 
Categories:
  • timl Profile Picture
    timl 31,838 on 22 Nov 2024 at 09:44:46
    Need help Please
    Hi JC-04111302-0
     
    From what I understand, you want to replace the datepicker, hour dropdown, and minute dropdown with a single text input control that defaults to the current date and time. 
     
    To do this, you would delete these 3 controls and insert a text input control within the existing data card (let's call the new control txtLastUpdatedOn). You would set the Default property of this to Now().
     
    You would then change the Update property of the data card that contains txtLastUpdatedOn to the following:
     
    DateTimeValue(txtLastUpdatedOn.Text)
     
  • ronaldwalcott Profile Picture
    ronaldwalcott 716 on 22 Nov 2024 at 06:26:30
    Need help Please
    If you are not entering a datetime you could use a label to show Now()
  • Meekou Profile Picture
    Meekou 128 on 22 Nov 2024 at 05:43:03
    Need help Please
    For build date time based on multiple input, you could try DateTime function to combine them.
    Here is a demo
    DateTime(
        Year(datePicker.SelectedDate),
        Month(datePicker.SelectedDate),
        Day(datePicker.SelectedDate),
        hourpicker.Selected.Value,
        minutePicker.Selected.Value,
        0
    )
    Regards,
    Meekou
    Personal Support

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,081

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,795

Leaderboard