Hello, I am quite new to powerapp development and I am trying to create an app which needs to show show a list of vehicles in a queue amongst other things. Everything is working as it should but I woul dlike to be able to show the end user the queue position of a vehicle they select. Each vehicle is identified by its regisration and its queue position is determined by the date of its last job (Sharepoint list column name 'LastRota').
What I would like to do is for the user to pick a vehicle registrations from a dropdown list and then the result would show its 'queue' position in my sharepoint list (e.g. 1st, 2nd, etc). Is this possible ?
Thanks in advance
It's definately possible. You need to use Lookup function where collection will be your Vehicles list and expression will be Vehicle.Registration = YourDropDownPicker.Selected.Registration
Thanks for getting back to me. I am ok with populating the drop down box with the vehicle registrations but what I want o happen is that when someone selects a vehicle reg either a label or a textbox will show what position in the queue that vehicle is e.g. AB123 XYX is 2nd