Form Permissions

(0) Share

Report

Posted on by gjbannister01

185

I asked this yesterday but I need and answer ASAP lol

I have a PowerApps form that I want to be visible to everyone, however, I only want a select few to be able to edit.

I have created a separate SP list as well for permissions, but I'm not sure what the formula is to get it to work.

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (0)

Sort by

mmollet 3,187 on at

Like
a
(1)

Report
Copy link

Link copied!

Here is an example I use to only allow admins to click the admin home button on my app:
If(currUser.Role = "Admin", DisplayMode.Edit, DisplayMode.Disabled)
currUser is a var that was saved from a LookUp based on the current user that is logged into the app.

You would use View and Edit mode for the forms tho. It would be standard to be in view but if the user is an admin then it would be edit mode. Like this but with your check instead of currUser.Role = "Admin"
If(currUser.Role = "Admin", FormMode.Edit, FormMode.View)

Hope this works for you!

Was this reply helpful? Yes No
gjbannister01 185 on at

Like
a
(0)

Report
Copy link

Link copied!

How did you set up the variable? I don't know a single step in this process haha

Was this reply helpful? Yes No
mmollet 3,187 on at

Like
a
(1)

Report
Copy link

Link copied!

Set(currUser, LookUp(EmployeesV3, FullName = User().FullName));

I have a SP List that holds the following fields:

The FullName and Email columns are the same as the User().FullName and User().Email values in PowerApps. This is where I do the lookup to get the employees row. The Role column is what I was using in that example.

Was this reply helpful? Yes No
gjbannister01 185 on at

Like
a
(1)

Report
Copy link

Link copied!

Okay I'm so sorry but this is slightly confusing and is not your response, it's my brain fog haha

App OnStart: Set(variable, Lookup(DataSource, ColumnName=User().Email)
Edit Form Default Mode: If(variable.ColumnName = "?", FormMode.Edit, FormMode.View)

Is this correct?

Was this reply helpful? Yes No
mmollet 3,187 on at

Like
a
(1)

Report
Copy link

Link copied!

Yes I believe so! Let me know if the results are what you were looking for.

Was this reply helpful? Yes No
gjbannister01 185 on at

Like
a
(0)

Report
Copy link

Link copied!

It's not haha. So I can't share my list, but I have list called "Admin" and the columns are "user", "name" (they display the name and then the email), I have two columns to pull all the info from the gal.

I have this on my OnStart: Set(varAdmin, LookUp(Admin(DataSource), "User"(column name) = User().Email))
I am not getting any errors for this formula.

DefaultMode: If(varAdmin.User = "Admin", FormMode.Edit, FormMode.View)
^This is the formula that is giving me an error.

Was this reply helpful? Yes No
mmollet 3,187 on at

Like
a
(1)

Report
Copy link

Link copied!

Ok so your data is set up a little differently that mine. I have a List of employees with thier roles as a column and you have an admin List with emails and full names as columns.

It seems to me that if the user is not an admin they would not be in that list and therefor that formula would set varAdmin to Blank() when it returned nothing. We can test for this in your DefaultMode forumla like so:
If(IsBlank(VarAdmin), FormMode.View, FormMode.Edit)
This says if the varAdmin variable is blank then we want to view the form as the user is not an admin. If the variable is not blank then we found an entry for them in the admin list and we should set the mode to edit.

Hopefully we get this soon I know you wanted a solution fast! 😛

Was this reply helpful? Yes No
Breckb 8 on at

Like
a
(1)

Report
Copy link

Link copied!

Random throw at this. Maybe make the "Edit" button only visible to the users who you want to edit it. If you have a edit button. I have a admin button on my home page that only gives "admin" access to specific screens. Here is the youtube vid that helped me.

/*https://www.youtube.com/watch?v=n2bP2ZknetU*/

Was this reply helpful? Yes No
gjbannister01 185 on at

Like
a
(0)

Report
Copy link

Link copied!

I need to users to still be able to view the form so they can see the fields filled out, but the admin need to be the ones to make edits and changes.

Was this reply helpful? Yes No
gjbannister01 185 on at

Like
a
(0)

Report
Copy link

Link copied!

ah here was the comment on a second page so *delete*

Was this reply helpful? Yes No