Set the Last value of a date picker to another date picker when its value changes

[Anonymous_Hippo]

Hi all,

I'm trying to set a last value of a date picker to another date picker when its value changes. For example 

Whenever the value of A changes I update the last saved value to "Previous value of A"  .

I know that i can easily do this using a variable but since there is already a value in "Previous value of A" field things become confusing to me. This seems so easy but my brain isn't working

Thanks for your help

[v-bofeng-msft]

Hi @Anonymous_Hippo :

Do you want to get something like this:

I've made a test for your reference——

I assume 'Previous value of A''s Default value is 

Today()

'A'

OnChange

Set(
    IfChange,
    true
);
Reset('Previous value of A');
Collect(
    Selectlog,
    Self.SelectedDate
)

'Previous value of A'

DefaultDate

If(
    IfChange,
    First(
        LastN(
            Selectlog,
            2
        )
    ).Value,
    Today()
)

 Best Regards,

Bof

[Anonymous_Hippo · Accepted solution]

Hello @v-bofeng-msft ,

Thank you for sharing such a great idea !  I wanted to point out that in your method it worked only after the 2nd change because the first time i change the value it saves the new value and not the old one. To fix this issue while doing a clear collect i saved the current value of A.

ClearCollect(
    Selectlog,
    {Value: Avalue}
);

In this way we were always comparing the right value.

Thanks ! a great learning point 🙂 have a nice day