To capture the date based on change of field to a particular value

[cyberco01]

Hi Team,

I have a Combobox field in the Powerapps form. It can hold 2 values - Approved or Rejected.

I need to capture the date when the value on it changes to Rejected as well as the date when it changes to Approved.

Please Help!!

Thanks,

[rampprakash]

Hello @cyberco01,

You can try the below

If the drop down is null set it to blank else set it to current date

If(!IsBlank(Dropdown1.SelectedText.Value),Today(),Blank())

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

[cyberco01]

I need to capture the exact date when it is rejected especially, is there any way for it?

[rampprakash]

hello @cyberco01,

you mean want to capture date and time?

[cyberco01]

@rampprakash Yes

[rampprakash]

Hello @cyberco01,

You can try this , for testing i have added label

Text( Now(), "mm/dd/yyyy hh:mm:ss" )

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

[cyberco01]

Just wanted to know - how I can know if this same value changed to "approved" later.

[rampprakash]

Hello @cyberco01,

You can check

If(!IsBlank(Dropdown1.SelectedText.Value),Text( Now(), "mm/dd/yyyy hh:mm:ss" ),Blank())

Above code will work if there is only one field for Approved and Rejected

if you have multiple filed

For Approved:

If(Dropdown1.SelectedText.Value="Approved",Text( Now(), "mm/dd/yyyy hh:mm:ss" ),Blank())

For Rejected:

If(Dropdown1.SelectedText.Value="Rejected",Text( Now(), "mm/dd/yyyy hh:mm:ss" ),Blank())

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

[cyberco01]

@rampprakash , I will surely try this today and update you on this.

[cyberco01]

@rampprakash, i tried it. I created different columns for each status. When i change the value, the dates are getting replaced with todays date. Please help.