Hello,
In a SharePoint List I have three columns, which I want to correspond to three different persons and allow to a fourth one to see all of them.
For example, I want a person to see Decision and Item Status columns exclusively, a second one to only access Decision 1 and Item Status 1 etc, and a fourth person to be able to see all of these columns.
Does anybody know how I could do that?
You can show/hide the columns from "list form" conditionally using Power Apps customized list forms. Check: Customize a Microsoft Lists or SharePoint form by using Power Apps
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
ganeshsanap could you please advise me on this? So far I have tried the following but with no results.
geoT3211 If you are using person or group field (single selection) in your list to store the name of user for whom you want to show/hide the column from list form, you can use formula like:
=if([$Owner.email] == @me, 'true', 'false')
Where [$Owner] is an internal name of your person or group column in SharePoint list in this format: [$InternalNameOfColumn]. You can get the internal name of your SharePoint list columns by following this article: How to find the Internal name of columns in SharePoint Online?
You will have to repeat the similar formula for all your list fields you want to show/hide conditionally.
Documentation: Show or hide columns in a SharePoint list or library form
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.