Want to Hide Column for Specific SharePoint group in Customized Power App form

(0) Share

Report

Posted on by Personallearn

Hi All,

We have customized SharePoint form using Power App and in this form we have one field (i.e column) Request Status.

We want to show this Column in form only to Evaluation SharePoint group apart from this group all other users cannot see this field (column) in customized power app form.

Do we have any functionality in Customized Power App to show column only to one SharePoint group and for other it should hidden.

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Personallearn ,
There are 2 ways to do this -
1. Using Power Apps
Create a new list named PermissionHandle in your site. Add an item in that list with title column value - "Evaluation" and set the item level permission to Evaluation sharepoint group only. In your power apps add this list as a datasource and on App Start property you can use a variable to check if user is in that group -
Set(varIsAdminUser, If(IsBlank(LookUp(PermissionHandle , Title="Evaluation")), false, true))
2. Using Power Automate
You can call a flow on AppStart property and pass current logged in user's email id as a parameter. In power automate flow you can use rest api to check if user is in Evaluation group or not.

Was this reply helpful? Yes No
Personallearn 56 on at

Like (0)

Report

Hi @NandiniBhagya20
But with this how I can show specific field like from 10 column I want to show/hide only 1 column how I can achieved.

we have 2 groups working on this form(Test1 and Test2) and I want to hide status column from Test1 but Test2 can see the column in same form.

Was this reply helpful? Yes No
Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Personallearn ,
Create a new list named PermissionHandle in your site. Add two items in that list with title column value - "Test1" & "Test2" and set the item level permission to "Test 1", "Test 2" sharepoint groups respectively. In your power apps add this list as a datasource and on App Start property you can use a variable to check if user is in that group -
Set(varTest1User, If(IsBlank(LookUp(PermissionHandle , Title="Test1")), false, true)); Set(varTest2User, If(IsBlank(LookUp(PermissionHandle , Title="Test2")), false, true))
Now you can go to Visible property of the field which should only be visible to members in Test1 group and add below formula - varTest1User

Was this reply helpful? Yes No
Personallearn 56 on at

Like (0)

Report

Hi @NandiniBhagya20

Thanks your solution works

Was this reply helpful? Yes No