enforce unique value with the item permission issue!!

%3CLINGO-SUB%20id%3D%22lingo-sub-2366828%22%20slang%3D%22en-US%22%3Eenforce%20unique%20value%20with%20the%20item%20permission%20issue!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2366828%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20All%20Experts%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20requirement%20is%3C%2FP%3E%3CP%3E1.%20some%20columns%20need%20to%20have%20a%20unique%20value.%3C%2FP%3E%3CP%3E2.%20only%20users%20who%20created%20that%20item%20can%20see%2Fedit%20their%20own%20item%20and%20the%20others%20can't%20see%2Fedit%20it.%3C%2FP%3E%3CP%3E3.%20the%20approver%20can%20access%20the%20link%20of%20the%20list%20item%20that%20the%20user%20sends%20the%20approval%20request%20to.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20this%2C%20I'm%20turn%20on%20the%20versioning%20history%20and%20select%20%22only%20users%20who%20can%20approve%20items%22.%20It%20works%20for%20No.1%20%26amp%3B%20No.2%20but%20the%20approver%20can't%20access%20the%20link.%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mmchx_6-1621397490044.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F281727iCC91671E22BDB85E%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22mmchx_6-1621397490044.png%22%20alt%3D%22mmchx_6-1621397490044.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EOn%20the%20second%20try%2C%20I%20turn%20off%20the%20versioning%20then%20I%20edit%20on%20item-level%20permission%20instead.%20It%20works%20for%20No.%202%20%26amp%3B%20No.3%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mmchx_8-1621397656206.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F281728i5CB4F433B114ED48%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22mmchx_8-1621397656206.png%22%20alt%3D%22mmchx_8-1621397656206.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BIs%20there%20have%20any%20way%20to%20achieve%20this%20requirement%3F%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2366828%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPermissions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Dear All Experts,

 

My requirement is

1. some columns need to have a unique value.

2. only users who created that item can see/edit their own item and the others can't see/edit it.

3. the approver can access the link of the list item that the user sends the approval request to.

 

I tried this, I'm turn on the versioning history and select "only users who can approve items". It works for No.1 & No.2 but the approver can't access the link.

 

mmchx_6-1621397490044.png

 

On the second try, I turn off the versioning then I edit on item-level permission instead. It works for No. 2 & No.3

mmchx_8-1621397656206.png

 

 Is there have any way to achieve this requirement? 

 

 

 

0 Replies