Filtered item not saving to Sharepoint list

[Timm1]

Hi there. Hope I can explain this correctly.  I'm building a Powerapps form from a sharepoint list.  I'm using O365 User's connector. Form is called City Vehicle Repair.  I have when a Requestor,(Person/group type) is selected, it autofills the Department field.  I have another list Named PW Vehicle List with Vehicle Number and Department. I have the Vehicle Number drop down only show what vehicles that belong to that department.  The drop down works but when I create a new form, everything saved to the list except for the Vehicle Number.  I can select a vehicle but that information is not saved to the list. 

Code is listed below. 

DDRequestor- Choices([@'City Vehicle Repair'].Requestor)

Department    DDRequestor.Selected.Department

Vehicle Number   Filter('PW Vehicle List', Department = DDRequestor.Selected.Department)

   I had to edit the Fields to have the Primary Text to Vehicle Number from the PW Vehicle List. 

I tried Distinct and Selected.Value options but can't them them to work.  

Thank you for your time. 

[WarrenBelz · Accepted solution]

Hi@Timm1 , 

This code

 Filter('PW Vehicle List', Department = DDRequestor.Selected.Department)

will produce a table of all matching fields - I assume

• You are using 'Vehicle Number' (and this is the actual field name in the selected item.
• The field you are writing back to is a single line of text

If so, the Update of the card the drop-down is contained in should be

YourVehicleDDName.Seleted.'Vehicle Number'

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.

[Timm1]

Thanks for your help

[Timm1]

Thanks for your help

[Timm1]

Thank you WarrenBelz.  After reading your comments, I did create a new column in the list, added that column to the form, and had the Default Value set to VehicleDDName.selected.'Vehicle Number'.   Seems to be working exactly how I wanted.  Thank you for helping me out.