How to make a field populate a item based on a drop down selection.

[GordoPwrApp]

Hello,

I have a basic power app that I’m trying to create in the form of a simple vehicle log book system. It is structured as follows-

2x SP lists

-LogBookTest (contains multiple columns where the app writes the data to)

-Vehicles (contains two columns, Rego and Make – (LogBookTest looks up from here to get the vehicles as it changes regularly)

My issue is made up of two questions-

1. When in the ‘New Entry’ screen, I have a drop down list to select what vehicle the user is currently driving
   In the Vehicle list under the ‘make’ column, I have the description of the vehicle. My question is, when the user selects a certain vehicle from the drop down, how can I make another field show what type of vehicle that is?

Refer Screenshot 1

2. Again, in my ‘New Entry’ screen in pwr apps, I have a field for the ‘Start Odometer’
Is it possible/how can I make this field auto fill with the last odometer entry relevant to that vehicle from the LogBookTest list, so the user does not have to fill it in each time?
Is this some kind of lookup function to my LogBookTest list and how to point it to the last entry and not just another previous entry of that vehicle?

Appreciate any help or advice

Thanks

   

[WarrenBelz]

Hi @GordoPwrApp ,

For the first one, (xxxx is the valid output of your combo box)

LookUp(
   Vehicles,
   Rego = YourDropDown.Selected.xxxx
).Make

Second one assuming you want the Start Odometer of the last entry for the vehicle

Lookup(
   Sort(
      LogBookTest,
      ID,
      Descending
   ),
   RegNoField = YourDropDown.Selected.xxxx
).'Start Odometer'

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[GordoPwrApp]

Hi @WarrenBelz ,

Thanks for your reply.

Your first solution worked in the following format - 

LookUp(
Vehicles,
Title = DataCardValue18.Selected.Value
).Make

'Title' being the rego column. of my list.

The second solution I have not managed to get working. I think I have some confusion over what the 'RegNoField' is - what do you mean by this?

Is the 'xxxx is the valid output of your combo box' always going to be '.Value'?

Also, I want the 'End Odometer' from the list to populate the 'Start Odometer'

See screen shot with highlighted areas.

 

Thanks again for you help.

[WarrenBelz]

Hi @GordoPwrApp ,

It is whatever field you are trying to match the vehicle in the list with the one you are selecting in the drop-down.

 I have simply sorted the list in reverse order, so the Lookup picks up the first (actually the last/newest) matching record and then displays the 'End Odometer' field. The output of drop-downs is not always .Value. If you look at the end of the blog section of mine you will see examples.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[GordoPwrApp]

Thanks @WarrenBelz ,

I understand that I am trying to match the 'End Odometer' from the vehicle that is selected, but then how do I put that in the 'Start Odometer' box?

The way I read it is,

1. I am telling it to look up the LogBookTest list,

2. The ID of each item and in descending order.

3. It looks at the 'End Odometer' column which should then be put into my 'Start Odometer' field based on the vehicle I look up from DataCardValue18

 

I think I'm typing my formula wrong still-

Lookup(Sort(LogBookTest,ID,Descending),EndOdometer=DataCardValue18.Selected.Value).'End Odometer'

[WarrenBelz · Accepted solution]

@GordoPwrApp ,

As I noted - you need to match the Vehicle (this could be Title as you noted) as this is what is displayed in the drop-down

LookUp(
   Sort(
      LogBookTest,
      ID,
      Descending
   ),
   Vehicle = DataCardValue18.Selected.Value
).'End Odometer'

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[GordoPwrApp]

Thanks @WarrenBelz .

I have it all working now - was just missing the .Value after vehicle-

LookUp(
Sort(
VehicleLogBook,
ID,
Descending
),
Vehicle.Value = DataCardValue47.Selected.Value
).'End Odometer'

Thanks for your help.

[WarrenBelz]

@GordoPwrApp ,

Yes - if Vehicle is a Choice or Lookup field (you did not mention this), you need .Value