Nov 09 2022 07:07 AM
Hi!
Could you help me please, how can I hide column Employee, If the creator of the item is not me?
What is the formula to write here?
I don't want to show this field in edit form if I didn't create this item.
Nov 09 2022 09:08 AM
Solution@Pavel48n0sh Unfortunately, this will not work using conditional formula in SharePoint. As per the current design, you can refer only those columns which are shown on list forms in your formula.
Check more information at: Can ID column be displayed when configuring a list form header using JSON?
You have to customize the list form using power apps and show/hide it using formula. Set Visible property of respective data card / control to something like:
ThisItem.'Created By'.Email = User().Email
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.
Nov 09 2022 09:08 AM
Solution@Pavel48n0sh Unfortunately, this will not work using conditional formula in SharePoint. As per the current design, you can refer only those columns which are shown on list forms in your formula.
Check more information at: Can ID column be displayed when configuring a list form header using JSON?
You have to customize the list form using power apps and show/hide it using formula. Set Visible property of respective data card / control to something like:
ThisItem.'Created By'.Email = User().Email
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.