Answered

How to Create Admin and User View in Gallery

(0) Share

Report

Posted on by Aldous345

Hi,Everyone

Please Help me with this situation I am new to powerapps I have a sharepoint list named LeaveForms In sharepoint list I have these Columns Employee Name(Person or group); Employee Id(Single line of text); Leave Duration(Choice); Reason(Multiple lines of text). In one Screen I want to Display Edit Form that perfectly Working.

In another Screen is Gallery Screen .In this I want to Display the items in Single gallery View for below situation:

1.User Only able to view his items

2.Admin able to view all items

How to filter items based on above condition for filtering items in sharepoint list and display to gallery . Please help

Thanks and Regards

Aldous

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

AlexLe256 47 on at

Like (1)

Report

Hello @Aldous345 ,
You can change the datasource of the gallery by this formula:

If(LookUp(sharepointlist,EmployeeName =User().FullName).Role="admin",sharepointlist,Filter(sharepointList,EmployeeName =User().FullName)).

Was this reply helpful? Yes No
Verified answer

SantoshSarnobat 30 on at

Like (1)

Report

Hello @Aldous345 , Not sure if you already have admins defined in AD or SharePoint.

You can create a SharePoint list "ConfigList" to manage list of admins and similar stuff. This list will only have Users column(Person or group) and create entry as title = Admin and Users= user1@mail.com .

Now, we can query this list in PowerApps to check if current logged in user is admin or non-admin user and populate gallery items accordingly similar to what @AlexLe256 has suggested.

Set items property of gallery control
=If(LookUp('ConfigList',Title = "Admin" && User().Email in People.Email), LeaveForms, Filter(LeaveForms, 'Employee Name'.Email=User().Email))

This solution will help you to achive desired result for your usecase.

Feel free to ask questions if you have any queries with this solution.

Was this reply helpful? Yes No
Aldous345 52 on at

Like (0)

Report

Thank you @AlexLe256

Was this reply helpful? Yes No
Aldous345 52 on at

Like (0)

Report

Thank you Its worked @SantoshSarnobat

Was this reply helpful? Yes No