Hello,
I have a vehicle check app based on a form linked to a sharepoint list. It stores data about each journey. What I am trying to do is to set the default value of initial mileage to the last recorded value for particular vehicle that is selected in the dropdown menu (also being pulled of the sharepoint lists as "choices"). See screenshot below:
Please could anyone help?
Kind Regards,
Brilliant, that resolved it. Thank you very much for your help @Ash13
Hi @Ajwou
Try something like:
First(Sort(Filter(SharePointList,VehicleColumn.Value=VehicleDropdown.Selected.Value),Created,SortOrder.Descending)).MileageColumn
You may want to also replace Created with your 'On the road to' column