Unanswered

Row level Security

(0) Share

Report

Posted on by PRamashe

Hello,

I have created an App with Data table to view the data and a form to enter values by the users. Data table populates data base done SQL table. But, I want to restrict the users to view the data in the table based on the Email and codes assigned to the email from another SQL table. I tried creating global variable with collection and filtering, but seems to be not working. Any ideas are much appreciated

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hello,

Could you share what and how you've done it, so we can better point the issues and help you fix them?

Also, if you simply want to check if user's email is attached to a certain code in your table, you can use this:

Set( glbVariable, IsBlank( LookUp( source, And(email = User().Email, code = "value") ) ) )

Here, "glbVariable" will be set to "TRUE" if no record were found for the provided email and code.
PRamashe 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Wizey,

Thanks for the response. I think, I missed some part of my question. Users in the RepCodes table, should be restricted to their respective codes, but rest of the users(may be called Super Users) should see all data from the Data Table.
I was trying to filter the SQL table 1, looking up RepCodes based on Email ( from SQL table 2) on the items property or Screen -Visible property of the Data table, but it wasn't working as the Data table already has a filter based on the dropdown values. Now, I created a collection, with adding Email column from the Table 2 to the SQL table 1 and filtering the collection with a Match value of the Email, but not sure if this the right approach.

So, the global variable will just restrict the users to their respective codes. Right? Can the superusers see all data based on this global variable?. Let me know more info needed from my end.
WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
If I got this right:

Table2 has email and code

Table1 has record and code

You want to display only if Table1.code = Table2.code while Table2.email = User.email

If so, I believe you can do it in two steps.

In "OnVisible", "UpdateContext()" a local variable to store all the codes from Table2 attached to "User().Email"

In your gallery's "Items", "Filter()" on the codes using "in" operator.

Filter( source, Or(code in lclVariable, isEmpty(lclVariable)) )

Did I get this right? Can you make it work this way?
PRamashe 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi WiZey,

You got me right. I will apply this filter and update you on this.