Show/Hide SharePoint list fields based on user

(0) Share

Report

Posted on by RaquelF

Hi,

I'm looking for a way to Show or Hide SharePoint list fields based on the user creating/editing a list entry.

Example,

When adding a new item in a SharePoint list, based on who is the user that is creating this new entry, I want to show only certain fields, and those same fields to be hidden if a different user is editing the same list entry.

I want to show/hide fields on a SharePoint list "Add items" and "Edit Item" forms based on the users or users' role.

Any help will be appreciated.

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

365CornerDawid 377 on at

Like (1)

Report

Hey @RaquelF

If I get your question right.
In SharePoint if you are creating new item in the List the Created By fields is populated with the object of the User who created that entry 🙂
Next if User who Created item is editing the same item you can check if the Current User = Creator.
For that you have quite a lot of approaches. The base is to use User() function which returns information like Email - User().Email
The result of that function User().Email you can use to compare with CreatedBy.Mail

User().Email = CreatedBy.Mail is the giving you boolean result true / false which you can utlize in Visible property of every control = to show / hide fields.

If I may suggest only to use variable insted of such comparison if all places = better performance 🙂

Hope it will help you 🙂

Was this reply helpful? Yes No
RaquelF 60 on at

Like (0)

Report

Hi @365CornerDawid

Thanks for your reply. I want to have one SharePoint list where entries are created and edit by users with different roles. One role is a super user that can edit all fields in the "Add" and "Edit" list forms, and the other is simple user that can edit only certain fields in the "Add" and "Edit" list forms.

Is there a way I can create two(2) separate "Add items" list forms where I can customize which fields that are shown. This way the user that is logged in, based on their user role, will access the list form that I want them to. The same will apply to the Edit List Form.

Thanks,
Raquel

Was this reply helpful? Yes No