Unanswered

Row Level Security on Power Apps issue

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a power app in which users will need to select enter data relating to their accounts and sites.

I want users to only see accounts which only relate to them within a dropdown box when they log in to the app.

The Items property of my dropdown box is Choices([@'Operational Review Commentary_1'].'UKI Accounts')

I have the following formula within the onstart property however this doesn't seem to work as my accounts Sharepoint list is a reference list and the email field is within this list. Is this the right approach if not how would I ensure that my dropdown only shows the accounts related to the user logged in

Set(
varUser,
User()
);
Set(
isUserSPList,
!IsBlank(
LookUp(
'UKI - Accounts List' ,
'Access Email' = varUser.Email
)
)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (0)

Sort by

WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

You can get the user's list with

Filter( 'UKI - Accounts List' , 'Access Email' = User().Email )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz
Unfortunately, I am getting a delegation warning on the 'Access Email' as it's a large dataset. (Sharepoint list)
How would I update this formula to resolve this issue.
Thanks in advance

Was this reply helpful? Yes No
WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous ,

What type of field is 'Access Mail' - it should be Delegable if it is Text.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Its a person or group type field in SharePoint.
This is the message I get

Was this reply helpful? Yes No
WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous ,

Not the best column type to use with large data sets (I do not use them at all), but in this case, the below should work

Filter( 'UKI - Accounts List' , 'Access Email'.Email = User().Email )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Unfortunately, I am still getting the same error with the updated formula. My list is around 1k would this still be an issue?

Was this reply helpful? Yes No
WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

The list size does not matter with a Delegation warning as you might increase it in the future and Power Apps simply flags that it is not Delegable, however, if that is a Person field, it should be Delegable (see my test below with no warning)

Are you using that alone or in conjunction with other Filter/s. Can you please post the exact code you are using in Text and also a screenshot of the error.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Sorry, I believe there may be a bit of confusion. The code I have is within the App OnStart property, therefore I have been updating the Onstart property with the formula suggested. Aim is when a user logs in this list is automatically filtered at the start therefore when an individual uses a dropdown they can only see which accounts belong to them.

Was this reply helpful? Yes No
WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous ,

I am surprised that is the only warning (it is really doing nothing) - you need to make a Collection with that code

ClearCollect( colAccounts, Filter( 'UKI - Accounts List' , 'Access Email'.Email = User().Email ) )

the colAccounts is their list.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz For some reason this is still not working. Am I missing something? The only other message which shows up is the below.
Only other message which shows up

Was this reply helpful? Yes No