Unanswered

Set date field in custom form when Choice is changed

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I am trying to populate Date column based on the "Status" choice column.

Condition is If Status = Complete or Cancelled populated date = Now(), Whenever the status is changed either from Complete or Cancelled it should set the date column to blank.

So far, the logic works on my editable form. whenever it toggle for complete or cancelled the date populates and Status <> Closed or Complete it blanks the Closed date.

But when I submit() the ticket and view in the gallery its doesn't reflect.

I have the following code on the default date field for "Closed Date" Card.

If(DataCardValue46_2.Selected.Value="Cancelled",Now(),If(DataCardValue46_2.Selected.Value="Complete",Now(),If(DataCardValue46_2.Selected.Value<>"Complete",Blank(),If(DataCardValue46_2.Selected.Value<>"Cancelled",Blank()))))

Thanks for any help!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

Could you please tell me what does not reflect? I saw that the Closed Date is blank when the Status is Completed.

What's more, if you want to populate the closed date with today when status dropdown is Cancelled or Completed, please try the following formula:

If(DataCardValue46_2.Selected.Value="Cancelled"||DataCardValue46_2.Selected.Value="Complete",Now(),DataCardValue46_2.Selected.Value<>"Complete"||DataCardValue46_2.Selected.Value<>"Cancelled",Blank())

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Qi,

So the code work in the form, but when submit it the changes doesn't reflect on the source which is SharePoint list.
Code publish the closed date(Date column) based on the selected status. But It doesn't delete the value on closed date(Date column).

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous,

Could you please try to enable the Formula-level Error Management in Power Apps setting?

Was this reply helpful? Yes No