web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Inserting last record ...

Power Apps

Answered

Inserting last record for selected value from a dropdown menu

(0) Share

Report

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 Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Ash13 576 on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation