Unanswered

Inserting last record for selected value from a dropdown menu

(0) Share

Report

Posted on by Ajwou

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,

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ash13 576 on at

Like (0)

Report
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

Was this reply helpful? Yes No
Ajwou on at

Like (1)

Report

Brilliant, that resolved it. Thank you very much for your help @Ash13

Was this reply helpful? Yes No