Answered

Clear Closed Date if Open Status

(0) Share

Report

Posted on by kbashaw

233

I have a combobox DataCardValue1 that has an Open or Closed Value. If the value is Open it hides DataCardValue2 which is a Date Picker.

If they switch the record back to open I need to remove/reset the date entered in DataCardValue2. Is there a way to do this?

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

Sort by

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @kbashaw,

The following code in the DefaultDate property of DataCardValue2 should do the trick:

If( DataCardValue1.Selected.Value = "Closed", Parent.Default )

It will patch a blank value and overwrite any previously saved date value once they submit the form with status = "Open". (Given that the Update property of DataCard2 is still the default DataCardValue2.SelectedDate)

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
kbashaw 233 on at

Like
a
(0)

Report
Copy link

Link copied!

The Update property of DataCard2 is still the default DataCardValue2.SelectedDate
I tried it but it still doesn't clear the previous date.

Was this reply helpful? Yes No
kbashaw 233 on at

Like
a
(0)

Report
Copy link

Link copied!

It looks like it's removing it from the datacard but not in Sharepoint. When I tried:
If(
DataCardValue1.Selected.Value = "Open",
Parent.Default
)

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @kbashaw,

In the If statement, DataCardValue1.Selected.Value should be equal to "Closed" (see initial code). If you want to use 'is equal to Open' try:

If( DataCardValue1.Selected.Value = "Open", //If open, reset to blank Blank(), //Else display the saved value Parent.Default )

Was this reply helpful? Yes No
kbashaw 233 on at

Like
a
(0)

Report
Copy link

Link copied!

I've tried both ways and it still doesn't clear the date. I am able to change between Open, Close change the dates and the patching works. The data field just won't clear.

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@kbashaw ok I may have found the issue:

In addition to my previous code in the Default property, could you add the following code to the OnChange of DataCardValue1:

Reset(DataCardValue2)

Was this reply helpful? Yes No
kbashaw 233 on at

Like
a
(0)

Report
Copy link

Link copied!

I added the OnChange code and tried it with both of the variations above. It still won't clear the date. I also tried a few other records.

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@kbashaw,

I unfortunately am unable to recreate the issue. I tested via the following steps:

Save a record with a date

Adjust the record status to 'Open'

Step 2 clears the DataCardValue2's date

I save the data by using the SubmitForm function

The date in my SharePoint list for that record is cleared

Was this reply helpful? Yes No
kbashaw 233 on at

Like
a
(0)

Report
Copy link

Link copied!

I can't use a SubmitForm function, I need to patch this data. Although I do have a SubmitForm button just to test what will update and the date didn't update with that one either.

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@kbashaw,

Thank you for the additional information!

Is Formula-error level management turned on in your app settings? In recent apps this will probably be on by default. Should this be off, that could explain the issue we are facing.

Was this reply helpful? Yes No