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

All responses (3)

Answers (1)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

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