Data ingestion to Power apps CDS Lookup Datatype using ADF:

We are working on data ingestion from SQL server to power apps using ADF. We are using two separate copy activities, one for string, number, and Date datatypes, and another one for lookup datatype.

I have the below-mentioned restrictions When Mapping Lookup Datatype using copy activity.
The Primary Name column in Child Table can only be copied as a Lookup value in Master Table.
The name of the lookup datatype in the master table should be similar to the primary name column name in the child table.
For mapping the data's values, a column with comparable values needs to be present in both the child and master tables.

is there any other better method available for doing the same without the mentioned restrictions?