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

Microsoft 365 and Office SharePoint For business Windows
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. CaseyYang-MSFT 10,461 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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.