Formatting column to hide button based on created by or author

Copper Contributor

Hi I'm trying to format a column so that a Submit button that triggers a flow is to be only visible for the person who created the item. 

 

Columns real names are Submit and Author

Submit is Single line of text column.

Author is a Person or Group column.

GCGJH_0-1684865457974.png

I know I have to added a visibility line to the formatting but I'm not sure what to put.

GCGJH_1-1684865612732.png

I tried "visibility": "=if(((indexOf([$Author],'[Me]')) == 0),'hidden', 'visible')" but it didn't work.

Any help is appreciated!

 

2 Replies

@GCGJH this should work:

 

"display": "=if([$Author.email]==@me, 'visible','hidden')"


 

@GCGJH Try adding below inside style:

 

"display": "=if([$Author.email]==@me,'block','none')"

 

OR 

 

"visibility": "=if([$Author.email]==@me,'visible','hidden')"

 

Where Author is the internal name of your SharePoint person column. You can get the internal name of your columns by following this article: How to find the Internal name of columns in SharePoint Online 


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.