Hello!
I'm in need of some assistance with a date field in my Powerapps form.
Here's what I have:
1) A drop down field in my SharePoint list called 'Request Status' that has 4 choices.
1a) In my Powerapps form, the drop down field card is called 'DataCardValue01'
2) A date field in my SharePoint list called 'Request Status Date' that I need to capture the date that the user has either selected or changed the choices in the 'Request Status' drop down field.
2a) In my Powerapps form, this date field card is called 'DataCardValue02'
Here's what I need it to do:
1) When the user selects a choice from the 'Request Status' drop down, I need the 'Request Status Date' field to show the current date.
2) When the user changes the choice previously selected from the 'Request Status' drop down, I need the 'Request Status Date' field to get updated with the new, current date.
I can't get the following formula to work, and am hoping to get some help writing the correct formula?
What am I doing wrong?
In the DefaultDate of the 'Request Status Date' date field in my form:
If(
ThisItem.'Request Status'.Value<>(DataCardValue01.SelectedItems),
Today(),
Parent.Default
)
- I believe 'ThisItem' is referencing the 'Request Status Date' field?
- DataCardValue01 is the name of the drop down field card in my Powerapps form
Thank you in advance for your help!