Make Date Field Blank If Dropdown set to specific value

(0) Share

Report

Posted on by Dave-ITMan

Hi Experts,

I have a Status dropdown list named Dropdown-Status and a date field named Date-Closed

I have options in the status dropdown list called "Please select an option","Open","Closed"

The date field is not visible unless the status is set to Closed

When the dropdown is set to Open, I want the date field to be blank when it pulls through to my Sharepoint list, currently it's pulling through the date the powerapp is run.

Can you help please?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Does it has a default date? That might be the problem.

Was this reply helpful? Yes No
Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (1)

Report

You can make changes in Default property of your date picker -
DefaultDate property => If(DropDownDataCardValue.Selected.Value = "Open", Blank(), Parent.Default)

Was this reply helpful? Yes No
AJ_vizMan on at

Like (0)

Report

Another way of achieving the solution is
In 'Required' property of Date control use - If(StatusDataCardvalue.Selected.Result = "Closed",true,false) // Use StatusDataCardvalue as available in your app

Now, on 'Update' Property of Date control use - If(StatusDataCardvalue.Selected.Result = "In Progress",Blank(),DataCardValue.SelectedDate) // DataCardValue is Datacard Name in Date control

Was this reply helpful? Yes No