Power apps security within the App

(0) Share

Report

Posted on by rodzmaz81

202

Hi All

Iam kindly requesting for assistance of how I can restrict users from accessing Specific Data within a Power app.

I have an application used to capture different incidents and each have a form :

a) injury on duty Incidents -Form 1

b) health & safety Incidents -Form 2

c) criminal Incidents -Form -3

d ) vehicle Incidents -Form-4

We have different branches Like Pretoria ,Polokwane and Waterfall branches etc. .
We have a Risk officer for each of these branches and is responsible for logging any incident that occurs on site and on specific forms .

The risk officer from Pretoria Branch must be able to only create ,view ,edit Pretoria Branch incidents only .Also the Risk officer can only capture on 3 forms a,b,c and not the vehicle incidents form (d .

The admin user can see all incidents from all branches ,capture incidents for all branches ,see all forms -create ,edit view and even delete

From my side I have SQL tables that I have created to try and achieve this then link them per user

1. I have a user table

2.I have a roles table

3.I have the branches table

4.I have the form types table

To share the app I have created a group callled AppCapture, Iam then adding users to the group then that user has access to the app

My question/ challenge is in Power apps when a user logs into the app it functions in a way that user Robin Mars from Pretoria bakery can only work on incidents for Pretoria Branch incident , create ,view and Edit on form AB and not DC and belongs to the Risk officer role.

Any ideas are welcome I have tried a few things but Iam not winning?

Different forms.PNG Different sites or branches.PNG Sites available with the app.PNG Model Concept.PNG

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

I would getxhvthe current logged in user as the first step with something like this:
Set(currUser, LookUp(Users, Email = User().Email))

I would do that in the OnStart property of the app.

I would then fetch the branch and role of that user and store them in global variables. Then use these variables to control data that populates dropdowns or other controls.

Let me know if this approach makes sense.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Was this reply helpful? Yes No
rodzmaz81 202 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi

I have tried and number of things and it has not been working so Iam thinking let me go through this whole process and give you a break down of what I have tried ;

Perhaps if you can give me guidance on the Point below its will be a great start but let me dev on my side as well and keep you posted on what I have done ;

I would then fetch the branch and role of that user and store them in global variables. Then use these variables to control data that populates dropdowns or other controls

Was this reply helpful? Yes No