I have a parent list 'Traveller Profiles' (Name as text, Active as Yes/No).
Name field used in a child list 'Travel Requests' as a lookup field TravellerName.
Is it possible to somehow filter the TravellerName field and let users choose only Traveller profiles in Yes Active statuses?
I am pretty sure there should be some workaround with the following formula:
Could you please share a bit more about your PowerApps app's configuration?
Do you want to achieve your needs using the Choices() function within your PowerApps app?
If you want to achieve your needs using the Choices() function that you mentioned, I afraid that there is no way to achieve your needs.
In addition, if the Active column is a Yes/No type column in your 'Traveller Profiles' list, I think there is still no way to achieve your needs in PowerApps. There is something issue with the Yes/No type column of SharePoint list within PowerApps app, please check the following thread:
The PowerApp is actually a customised form for the 'Travel Requests' SharePoint list.
The list has a lookup field that gets its values from the Profiles list.
I am using 'Edit' form control for editing travel request data.
WIthin the form, I have a combo box control that has the following data config.
Thank you for informing about filtering boolean values, I can just set the Active field as string type.