Answered

date time now in a date and time field and then reset field to blank

(3) Share

Report

Posted on by Dave-ITMan

Hi Experts,

Hopefully an easy one for you. I have an app where I want to click a button and it enters the date and time now into a date and time field within a form. Once the form has successfully uploaded to sharepoint, reset the date and time field within the form back to blank.

Thanks in advance

Dave

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Kalel_Lucas 165 on at

Like (3)

Report
Copy link

Link copied!

Hello Dave-ITMan,

If that Date Picker control has its DefaultDate property set as empty, you can put Reset(DatePicker1) on your Form's OnSuccess property.
This should clear your control to its original blank state.

Hope it helps,

Kalel

Was this reply helpful? Yes No
DAsuzu 4 on at

Like (1)

Report
Copy link

Link copied!

Hi Dave,

You would have to show your setup to get exact details but you might need a variable so that a click of the button sets the variable and then your item property will have an if statement that uses Today() as the value to submit then do what Kalel suggested with the reset. My best guess based on assumptions that may be wrong until you share more details like a screenshot.

Cheers,

Dan.

Was this reply helpful? Yes No
Dave-ITMan 24 on at

Like (1)

Report
Copy link

Link copied!

Hi both,

Thank you for the replies, i've tried that but doesn't seem to work. please see the screenshot below which will hopefully explain it a bit better than I did originally. I just need to reset the Sign In or Sign Out date and time (depending on which button was pressed) when the form has successfully been uploaded to sharepoint.

Thanks in advance

Dave

Was this reply helpful? Yes No
Verified answer

Kalel_Lucas 165 on at

Like (2)

Report
Copy link

Link copied!
Hello Dave,

Right, I had forgotten that your controls were inside a DataCard; Reset won't work on them.

Since you're using variables to set the Default property of the DataCard, you can instead try the following code on the OnSuccess property of the form:
Set(currentTimeSignIn, Blank()), Set(currentTimeSignOut, Blank()), ResetForm(Form1_1)

Please, try that and tell me if it works as intended.

Kind regards,

Kalel

Was this reply helpful? Yes No
Dave-ITMan 24 on at

Like (2)

Report
Copy link

Link copied!

Hi @Kalel,

Works perfectly, thank you so much for your help - much appreciated.

Regards

Dave

Was this reply helpful? Yes No