This is a simple and usefull tip to use in Sharepoint. In a scenario that you have a column that is only updated by a Flow, you need to get a workaround to garantee that the users cannot change the value.

Note that this post will not show how to update the value via Flow.

Lets consider for this example that we want to create a column Status that is updated by a Flow.

Go to the list settings and create the column Status. We recommend to put the suffix _Hidden_ in the name to become easier to identify.

Create Column _Hidden_FlowStatus

Now create a calculated column that contains the status column in the formula.

Create calculated column Flow Status

Go to List settings -> Advanced Settings and Select Allow management of content type then press Ok.

List settings -> Advanced Settings
Allow management of content type

With this we can change the settings of content types. Now in the Content types list, click in the content type definition

content types list

, and click in the _hidden column.

content type settings

Set the column setting to Hidden and click Ok.

Set column has hidden

Finally, go to the list views definitions and show the calculated column insted of the hidden collumn.

Edit list view

This way even if the user go to the quick edit, it cannot edit the column value

Quick edit view

7 Comments

Stefan · July 30, 2020 at 7:57 pm

Hi. It does not work. :/

Error message after creating the calculated column: “the formula is related to a column which does not exist” …

John · October 13, 2020 at 5:26 am

Do you have a trick that achieves this requirement for a field of type Person/Group? These fields cannot be referenced in a calculated column. I want a Flow to set the value of a Person/Group field, based on other metadata in the same item, but not allow the users to edit the Person/Group field, not even in Datasheet views (where I still need to display it for reference), and I also want to be able to apply a [Me] filter on this field, so it must be a Person/Group field for that reason. Hope you can help!

    Valter Lima · March 16, 2021 at 6:14 pm

    Hi John,
    Sorry for the late response. Are you still having this issue?
    If yes, what i would suggest is to add a new field(Text Field) in the sharepoint list.
    In the flow fill with the display name.
    Now you can use a calculated field of the new field

Beata · December 3, 2020 at 3:09 pm

Thanks so much for this article. It is a brilliant solution!

peppon · February 19, 2021 at 2:32 am

Superb!!

    Valter Lima · March 16, 2021 at 5:52 pm

    Thanks! 🙂

Heather · April 14, 2021 at 3:43 pm

This worked perfectly to make sure the approvals changed after a manager approve/reject an item from the list. I would not have figured this out on my own.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: