How to hide list columns in SharePoint webpart based on user role?

Question

How to hide list columns in SharePoint webpart based on user role?

Power Platform Resource 1

Hi,

I am successfully hiding list view columns in web part based on user role using following script line.

$("div.ms-vh-div[DisplayName='Column X']").attr("style", "display: none");

but it's hiding only div tag but keeping the extra space as shown in pic. How to hide this extra space?Any help would be greatly appreciated.

Thank you in advance.

ZhengyuGuo 10,586 Reputation points Moderator

2021-01-20T03:01:39.163+00:00

Hi @Power Platform Resource ,

Is there any update ? Have you tried the code in the answer and did it work for you ?

Thanks
Best Regards

1 answer

Your answer

ZhengyuGuo 10,586 Reputation points Moderator

2021-01-20T03:01:39.163+00:00

Hi @Power Platform Resource ,

Is there any update ? Have you tried the code in the answer and did it work for you ?

Thanks
Best Regards

Answer 1

ZhengyuGuo 10,586 Moderator

Hi @Power Platform Resource ,

Please use the JsLink code in attachment file to hide specific column in list view web part, it will hide column and won't leave the extra space:

57472-jslink.txt

Remember to change the field name in the code (red line) below with yours so that it will work as expected:

Thanks
Best Regards

If an Answer is helpful, please click "Accept Answer" and upvote it.
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.

Power Platform Resource 1 Reputation point

2021-01-20T15:16:48.193+00:00

Thank you for your comments. The code is working in one site but in prod site, it's hiding only header but not the column values.

I am wondering why it is happening like this. ANy suggestion?
ZhengyuGuo 10,586 Reputation points Moderator

2021-01-21T01:42:18.937+00:00

Hi @Power Platform Resource ,

In my side, the code snippet can hide the whole column which included the column values, see the two capture below (before/after):

Before:

After:

As the code is working in the one site but not for prod site, can you please provide the details about the target column ? What's the column type and column name ?

Thanks
Best Regards
Power Platform Resource 1 Reputation point

2021-01-21T01:48:47.443+00:00

Thank you for your comments. Column type is multiple lines of text. Type of text is Plain Text.

Number of lines: 10
ZhengyuGuo 10,586 Reputation points Moderator

2021-01-21T03:26:30.807+00:00

Hi @Power Platform Resource ,

I create a Plain Text multiple lines of text field like this name "MultiLineField":

Change field name in the code snippet:

It's still working as expected:

Before

After

Since I can't reproduce the issue the same as in your side, I suggest you can create a new list and test if the code works in Prod site.
Power Platform Resource 1 Reputation point

2021-01-21T03:36:21.61+00:00

Sorry for bothering you.

It's working for multiline text field in my dev site too but not in prod site and it's working fine for person or group field as well(in both dev as well as prod). But I am not sure why it's not working for multiple line text fields in prod site. I tried for multiline columns with data and with no data and issue exists for both.
ZhengyuGuo 10,586 Reputation points Moderator

2021-01-21T04:07:33.62+00:00

Hi @Power Platform Resource ,

Is there any other script in Prod list view page ? As the script is working for dev multiline field, so it should be also working for prod's.

I can't see your prod site but a common troubleshooting way is using Developer Tool (F12) to check out if there is any script error or some other script which could affect the result.

By the way, what's the multiple line field name in prod site ? Is there any special character within field name like space or _ ?
Power Platform Resource 1 Reputation point

2021-01-21T04:10:54.2+00:00

there is a script for navigation. It is in both dev and prod sites.
ZhengyuGuo 10,586 Reputation points Moderator

2021-01-21T04:13:13.317+00:00

@Power Platform Resource ,

What's the real multiple field name in prod site can you give a screen capture about this field name ?
ZhengyuGuo 10,586 Reputation points Moderator

2021-01-21T04:22:30.663+00:00

Suppose there is a space for the field name like "Mul Field", then should use the field internal name Mul_x0020_Field, you can find the internal name using Developer Tool (F12):

Please check this point and use field internal name to see if it works in Prod site.
Power Platform Resource 1 Reputation point

2021-01-21T04:31:09.593+00:00

I am using internal field name only as you said.
ZhengyuGuo 10,586 Reputation points Moderator

2021-01-21T04:34:48.78+00:00

Try to copy and paste the code into Browser Console like this:

Then press Enter to see if it works.
ZhengyuGuo 10,586 Reputation points Moderator

2021-01-22T02:01:55.197+00:00

What's the result from Console ? Did it hide the column in list view ?
Power Platform Resource 1 Reputation point

2021-01-22T19:30:41.15+00:00

Yes, it's working in console.
ZhengyuGuo 10,586 Reputation points Moderator

2021-01-25T00:42:51.05+00:00

As it's working in Console, that means the code snippet is working to hide multiple line text field in Prod site.

You can try to debug through Developer Tool to see if the code line executed.
Power Platform Resource 1 Reputation point

2021-01-26T02:44:38.073+00:00

I think code line executed. But just for confirmation, may I know what should I check whether it is executed or not?
ZhengyuGuo 10,586 Reputation points Moderator

2021-01-26T09:23:25.097+00:00

Add break point in Developer Tool (F12) in the code line to see if the break point triggered, please learn about debug Script with Developer Tool here:

https://javascript.info/debugging-chrome

Share via

How to hide list columns in SharePoint webpart based on user role?

1 answer

Your answer