Power Platform Community Forum Thread Details

I'm creating an app for a charity fundraiser where users need to log the mileage they've travelled. I've created 2 sharepoint lists, the 1st to log the mileage, with a linked column to the 2nd list where people can register a team name to associate with each company employee.

I would like to have a way to search through the 2nd list while logging mileage in list 1, with it displaying the [Employee] field and the [Team Name], then using the selection, have the team name enter in the new form field for list 1.

Categories:

Building Power Apps

Hi @ogopogoelmo

To achieve t you can use a ComboBox to search through your second list and then use the selected team name when logging mileage in the first list.

Add a ComboBox to your mileage logging form:
Add a ComboBox control to the form.

Set the Items property to filter your second list (List2) based on the search text. Use this formula: Filter(List2, StartsWith(Employee, ComboBox1.SearchText) || StartsWith(TeamName, ComboBox1.SearchText))

Set the SearchFields property to ["Employee", "TeamName"] and the ShowFields property to ["Employee", "TeamName"].

Populate the Team Name field:
Add a Text Input control for the Team Name in the form.

Set the Default property of this Text Input to ComboBox1.Selected.TeamName.

With this setup, users can search for an employee and team name from the second list using the ComboBox. When they select a team, the Team Name field in the mileage logging form will automatically be filled with the selected team name.

I hope i have got what you are trying to achieve if not please provide some additional information like screenshots of your current components to find out exactly what you are trying to acheive.