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

All responses (8)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

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

Like
a
(0)

Report
Copy link

Link copied!

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
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jamesbbrown ,

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

Is this now solved?
jamesbbrown 31 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!
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?
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@ZafarIqbal ,

You need the true/false columns in your PowerApps_AccessControl list
ZafarIqbal 7 on at

Like
a
(0)

Report
Copy link

Link copied!

as mentioned to jamesbbrown abow i have the yes/no(radio button) colums in list?
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@ZafarIqbal ,

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