Share via

How can I lock down column in a SP List, from being changed once populated by a flow?

Leigh Hess 45 Reputation points
2023-10-03T14:33:22.56+00:00

I have a power automate flow that populates a status column once someone approves an item from a notification, but how do I lock that column so approvers can't manually change the status? This column is always updated by the flow, but people are manually changing it. How do I lock it down so only Power Automate can update the column?

Microsoft 365 and Office | SharePoint | For business | Windows
0 comments
Accepted answer
  1. Yanli Jiang - MSFT 31,606 Reputation points Microsoft External Staff
    2023-10-04T07:37:28.1033333+00:00

    Hi @Leigh Hess ,

    You can use the built-in column Approval Status to display the approval status. This column cannot be modified manually:

    User's image

    Then add the Set content approval status action at the appropriate location in the flow. Through this action, the value of this column can be modified:

    10041

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.