calculation for returning the most recent value

[EiC4733]

Hello, I have a list which co-signs in a column the date of the visit (DATE V1, DATE, V2 DATE Vn and the result of the investigation (GOOD, BAD) in a column RESULT VA, RESULT V2, RESULT VN.

I would like to obtain a column (LAST RESULT) which automatically returns the value of the last result via a calculation.

I'm thinking of a few things like if the date closest to today is DATEV2 then RESULT V2 but I'm having trouble with date calculations

Could you help me ?

[#2]

@EiC4733 Will the date columns be competed in order - Visit1, Visit2, Visit3 then finally Visit4- or will it be fairly random? I assume it will be in order.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

[#3]

@Rob_Elliott 

They are random.
I archive 4 visits. and the 5th comes to crush the 1st.

[#4]

@EiC4733 if they are added in a random order then I don't know of any way to get he most recently added value.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)