cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Filtered item not saving to Sharepoint list

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. 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

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.

View solution in original post

4 REPLIES 4
Super User III
Super User III

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.

View solution in original post

Thanks for your help

Thanks for your help

 

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. 

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (34,404)