How to trigger locking a document for editing when column dropdown type changes

Like (0) Share

Report

Posted on 13 Mar 2023 16:13:56 by MMORGAN

Hello, I have a SharePoint column called Approval Status with drop down options.

I would like to automatically lock the document for editing when a specific option is selected "Approved", and automatically unlock the document when the status changes to any other drop down option.

Is there any way to trigger a lock when a specific choice is selected?

Thank you

All responses (4)

Answers (1)

MMORGAN 19 on 29 Mar 2023 at 17:57:11

Like (0)

Report

Re: How to trigger locking a document for editing when column dropdown type changes

Hello, we will only need to deploy to one site.

Thank you
MMORGAN 19 on 27 Mar 2023 at 16:35:38

Like (0)

Report

Re: How to trigger locking a document for editing when column dropdown type changes

@v-bofeng-msft
We have tried your reference but are getting an error on our end:
Error:
InvalidTemplate. Unable to process template language expressions in action 'Get_changes_for_an_item_or_a_file_(properties_only)' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

Any assistance you can provide, please?

Repository image.PNG
Verified answer

MMORGAN 19 on 20 Mar 2023 at 17:09:50

Like (0)

Report

Re: How to trigger locking a document for editing when column dropdown type changes

Thank you! I haven't been able to test yet, but this is exactly what I was looking for. I really appreciate your help.
v-bofeng-msft on 15 Mar 2023 at 01:56:28

Like (0)

Report

Re: How to trigger locking a document for editing when column dropdown type changes

Hi @MMORGAN ,

I've made a test for your reference:

Best Regards,

Bof