without changing status ,date is updating to latest

[justlearner1]

in Status column : on change properties i added below code

Set(
varDate,
Today()
)

in Status Date Column : on Default date - i added as 'VarDate'.

with out updating status column ,automatically it showing today date, i want to show today only when user change the status or else it will show only old status date.

how can i fix it?

[StalinPonnusamy · Accepted solution]

Hi @justlearner1 

Looks it uses a previously selected value and better to use UpdateContext (Local)  instead of Set (Global)

Set the Onvisible property of the screen to

UpdateContext({varDate:Blank()})

Set OnChange property of Status control to

UpdateContext({varDate:Today()})

Set DefaultDate of Date Control to

varDate

Thanks,
Stalin - Learn To Illuminate  

[justlearner1]

Hi Stalin

this formula is not working properly..

yesterday i changed dropdown Status to "In progress" and it updated automatically yesterday date.

but when i open the app today ,it showing default date given in SP column (2001) ..

next time ,when i open the app, it should show last time change date only. and if i change dropdown selected value then only date should change.

any modification i need to do in formula?

[StalinPonnusamy]

Hi @justlearner1 

Will troubleshoot the issue.

• Is the date is changing on the UI when you change the status?
• Make sure your update the property of the control to Date control.Selected
• Are we using Submit form or Patch function?

[justlearner1]

• Is the date is changing on the UI when you change the status?- yes
• Make sure your update the property of the control to Date control.Selected- where i need to change?
• Are we using Submit form or Patch function?- Submit Form

[StalinPonnusamy]

Make sure to set the Update property to

JustDateDataCardValue.SelectedDate

so that system knows what data to be saved On submitting the form.

[justlearner1]

it is added already,but no change

[StalinPonnusamy]

So the data was saved to Sharepoint property but in UI/PowerApps it's not showing based on our condition. Is it correct?

[justlearner1]

it is showing but ,all other columns  data pickers also getting update with today day without changing the status of other columns

i added all 4 status coloumn with below code like

Status coloumns                                                        Date Picker

UpdateContext({varDate1:Today()})                        varDate1

UpdateContext({varDate2:Today()})                         varDate2

UpdateContext({varDate3:Today()})                          varDate3

UpdateContext({varDate4:Today()})                          varDate4

[StalinPonnusamy]

Hi @justlearner1 

We will do 2 things to prevent to make sure.

1. Set the DefaultDate property to

If(!IsBlank(varDate),varDate,Parent.Default)

2. Set the OnSuccess property of EditForm to

UpdateContext({varDate:Blank()})

I assume you are using SubmitForm. So that It will not use it without changing the value.