Forum Discussion

MokaSatya's avatar
MokaSatya
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Row Based Security On Muliple Values

I am trying to impliment below logic , however getting error: "A Table of multiple values was supplied where a single value is expected"

 Opportunities[Worker_Id] IN {LOOKUPVALUE(ExternalWorkerMapping[Worker_ID],ExternalWorkerMapping[User_Id],LOOKUPVALUE(ExternalUser[User_Id],ExternalUser[EmailID],USERPRINCIPALNAME()))}

 

My Expected OutPut:  Opportunities[Worker_Id] IN {1,2,3,4}

 

In ExternalWorkerMapping table, One to Many, one user may have multiple Worker ID's

 

I canot use Mappings because , like above condition, i have to impliment few more condition with OR condition.

 

Can you please help me in finding out a solution for my requirement