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.
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.
Check out the on demand sessions that are available now!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Features releasing from October 2020 through March 2021