Dynamic RLS based on multiple conditions in multiple tables

[Optimusprime_25]

Hi Team,

We have a requirement where we have to dynamically restrict the data based on user's unit and country.

Please find below tables which we have

User Details Table

ID	COUNTRY	UNIT	REGION	User_ID
1	Algeria	ABC	NA	[email protected]
2	Argentina	ABC	NA	[email protected]
3	Australia	ABC	NA	[email protected]
4	Denmark	XYZ	APAC	[email protected]
5	Hungary	XYZ	APAC	[email protected]
6	South Korea	XYZ	NA	[email protected]

Country Table 

COUNTRY

Algeria

Argentina

Australia

Denmark

Hungary

South Korea

Unit Table

UNIT

ABC

XYZ

Main Table

UNIT	COUNTRY	REGION	COL1	COL2	COL3	COL4	COL5
ABC	Algeria	NA
ABC	Argentina	NA
ABC	Australia	NA
XYZ	Denmark	APAC
XYZ	Hungary	APAC
XYZ	South Korea	NA

With the help of Dynamic RLS we have to restrict the Main table by making use of USERPRINCIPALNAME and also we have to restrict user's country and unit as well in the report.

Thanks in advance.

[Optimusprime_25]

Hello @v-yinliw-msft ,

When EMP1 access the report then he should be able to see the data from the country and the unit in which he has access.

In above countries we can have data of Unit XYZ but EMP1 should be able to see the data of Unit ABC only from the Algeria, Argentina, Australia countries.

Similarly when EMP2 access the report then he should be able to see the data from the country and the unit in which he has access.

In above countries we can have data of Unit ABC but EMP2 should be able to see the data of Unit XYZ only from the Denmark,Hungary,South Korea countries.

I hope now you will undertand the outcome of this requirement

Thanks.

[v-yinliw-msft]

Hi @Optimusprime_25 ,

Could you please show me what your desired result looks like?

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Optimusprime_25]

 Hello @v-yinliw-msft 

EMP1 should be able to see the data in which country and unit he has access

Similarly EMP2 should be able to see the data in which country and unit he has access.

All countries contains both ABC and XYZ unit data, but access should be restricted on country and unit as well.

Thanks

[Optimusprime_25]

Hello @v-yinliw-msft 

I am unable to send the response due to invalid HTML