cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

[Edit form] Date and time issue

[Context]

  • Edit Form with Date/Time fields
  • Excel database in OneDrive
  • Users are not obliged to enter all data in one shot to submit the form. They can fill-in two fields, submit the form, then fill-in the other fields (or modify the fields that they submitted previously)

[Issue]

  • When users submit their form, the fields they did not fill are saved with Default Date + "00:00" time the database. I do not want that.

[Objective]

  • If a field was not filled, don't save anything in the database. Leave the cell empty.

 

[Example]

 

screen1.png

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.

 

Best regards,

Alex

6 REPLIES 6
Highlighted
Super User III
Super User III

Re: [Edit form] Date and time issue

 

Can you show your current formula

Highlighted
Helper I
Helper I

Re: [Edit form] Date and time issue

Hi,

 

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.

 

Best regards,

Alexandre

Highlighted
Super User III
Super User III

Re: [Edit form] Date and time issue

Both the "Stairs on" and "GPU on".

 

Highlighted
Helper I
Helper I

Re: [Edit form] Date and time issue

DateValue95.SelectedDate + Time(Value(HourValue95.Selected.Value), Value(MinuteValue95.Selected.Value), 0)

 

It's the same formula for both but with different datacards

Highlighted
Super User III
Super User III

Re: [Edit form] Date and time issue

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

Highlighted
Dual Super User III
Dual Super User III

Re: [Edit form] Date and time issue

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.  



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,200)