web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Patching empty date an...

Power Apps

Answered

Patching empty date and time pircker value

(0) Share

Report

Report

Posted on by ekoz21

66

Hi All,

In my form, I have a date and time picker (from a SP list) and I am trying to patch it.

This datacard is optional and my goal is to patch it only when the user selects date and time.

I am using the following formula to patch it:
IncidentTimeFrom:
If(
!IsBlank(DateValue(IncidentTimeFrom_DataCard3_1.DataField)),
DateValue5_1.SelectedDate +
Time(
Value(HourValue5_1.Selected.Value),
Value(MinuteValue5_1.Selected.Value),
0
)
)

If there is no date selected, this field is not patched, however, if the user selects the date, it is not patched either.
Any suggestions on what changes need to be made?

Your help is much appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@ekoz21

You are specifying the wrong property of your datacard. DataField will be the name of the field, not a value thus it will always produce blank when trying to convert the text field name to a datevalue.

Please consider changing your Formula to the following:

If( !IsBlank(DateValue5_1.SelectedDate), DateValue5_1.SelectedDate + Time(Value(HourValue5_1.Selected.Value), Value(MinuteValue5_1.Selected.Value), 0) )

However, the datepicker SHOULD be getting its Default date from the underlying field, so there would not really be a way to set it to blank from the user perspective. This could be your next issue.

I hope this is helpful for you.

Was this reply helpful? Yes No
ekoz21 66 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you! It works perfectly now 🙂

Was this reply helpful? Yes No

Join the conversation