If I submit this form, data sent to database for "Stairs on" and "GPU on" will be current date + "00:00". I'd like it to be empty.
Please note that the day selection input is hidden.
Thank you for your answer.
Could you please specify what you mean by "formula" and which one specifically ?
Please note that the properties of the Edit Form were not modified - they're the basic ones.
DateValue95.SelectedDate + Time(Value(HourValue95.Selected.Value), Value(MinuteValue95.Selected.Value), 0)
It's the same formula for both but with different datacards
Since the Datefield is hidden, make a conditions at the dafaultdate of the datefield.
1. Ex: If(Isblank(Datacardvalue2)," ",DateValue95.SelectedDate + Time(Value(HourValue95.Selected.Value), Value(MinuteValue95.Selected.Value), 0)
Expalnation: if the user does not input in Datacardvalue2, then the datefield would be blank, else the date selected
2. For the +"00:00", it could be a format in the excel column at your datasource.
Please let me know if any of them is solved
Date/Time values can't be null (empty). They have to contain a valid date or time. 00:00 on some date is the best you will be able to get.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.