So I have a search function which searches my gallery for records with the "playersStatus", and "TeamName". But I want to add another field however the field I want to add is "playersName" but I had to create a lookup function to find the playersName so how can I add the "playersName" field to my search function?
The lookup function for "playersName" is "LookUp(Players, PlayerId = ThisItem.PlayerId, PlayerName)"