PowerApps Form - Hiding fields from certain Users

[tested1]

Hello

I have a powerapp form. I wanted to hide 1 of the fields from the user or make it non-editable but make it show and editable for the users manager. So the process is:

1) User fills in mandatory fields in form 

2) 1 or 2 fields would be hidden (preferred) or non-editable for the user in the form

3) The user submits the form and the manager can go back and see the hidden fields and add a value to it

I tried to change the field to read only mode, but then the manager cant edit it. 

are there anyways to do this? I had saw some posts about filtering by user roles and permissions which but Im still looking at the best options.

Maybe I could add a filter so if the user belongs to a certain permission group, then hide a field? if not show it

OR the opposite would be better? Make the field hidden and non-editable by default but if then filter it so if the email address is a managers it will show?

Thank you! 

[Anonymous]

you can bind the visible property to a variable or a condition

TODO: select your field, go to advanced properties, search visible and enter your condition

for example:

User().Email = "manager@company.com"

so if the email address is that of the manager the field will be visible

[tested1]

hi @Anonymous 

Could I make the field hidden by default so all users cant see it then  add this condition that if the email address is manager@company.com the field shows and is editable?

Can I add more than one email address ? Or even assign a group/site permission like site owners can see it??

Thank you for reply

EDIT:

Could this solution work?

https://www.chakkaradeep.com/2018/01/26/show-and-hide-controls-in-sharepoint-list-custom-forms-based-on-sharepoint-form-modes-in-powerapps/

So make the field hidden when you click new item, but show when you click edit? 

[Anonymous]

if you want to make the field visible afterwards, you should bind it to a variable and later change this variable

OnStart:
Set(myVariable,false)
VisibleProperty = myVariable

Later:
Set(myVariable,true)

yes you can enter more than one email address, but then you have to change it in your app every time.

User().Email="first@company.com"||User().Email="second@company.com"

but it would be better if you create a userlist where you can assign roles. then you have to search for the email address of the user at startup. then you can bind all fields for example to the variable roleManager and hide them automatically by the role.

[tested1]

Hi @Anonymous 

I tried this other solution from: https://www.chakkaradeep.com/2018/01/26/show-and-hide-controls-in-sharepoint-list-custom-forms-based-on-sharepoint-form-modes-in-powerapps/

I clicked on the data field I want to hide, clicked on visible and added:

If(SharePointForm1.Mode = 1, false, true)

So if the user clicks 'new item' / new form  the field is hidden

But then the manager can click edit on their new item and the field shows up and they can edit it?

Is this a good enough solution, the only downfall is that the user can see the hidden field when they click on their item but that does not matter for us.

BUT the user can also edit this field afterwards I guess? There is a sharepoint setting I believe to only let users create items and not edit them after..

Would you recommend I use this for now or what is the difference with your solution to this? 

PS If I used your solution, I would create a permissions group called e.g Managers, add the people in and then what would I type as the function? 

Thank you

[Anonymous]

if i understand you correctly, you only want to hide the field on the new form. this is how it works.
but without any user roles, anyone who sees the item can edit this field.

my solution is based on a role concept which for simplicity's sake consists of an additional sharepoint list (two columns: user and role), which can be easily queried via another data source in the app

AppStart:
ClearCollect(userRoles,myUserList);
Set(currentUser,User()); (performance! just query once)
Set(role,First(Filter(userRoles,UserOrGroup.Email=currentUser.Email)).Role.Value);
Set(isAdmin,role="Admin");

EDIT:

@tested1if one of my posts was helpful then please accept as solution

[tested1]

Thanks @Anonymous  I will accept it

Sorry Im not the best at understanding PowerApps. Is there any way you could write what to do in some easy steps?

1) Create a new SharePoint list with columns User and Role? 

The people here will have edit/owner level permissions? 

2) Add the binding function..How or where do I add the On start set variables? Is that on the visible section of the Field

3) Add the Appstart function.. Where does this go and link to the sharepoint list I created in 1

Thank you for your help. I appreciate the replies. 

[Anonymous]

@tested1 

the difficult part for respondents is always finding out where to pick up the questioner 

Users should have edit rights in the "main" list. Permissions management is handled by your new list.

Permissions by SharePoint groups is too complicated based on your level of knowledge.

But if you are interested https://svaghub.wordpress.com/2018/11/03/role-based-security-in-powerapps-using-spgroups/

1. Create a list with two columns
   1. Column "User" Type "Person or Group"
   2. Column "Role" Type "Choice" (Choices are Admin, Writer, Reader or similar)
2. Add some entries (especially for yourself)
3. PowerApps - View - Data sources - Add data source (your new List)
4. Left panel in powerapps studio, select first entry called "App"
5. Dropdown above has "Properties" in this case these are more events like "OnStart"
6. In this function you can do stuff when your app starts like 

7. ClearCollect(userRoles,NAMEOFYOURDATASOURCE);
   Set(currentUser,User());
   Set(role,First(Filter(userRoles,User.Email=currentUser.Email)).Role.Value);
   Set(isAdmin,role="Admin");

8. This results in...if current users email is in the list and its role is called admin, then set variable isAdmin to true
9. Then you can bind your fields visibility to isAdmin and
10. you are done 

[tested1]

Thank you @Anonymous 

I created the new list, and added the Clearcollect...formula to my 'App' 

I get this error (see pic) but also when I click on visibility under advanced and try typing 'isAdmin' it gives an error or its not recognised?

[Anonymous]

@tested1  sorry but your picture tells nothing about the error. what error?

the only thing i can see is that your ClearCollect contains an illegal parameter.

https://docs.microsoft.com/de-de/powerapps/maker/canvas-apps/functions/function-clear-collect-clearc...

ClearCollect( Collection, Item, ... )

• Collection – Required. The collection that you want to clear and then add data to.
• Item(s) - Required. One or more records or tables to add to the data source.

I guess that your problem with the isAdmin is a consequential error because your formula contains an error.