Hello,
I have a fleet of vehicles where I need to track mileage and inspections. I have created a SharePoint List for current information data entry; however, I need a previous mileage field to fill based on the Vehicle ID. I then want to identify the miles driven betwenn those dates for each record. Following is an example...
| Date | Vehicle | CurrentMileage | PastMileage | MileageDiff |
| 8/15 | 100 | 10000 | 9800 | 200 |
| 8/15 | 101 | 12000 | 11900 | 100 |
| 8/16 | 100 | 10200 | 10000 | 200 |
| 8/17 | 100 | 10350 | 10200 | 150 |
| 8/16 | 101 | 12250 | 12000 | 250 |
My original thought was to have (2) Lists. One list is a list of vehicles (VehicleList). The second is the inspection (VehicleInsp). I was then going to create a Flow that identifies the PastMileage from the VehicleList and update a field in the VehicleInsp. Subtract the PastMileage from the CurrentMileage and then update the PastMileage (in the VehicleList) with the CurrentMileage entered for the inspection.
Is that the best method to achieve my results or are there more efficient options?