Answered

Managing permissions in App via a SharePoint List as the source

(0) Share

Report

Posted on by jamesbbrown

Dear All,

I've been using Power Apps for a while but the more my App grows in our business, the more permission management is becoming an issue.

There are areas in our App which I would like to restrict based on a list of permissions which unit administrators manage and I want to cross-match an SP list and the active user using Office365Users. I've created a SP list to manage these permissions, and I would build out a personnel management section on the App.

I believe I need to do a Lookup and User(), but I'm struggling piecing it all together! #HelpAppreciated

As an example, I have created a simple table below and also provided some attachments above.

Area of App / Screen	Permission required
Home	General Access
Training > Unit Dashboard	General Access
My Training Reports	General Access
Unit Training Records	Training Team Unit Administrator
Global Training Records	Global Administrator
Quarterly Reports	Unit Administrator

Categories:

Building Power Apps

Permission Exampl...

Personnel Managem...

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @jamesbbrown ,

Run this at App OnStart

Set( gblUser, LookUp( 'Personnel Management', 'MODNet Account' = User().FullName ) )

then the following will return either true or false

gblUser.'General Access' gblUser.'Training Team' gblUser.'Global Admin' gblUser.'Unit Administrator'

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
jamesbbrown 31 on at

Like (0)

Report

What a beautiful piece of code you've given me there!
I've been scratching my bald head for many hours trying to get that to work!
Really appreciate it @WarrenBelz

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi @jamesbbrown ,

I would suspect you have more follicles than me . . .

Is this now solved?

Was this reply helpful? Yes No
jamesbbrown 31 on at

Like (0)

Report

@WarrenBelz 90s baby with limited follicles. I was not blessed at all.
Yes, now marked as solved.
Thanks again!

Was this reply helpful? Yes No
ZafarIqbal 7 on at

Like (0)

Report
Hi @WarrenBelz I`v got the part with set gbluser. But struggling with the part where to set true or false.

Set(gblUser;LookUp(PowerApps_AccessControl;epost = User().Email))

not so versed in powerapps
@jamesbbrown I am using Checkbox yes/no in SharePoint Online. Could that be the reasoun?

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

@ZafarIqbal ,

You need the true/false columns in your PowerApps_AccessControl list

Was this reply helpful? Yes No
ZafarIqbal 7 on at

Like (0)

Report

as mentioned to jamesbbrown abow i have the yes/no(radio button) colums in list?

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

@ZafarIqbal ,

This is an old closed post - please create a new thread with more specific details of your issue.

Was this reply helpful? Yes No