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:

Using Apps Using Formulas

General Questions

All responses (3)

Answers (1)

AJ_vizMan on at

Like (0)

Report

Re: Make Date Field Blank If Dropdown set to specific value

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
Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (1)

Report

Re: Make Date Field Blank If Dropdown set to specific value

You can make changes in Default property of your date picker -
DefaultDate property => If(DropDownDataCardValue.Selected.Value = "Open", Blank(), Parent.Default)
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Re: Make Date Field Blank If Dropdown set to specific value

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