Hide Date in Date Picker if Record Has No Value

(1) Share

Report

Posted on by JC-10090226-0

I have a modern date picker in a view form linked to members.orientationDate in a dataverse table. When a record in the members table has a date value for orienationDate, the value is displayed correctly without issue; however, when the record in the members table has no value for orientationDate, a random (seems to be the most orientationDate value from the most recently updated record) is displayed.

The original selectedDate value was Parent.Default, however, I've now changed it to If(IsBlank(ThisItem.orientationDate), Date(1971,1,1), Parent.Default). This still doesn't do what I want as a date is still displayed instead of nothing, but at least I can control which date is displayed.

Is there any way to either have no date displayed or the place holder text displayed when the date picker display mode is View?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Ravindra Jadhav 342 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hii,

as you mention this error is becase of datatype of your column, In datavers you are using date and time column so you have to use Datevalue Function

If(IsBlank(ThisItem.orientationDate), DateValue(1971,1,1), Parent.Default).

Please Closed the Question, Mark it Solved

If my answer helped resolve your issue, please consider marking it as solved to assist others facing the same problem. Additionally, giving it a like would be greatly appreciated and motivates us to keep helping

Thank You

Ravindra Jadhav

Please Subscribe to https://www.youtube.com/@jadhav_ravi_oo7

Connect On https://www.linkedin.com/in/ravindra-jadhav-powerplatform/

Was this reply helpful? Yes No
Suggested answer

Talha_Dar 870 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
To display a placeholder or no date in "View" mode for the Date Picker:

Use a Label Control: Place a label over the date picker with your desired placeholder text.

Conditional Visibility:

Set the label's Visible property to IsBlank(DatePicker.SelectedDate).

Set the date picker's Visible property to !IsBlank(DatePicker.SelectedDate).

This workaround simulates having no date or a placeholder displayed in "View" mode.

If this helped solve your issue, please mark this as the solution so others can easily find it too. And if you found the content useful, feel free to give it a thumbs up!

Was this reply helpful? Yes No
Suggested answer

CA1105 545 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can use IsBlank(ThisItem.orientationDate) to visible property of datepicker, also try to set default date to blank if there is no date.

Was this reply helpful? Yes No