cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

SQL Server In Operator Alternative

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 Smiley Frustrated

1 REPLY 1
Leo09
Level 8

Re: SQL Server In Operator Alternative

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 306 members 3,469 guests
Please welcome our newest community members: