SharePoint Modern list Column conditional show/Hide

Sanjay Adsure 1 Reputation point
2021-10-22T05:06:46.78+00:00

Hi All,

Working on SharePoint Modern List. Applied List & Column formatting colors for various conditions. Now have a requirement like below:

If Owners are logged in then show 'Action' & 'Remark' columns
If other than Owners are logged in then hide 'Action' & 'Remark' columns

Can we apply show/hide logic depending upon the user logged in? Can this be feasible using Out of Box way? If not, what other options I am having?

Thanks,
Sanjay

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,617 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CaseyYang-MSFT 10,321 Reputation points
    2021-10-22T08:15:04.293+00:00

    Hi @Sanjay Adsure ,

    Per my test, we can only show/hide columns in a list or library form such as New/Edit forms: Show or hide columns in a list or library form

    And there is no available option to show/hide column conditional in list view. I would suggest you create two list with lookup column as a workaround.

    1.Create one list without "Action" "Remark" columns(this list for users). For example:

    142903-1.png

    2.Create another list with "Action" "Remark" columns(this list for owners). And create lookup column get information from user list.

    142808-2.png 142868-3.png

    3.Set unquie permissions for Owner list.
    Settings > List settings > Permissions for this list > Stop Inheriting Permissions

    142885-4.png

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.