web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to trigger locking...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 19

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

Categories:
I have the same question (0)
  • v-bofeng-msft Profile Picture
    on at

    Hi @MMORGAN ,

     

    I've made a test for your reference:

    vbofengmsft_1-1678845437376.png

    Best Regards,

    Bof

     

  • Verified answer
    MMORGAN Profile Picture
    19 on at

    Thank you! I haven't been able to test yet, but this is exactly what I was looking for. I really appreciate your help. 

  • MMORGAN Profile Picture
    19 on at

    @v-bofeng-msft 

    We have tried your reference but are getting an error on our end:

    MMORGAN_0-1679935091173.png

    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? 

  • MMORGAN Profile Picture
    19 on at

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

     

    Thank you

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard