A single lookup type column can refer to multiple other tables
The Choices function when called for a lookup column returns a table with two columns, named "Id" and "Value" - which contain the id and the referenced column
Select Add relationship, and then select a relationship type, such as Many-to-one
Here, the Items property of the ComboBox control is set to: Choices('Employee Details'
I would replace the "bcs_projectid" with "Id"
Jul 15, 2021 · A polymorphic relationship lookup allows you to specify more than one type of Dataverse table to relate to
Jul 19, 2019 · If it is a multiple look up column, try this: Filter (Customer Locations,CustomerDDL