Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Need help Please

Posted on by 18
Hi Community
 
I am still struggling with a date to be inserted in a database.  How can I refresh the below before I submit the form.?
 
Issue:
 
Time now is 9:32 am.  If I update the record, Date/Time is properly inserted in the Sql server.
 
But in a given scenario, where I leave the application open and come back in 1 hr, when it is now 10:32 am, the variables are still 9:32 on the screen ( normal) and the record is being updated with that time which is wrong.
  
I want a refresh of the Date/Time fields below when I press on the Update Button, just before the SubmitForm( Form1) is executed. Please assist me with the codes to be inserted prior. Thanks.
 
 
 
  
 
 
 
 

 
Categories:
  • WarrenBelz Profile Picture
    WarrenBelz 143,487 on at
    Need help Please
    Three posts in five minutes is only going to take this off the "no responses" list and less people will look at it. Try sending Now() in your Patch to your data source - it will send the current time. Otherwise reset the hour and minute drop-downs before you save.
     
    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    MVP (Business Applications)     Visit my blog Practical Power Apps    Buy me a coffee

     
  • JC-04111302-0 Profile Picture
    JC-04111302-0 18 on at
    Need help Please
  • JC-04111302-0 Profile Picture
    JC-04111302-0 18 on at
    Need help Please
    Hi Community

    I am still struggling with a date to be inserted in a database.  How can I refresh the below before I submit the form.?

     

    Issue:

    Time now is 9:32 am.  If I update the record, Date/Time is properly inserted in the Sql server.

    But in a given scenario, where I leave the application open and come back in 1 hr, when it is now 10:32 am, the variables are still 9:32 on the screen ( normal) and the record is being updated with that time which is wrong.

     

    I want a refresh of the Date/Time fields  below when I press on the Update Button, just before the SubmitForm( Form1) is executed. Please assist me with the codes to be inserted prior. Thanks.

     

      


     


     

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,487

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,014

Leaderboard