SQL Server In Operator Alternative

[Delid4ve]

I have 2 Tables:

Equipment_Site: ID,Make,Model,Serial (anything upto 200 records already filtered to a collection from original Equipment Table)

ClassificationLink: ID,ClassificationID,ForeignID,UserValueText (over 8000 records)

Classificationlink.ForeignID is the join to Equipment_Site.ID

Now As the In Operator is not Delegable (Yes I Know it says it is but its not), i need to find a way to link these tables.

This is what it should be:

LookUp('[dbo].[ClassificationLink]',ForeignID in Equipment_Site_Test.ID And ClassificationID=148,UserValueText)

However this does not work when used in AddColumns to Equipment_Site Collection or anywhere else.

What I can do is put a gallery in, add a text box and set its formula to:

LookUp('[dbo].[ClassificationLink]',ForeignID=ThisItem.ID And ClassificationID=148,UserValueText)

.....but how can i then add this to the collection.  Ive tried Patch and forall but cant get it to work.

Any help or another suggestion greatly appreciated, its the 1 stumbling block for my whole app 

[Leo09]

See if  this thread helps:

https://powerusers.microsoft.com/t5/PowerApps-Forum/How-to-patch-a-SharePoint-Lookup-Column/td-p/240...